Mastering Excel 2021 – Intermediate


Objectives. You will be able to:

  • Use Flash Fill, Text to Columns, and Group Mode to work with your data
  • Use editing features such as Find and Replace, proofing options, and research tools to refine your workbook
  • Modify workbook views
  • Apply conditional formatting to text, numbers, and dates
  • Apply custom number formatting
  • Use nested, logical, and statistical functions
  • Modify and format charts
  • Add sparklines, pictures, and SmartArt
  • Modify Tables, PivotTables, and web queries
  • Share workbooks
  • Use tools to enhance sharing such as hyperlinks, track changes, and comments
  • Analyze data with Goal Seek and Data Tables
ATS eLearning
Scroll to Top