Curriculum
- 16 Sections
- 91 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Introduction and Software installation1
- Module 1 - Understand Microsoft Excel interface4
- Module 2 - Basic Use of Excel4
- Module 3 - Data validation, Filtering, Importing & Exporting8
- 4.201 Sorting data in Excel10 Minutes
- 4.302 Filtering and using AutoFilter6 Minutes
- 4.403 Using conditional formatting for data visualization3 Minutes
- 4.503 Using conditional formatting for data visualization 211 Minutes
- 4.604 Data validation and Error handling11 Minutes
- 4.704 Data validation and Error handling 27 Minutes
- 4.805 Data Importing and exporting techniques6 Minutes
- 4.906 Practice question1 Minute
- Module 4 - Functions(Mathematical, Logical, Reference & others)9
- 5.101 Understand Formula syntax and structure10 Minutes
- 5.202 Working with basic Mathematical Functions6 Minutes
- 5.302 Working with basic Mathematical Functions 211 Minutes
- 5.403 Using Logical Functions10 Minutes
- 5.504 Exploring Lookup and reference Functions10 Minutes
- 5.604 Exploring Lookup and reference Functions 211 Minutes
- 5.704 Exploring Lookup and reference Functions 39 Minutes
- 5.805 Utilizing Date and time functions6 Minutes
- 5.906 Practice questions1 Minute
- Module 5 - Pivot table, Data analysis, Advanced filtering10
- 6.101 PivotTables and PivotCharts for data analysis12 Minutes
- 6.201 PivotTables and PivotCharts for data analysis 210 Minutes
- 6.302 Data analysis with what-if Scenarios10 Minutes
- 6.402 Data analysis with what-if Scenarios 28 Minutes
- 6.503 Advanced Filtering techniques8 Minutes
- 6.603 Advanced Filtering techniques 211 Minutes
- 6.704 Data consolidation with Analysis using power query7 Minutes
- 6.804 Data consolidation with Analysis using power query 211 Minutes
- 6.904 Data consolidation with Analysis using power query 312 Minutes
- 6.1005 Practice question1 Minute
- Module 6 - Customizing Charts7
- Module 7 - Advance Excel7
- 8.101 Using data tables for sensitivity Analysis13 Minutes
- 8.201 Using data tables for sensitivity Analysis 0212 Minutes
- 8.302 Goal seek for finding Desired results13 Minutes
- 8.403 โ Solver for optimization problems10 Minutes
- 8.504 โ Scenario Manager for Multiple scenarios Analysis11 Minutes
- 8.604 โ Scenario Manager for Multiple scenarios Analysis 26 Minutes
- 8.705 Practice question1 Minute
- Module 8 - Excel Macros6
- 9.101 Introduction to Excel Macros9 Minutes
- 9.202 Recording and running Simple Macros6 Minutes
- 9.303 Editing and Debugging Macros6 Minutes
- 9.404 Best practices for macros and security consideration3 Minutes
- 9.504 Best practices for macros and security consideration 22 Minutes
- 9.605 Practice questions1 Minute
- Module 9 - Power Query & Data connections4
- Module 10 - Time saving shortcuts, Data entry8
- 11.101 Time saving keyboard shortcuts12 Minutes
- 11.201 Time saving keyboard shortcuts 25 Minutes
- 11.302 โ Customizing Excel settings and options6 Minutes
- 11.403 Advanced printing and page setup Techniques10 Minutes
- 11.503 Advanced printing and page setup Techniques 212 Minutes
- 11.604 Efficient data entry methods7 Minutes
- 11.704 Efficient data entry methods 28 Minutes
- 11.805 Practice question1 Minute
- Module 11 - Protecting sheet4
- Module 12 - Advance Financial and statistical Functions9
- 13.101 Array Formulas and Array Functions11 Minutes
- 13.201 Array Formulas and Array Functions 2
- 13.402 Using INDEX MATCH for advanced Lookup8 Minutes
- 13.502 Using INDEX MATCH for advanced Lookup 27 Minutes
- 13.603 Working with text and string functions8 Minutes
- 13.703 Working with text and string functions 26 Minutes
- 13.804 Advanced financial and statistical functions9 Minutes
- 13.904 Advanced financial and statistical functions 29 Minutes
- 13.1005 Test question1 Minute
- Module 13 - Connecting Excel Data to PowerBI4
- Module 14 - Advance Data Analysis5
- Conclusion1