Этот материал пока недоступен на языке Русский — показан на другом доступном языке. Доступно на: EN
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
О курсе
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
Программа обучения
- 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
