Mastering Excel 2021 – Intermediate

Topics covered include:

Using Flash Fill, Text to Columns, and Group Mode to work with your data
Using editing features such as Find and Replace, proofing options, and research tools to refine your workbook
Modifying workbook views
Applying conditional formatting to text, numbers, and dates
Applying custom number formatting
Using nested, logical, and statistical functions
Modifying and formatting charts
Adding sparklines, pictures, and SmartArt
Modifying Tables, PivotTables, and web queries
Sharing workbooks
Using tools to enhance sharing such as hyperlinks, track changes, and comments
Analyzing data with Goal Seek and Data Tables