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.101 Sorting data in Excel10 Minutes
- 4.202 Filtering and using AutoFilter6 Minutes
- 4.303 Using conditional formatting for data visualization3 Minutes
- 4.403 Using conditional formatting for data visualization 211 Minutes
- 4.504 Data validation and Error handling11 Minutes
- 4.604 Data validation and Error handling 27 Minutes
- 4.705 Data Importing and exporting techniques6 Minutes
- 4.806 Practice question1 Minute
- Module 4 - Functions(Mathematical, Logical, Reference & others)9
- 5.001 Understand Formula syntax and structure10 Minutes
- 5.102 Working with basic Mathematical Functions6 Minutes
- 5.202 Working with basic Mathematical Functions 211 Minutes
- 5.303 Using Logical Functions10 Minutes
- 5.404 Exploring Lookup and reference Functions10 Minutes
- 5.504 Exploring Lookup and reference Functions 211 Minutes
- 5.604 Exploring Lookup and reference Functions 39 Minutes
- 5.705 Utilizing Date and time functions6 Minutes
- 5.806 Practice questions1 Minute
- Module 5 - Pivot table, Data analysis, Advanced filtering10
- 6.001 PivotTables and PivotCharts for data analysis12 Minutes
- 6.101 PivotTables and PivotCharts for data analysis 210 Minutes
- 6.202 Data analysis with what-if Scenarios10 Minutes
- 6.302 Data analysis with what-if Scenarios 28 Minutes
- 6.403 Advanced Filtering techniques8 Minutes
- 6.503 Advanced Filtering techniques 211 Minutes
- 6.604 Data consolidation with Analysis using power query7 Minutes
- 6.704 Data consolidation with Analysis using power query 211 Minutes
- 6.804 Data consolidation with Analysis using power query 312 Minutes
- 6.905 Practice question1 Minute
- Module 6 - Customizing Charts7
- Module 7 - Advance Excel7
- 8.001 Using data tables for sensitivity Analysis13 Minutes
- 8.101 Using data tables for sensitivity Analysis 0212 Minutes
- 8.202 Goal seek for finding Desired results13 Minutes
- 8.303 – Solver for optimization problems10 Minutes
- 8.404 – Scenario Manager for Multiple scenarios Analysis11 Minutes
- 8.504 – Scenario Manager for Multiple scenarios Analysis 26 Minutes
- 8.605 Practice question1 Minute
- Module 8 - Excel Macros6
- 9.001 Introduction to Excel Macros9 Minutes
- 9.102 Recording and running Simple Macros6 Minutes
- 9.203 Editing and Debugging Macros6 Minutes
- 9.304 Best practices for macros and security consideration3 Minutes
- 9.404 Best practices for macros and security consideration 22 Minutes
- 9.505 Practice questions1 Minute
- Module 9 - Power Query & Data connections4
- Module 10 - Time saving shortcuts, Data entry8
- 11.001 Time saving keyboard shortcuts12 Minutes
- 11.101 Time saving keyboard shortcuts 25 Minutes
- 11.202 – Customizing Excel settings and options6 Minutes
- 11.303 Advanced printing and page setup Techniques10 Minutes
- 11.403 Advanced printing and page setup Techniques 212 Minutes
- 11.504 Efficient data entry methods7 Minutes
- 11.604 Efficient data entry methods 28 Minutes
- 11.705 Practice question1 Minute
- Module 11 - Protecting sheet4
- Module 12 - Advance Financial and statistical Functions9
- 13.001 Array Formulas and Array Functions11 Minutes
- 13.101 Array Formulas and Array Functions 2
- 13.302 Using INDEX MATCH for advanced Lookup8 Minutes
- 13.402 Using INDEX MATCH for advanced Lookup 27 Minutes
- 13.503 Working with text and string functions8 Minutes
- 13.603 Working with text and string functions 26 Minutes
- 13.704 Advanced financial and statistical functions9 Minutes
- 13.804 Advanced financial and statistical functions 29 Minutes
- 13.905 Test question1 Minute
- Module 13 - Connecting Excel Data to PowerBI4
- Module 14 - Advance Data Analysis5
- Conclusion1