Intermediate Microsoft Excel 2019

Participants learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. In addition, participants learn to create macros that let you manipulate data with the push of a button. Lesson 1 - Excel Charts and Graphs Lesson 2 - More Excel Charts Lesson 3 - AutoFilter and Sorting Lesson 4 - Goal Seeking Lesson 5 - Pivot Tables Lesson 6 - Advanced PivotTables Lesson 7 - Solver Lesson 8 - Sparklines Lesson 9 - Macros Lesson 10 - Introduction to Functions Lesson 11 - Math/Trig Functions Lesson 12 - VLOOKUP, INDEX, and MATCH Functions