Modern Excel Analyst in a Day
The workshop explores advanced Excel capabilities, integration of Excel with Power BI, Microsoft Teams & SharePoint Online, empowering Modern Excel analysts.
- Course Info
- Instructor
- System Requirements
- What to know beforehand
Course Description
Course Outline ( Free Preview)
Modern Excel Analyst in a Day - What you need to get started
Module 00 - Class Introduction 8 min.
Module 01A - Analytics in Excel (Overview) 42 min.
Module 01B - Analytics In Excel (Lab 01A - Using Power Query In Excel) 30 min.
Module 01C - Analytics In Excel (Understanding Data Models) 20 min.
Module 02A - Mapping Learning to Power BI (Overview) 13 min.
Module 02B - Mapping Learning to Power BI (Lab 02A - Import to Power BI Desktop) 17 min.
Module 02C - Mapping Learning to Power BI (Working with Power BI Desktop) 31 min.
Module 02D - Mapping Learning to Power BI (Lab 02B - Using Power BI Desktop to Build a Data Model) 58 min.
Module 03A - Power BI + Excel Better Together (Overview) 25 min.
Module 03B - Power BI Excel Better Together (Lab 03A - Creating an Excel Report Using a Power BI Dataset - Analyze in Excel) 27 min.
Module 03C - Power BI + Excel Better Together (Lab 03B - Creating an Excel Report Using a Power BI Dataset - Insert PivotTable) 32 min.
Module 04 - Power BI and Office Better Together 13 min.
Module 05 - Questions and Wrap Up (What's Next?) 8 min.
This course includes:
- 5+ hours of training
- 14 Modules
- * Access on mobile and browser
- Certificate of Completion
