fbpx

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

Sign In
Start Learning

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
Sign-up for Free Trial
This course includes:
  • 5.02 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

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
"Really good and well structured. One of the best classes I've enrolled in."

João Coelho

"Great presentation and examples!"

- Modern Excel Analyst in a Day Student

"The presentation and demos was really helpful and learned few tricks in Excel and Power BI. Thank you."

- Modern Excel Analyst in a Day Student

Related products

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!

Sign-up for Free Trial