Mastering Excel 365 - Intermediate (2022)

Become Qualified & Take Your Career To The Next Level

$49.00

Duration 3 Hours 32 mins.

Learn many of Excel’s tools for analyzing and sharing your data

Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you’ll learn great tools to modify your data and refine your workbook.  Excel expert Kathy Jones will also show you how to nest functions and modify and format charts.
You’ll even learn to enhance your visualizations by adding sparklines, pictures, and SmartArt. And if you need to work with others, you’ll learn some great tools available when sharing your workbooks, including comments, hyperlinks, track changes, and share options.

By the end of this course, you will be able to:

null

Use Flash Fill, Text to Columns, and Group Mode to work with your data

null

Modify workbook views

null

Apply conditional and custom formatting to text, numbers, and dates

null

Use nested, logical, and statistical functions

null

Modify and format charts, Tables, PivotTables, and web queries

null

Add sparklines, pictures, and SmartArt

null

Use tools to enhance sharing such as hyperlinks, track changes, and comments

null

Analyze data with Goal Seek and Data Tables

GET 20% OFF THIS ONLINE TRAINING WHEN YOU SUBSCRIBE TO OUR NEWSLETTER.

Start your new career today

Sign up here!