Beginner's Level: Getting to know Excel GUI, Working with a worksheet, Selecting Ranges/Filling Data, Understanding and working with formulas and function, Cell and Formula Referencing, Font/Number Formatting Techniques, Printing/Page Setup.
Intermediate Level: Defined Names/Named Range, Complex Functions, Conditional Formatting, Tables, Charts, Subtotalling and Grouping, Data Linking.
Advanced Level: Data Validation, Dynamic Arrays, Logical Functions, Lookup Functions, Pivot Table, Power Query, Scenarios/Solver
Introduction Level: Introduction to Power BI, Importing Data from Various sources, Creating Simple data visualizations, Publishing & Sharing reports
Advanced Level: Report Building, Report Visualization, Optimising Your Report Design, Governance & Distribution.
Introduction to DAX: Common DAX Functions, Defining Calculated Columns, Defining Measures, Aggregate Functions, Using Filters with Table and Calculated Functions.
Advanced DAX: Creating Measure Table, Using Variables, Time Intelligence Calculation, Using Parameters, What-if Scenarios, Forecasting.