NEED HELP? TALK TO AN EXPERT (904) 638-5743

Modern Excel Analyst in a Day

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • 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:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

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

Outline

 

Module 00 | Class Introduction
15m 18s total

 

Module 00A | Class Introduction
15m 18s

 

Module 01 | Analytics in Excel
116m 36s total

 

Module 01A | Overview
52m 52s

 

Module 01B | Lab 01A – Using Power Query and Power Pivot In Excel
40m 45s

 

Module 01C | Lab 01B – Using Power Pivot in Excel & Time Intelligence Measures
23m 39s

 

Module 02 | Mapping Learning to Power BI
103m 31s total

 

Module 02A | Overview
35m 28s

 

Module 02B | Lab 02 – Using Power BI Desktop to Build a Report
68m 03s

 

Module 03 | Power BI + Excel Better Together
45m 90s total

 

Module 03A | Overview
22m 48s

 

Module 03B | Lab 03 – Creating an Excel Report Using a Power BI Dataset
23m 42s

 

Module 04 | Power BI + Office Better Together
10m 51s total

 

Module 04A | Power BI + Office Better Together
10m 51s

 

Module 05 | Wrap-Up
09m 14s total

 

Module 05A | Wrap-Up
09m 14s

Instructor

DANIEL STRAITIFF

Training Content Manager

Daniel Straitiff is a Trainer, Consultant, and Training Content Manager for Pragmatic Works specializing in the Power Platform. An Air Force veteran with a background in technology and broadcast media, he has the skills to develop high quality training content and provide engaging learning experiences. With Microsoft Certifications in Power BI, Power Automate, and the Power Platform, Daniels efforts are currently focused on helping our customers learn and master the Power Platform.

System Requirements

What to Know Before Class

  • A basic understanding of Excel is helpful but not required for this class.
REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required