Description
Module 1: Elementary to Advanced
- Formatting and printing worksheets
- Creating charts and graphs
- Advanced formulas and functions, including logical, statistical, and financial functions
- Pivot tables and data analysis tools
- Macros and automation.
- Data visualization and dashboarding
Module 2: Formulas that you will learn
- Sum, Average, Count
- Sorting, Filtering, and Conditional formatting
- IF statements, V/HLOOKUP, PivotTables, Indexing
- Creating & customizing visual representations of data
- Automating repetitive tasks with VBA
- Advanced charting techniques
- Regression analysis, solver, and scenario analysis
- Importing and exporting data
- Database functions, and data validation
