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.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

The workshop explores advanced Excel capabilities, integration of Excel with Power BI, Microsoft Teams & SharePoint Online, empowering Modern Excel analysts.

This course includes:

5+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

The workshop aims to bring awareness of advanced capabilities available in Excel, to empower Modern Excel analysts to see what’s possible, to explore how Excel & Power BI are best used together and how Excel & Power BI can be integrated in Microsoft Teams & SharePoint Online. Upon completion of this workshop attendees will: - **Have Awareness** of Power Query & Power Pivot in Excel (Modern Excel) - **Learn** how Power Query & Power Pivot in Excel can improve efficiency, provide reusable seamless solutions and transform existing manual reporting into actionable insights - **Understand** how Modern Excel maps into Power BI Desktop - ******Identify****** opportunities to use Excel & Power BI together - **Integrate** Excel & Power BI solutions into Microsoft Teams & SharePoint

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

Jonathon Silva

Power Platform Trainer

Jonathon Silva is a Power Platform Expert, Trainer and Consultant at Pragmatic Works. He has a decade of experience as a high school teacher, which he leverages to design and deliver engaging and practical training courses. Jonathon is also a Microsoft Certified Trainer and a Lead Instructor and Train-the-Trainer for Microsoft in a Day events, such as Automation in a Day (Power Automate), App in a Day (Power Apps) and Dashboard in a Day (Power BI). He is also a Power Automate Specialist who creates and shares valuable content on blog and YouTube platforms, offering guidance and insights on how to build effective workflows, apps, reports, and SharePoint sites.

Learn More

This course includes:

5+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

**Download Details:** Please download and unzip the following class files to you root directory C:\ [Click to download](https://assetsprod.microsoft.com/mpn/en-us/maiad-attendee.zip) **Requirements:** - Windows 8 / Windows Server 2008 R2, or later - Excel 2016 64-bit is recommended for using Power Pivot In Excel & also includes Power Query - Latest version of Power BI Desktop 64-bit (Download from App Store) - Microsoft Edge (based on Chromium) recommended—or, another web browser supported by Power BI

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