Artificial Intelligence
Microsoft Excel
In this course, we’ll take you from the absolute basics of Excel all the way to AI-driven workflows with Copilot. You’ll gain hands-on experience with 10,000-row datasets , automate data with Power Query , and master one-click tasks using VBA macros. From complex functions to building professional interactive dashboards, we cover it all through real-world projects. Finally, you’ll get a head start by learning about the international MOSE exam format and receive our certificate of completion
About this course
In this course, we’ll take you from the absolute basics of Excel all the way to AI-driven workflows with Copilot. You’ll gain hands-on experience with 10,000-row datasets , automate data with Power Query , and master one-click tasks using VBA macros. From complex functions to building professional interactive dashboards, we cover it all through real-world projects. Finally, you’ll get a head start by learning about the international MOSE exam format and receive our certificate of completion
Training program
- 1 1. Excel Interface and Data Formatting
- 2 2. Basic Functions and Cell References
- 3 3. Conditional Formatting and Data Cleaning
- 4 4. Data Validation and Error Handling
- 5 5. Logic Functions (IF, AND, OR, IFS, SWITCH)
- 6 6. Lookup Functions and Module 1 Project
- 1 7. Multi-Condition Aggregation (SUMIFS, SUMPRODUCT)
- 2 SUMPRODUCT and Advanced Calculations
- 3 8. Text and Date/Time Functions
- 4 9. PivotTable, PivotChart and Slicer
- 5 10. Power Query: Import, Clean, Transform
- 6 11. Power Pivot, VBA and Workbook Protection
- 7 12. Visualization, Chart Design and Module 2 Project
- 1 13. Dashboard Design and Data Storytelling
- 2 14. Copilot and Prompt Engineering
- 3 Prompt Engineering for Excel
- 4 Prompt Engineering for Excel
- 5 15. MOSE Exam Information
- 6 16. Final Project Lab and Assessment
