Curriculum for people learning Excel
1 Learn Excel basics
Learning objectives
Explore efficient methods for adding functions and formulas.
Format text, numbers, dates, and times.
Save, share, and print your workbooks.
Recognize how to freeze panes to control your view.
Recall methods for protecting documents.
2 Microsoft Excel Tutorials
Specific tutorial for a range of basic Excel skills
3 Analyzing and Visualizing Data
4 Advanced formulas and functions
https://www.linkedin.com/learning/excel-advanced-formulas-and-functions/use-the-most-powerful-formulas-and-functions-in-excel
5 Pivot Tables and Pivot Charts
https://www.linkedin.com/learning/excel-pivottables-mastering-pivottables-and-pivotcharts/part-1-introduction
6 Macros and VBA for beginners
7 Data analysis using Excel
https://www.linkedin.com/learning/excel-introduction-to-macros-and-vba/save-time-with-excel-macros-and-vba
Introduction to data analysis using Excel
What you'll learn
Create flexible data aggregations using pivot tables
Represent data visually using pivot charts
Calculate margins and other common ratios using calculation on pivot table
Filter data using slicers in multiple pivot tables
Create aggregate reports using formula based techniques
Micsoft/Edx Training on Data analysis using Excel