Modern Excel Analyst in A Day

Go from data to insights with Excel & Power BI.

Modern Excel Analyst in a Day is a one-day workshop for analysts. It demonstrates the advanced capabilities available in Excel, explores how Excel and Power BI are best used together, and shows how to successfully work with them in Microsoft Teams and SharePoint online.
Excel users often struggle with data wrangling, especially when trying to combine data from multiple tables or sources. This is where Power Query and Power BI can help! Stop shoveling data and start analyzing it!

At the end of the day, attendees will better understand how to:

  • Have awareness of Power Query & Data Models
  • 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

Workshop Outline

Module 00 | Class Introduction
Module 01 | Analytics in Excel
Module 02 | Mapping analytics in Excel to Power BI—Compare Excel and Power BI desktop.
Module 03 | Power BI + Excel Better Together
Module 04 | Power BI + Office Better Together
Module 05 | Wrap-Up
Line graphic of a computer and gears

Let’s Schedule Your Team’s Microsoft Workshop

Newcomp Analytics can deliver your workshop on-site at your location, in classrooms across Canada or via an instructor-led online format.

This private hands-on workshop is for a maximum of 12 students. All students will receive a manual and access to the data set for the session.

Contact us for pricing details!

Power BI Workshops
First Name
Last Name
Which Power BI workshop are you interested in?