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.
![](https://learning.pragmaticworkstraining.com/api/upload/GetCourseImage/58029658-b3a5-42d0-99ec-5ee71fbf68a9.png)
- What you'll learn
- Course Description
- Course Outline
- Instructor
- System Requirements
- What to know beforehand
What you'll learn
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Description
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Outline
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.
Class Survey
Module 05 - Questions and Wrap Up (What's Next?) 8 min.
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Instructor
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
System Requirements
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
What to know before class
This course includes:
- 5+ hours hours of training
- Access on mobile and browser
- Certificate of Completion