Welcome to ONLC Training Centers
  1. Home
  2. Courses
  3. Power BI
  4. Power BI Introduction for Excel Users

Power BI Introduction for Excel Users Course

Class Dates
(click date for class times)
(click Enroll for locations)
4/3-4/4
Class Dates and Times
04/03/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
04/04/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!

  

Register Soon!
Registrations on or after Friday 3/28 incur a late registration charge to cover book shipping and provisioning costs.
Before 3/28$795
On/After 3/28$875
Last Reg Date3/31
4/14-4/15
Class Dates and Times
04/14/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
04/15/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!

  

Register Soon!
Registrations on or after Tuesday 4/8 incur a late registration charge to cover book shipping and provisioning costs.
Before 4/8$795
On/After 4/8$875
 
4/21-4/22
Class Dates and Times
04/21/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
04/22/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!
 
5/6-5/7
Class Dates and Times
05/06/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
05/07/2025Wednesday10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!
 
5/15-5/16
Class Dates and Times
05/15/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
05/16/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!
 
5/27-5/28
Class Dates and Times
05/27/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
05/28/2025Wednesday10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
6/2-6/3
Class Dates and Times
06/02/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
06/03/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
6/17-6/18
Class Dates and Times
06/17/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
06/18/2025Wednesday10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!
 
More dates...
Fee:  $795

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


  1. Home
  2. Courses
  3. Power BI
  4. Power BI Introduction for Excel Users

Power BI Introduction for Excel Users Course

 

Power BI is one of our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible.

Power BI is one of our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible.

Power BI for Excel Users Course Overview

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service.

Audience Profile

The course is for individuals who are not IT professionals but need to easily create and publish reports with Power BI.

Power BI for Excel Users Course Prerequisites

Before attending this course, students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus, but it is not required.

Can't Get Time Off to Attend Live Training?

Check out our self-study, self-paced course Microsoft On-Demand: Power BI for Excel Users . This format lets you learn at your own pace and on your own schedule.

** NOTE: More In-Depth Microsoft Official IT Course Available **

While Power BI Introduction for Excel Users is designed for average end users needing to learn essential Power BI skills, we have a more in-depth course PL-300: Power BI Data Analyst . PL-300 is for IT professionals and power users who want a deeper dive into the material and/or who are preparing to pass the related Microsoft certification exam.

COURSE OUTLINE

Getting started

  • Introducing Power BI
  • A quick look at Power BI Desktop
  • A quick look at the Power BI service

Power BI and Excel

  • Introduction to using Excel data in Power BI
  • Upload Excel data to Power BI
  • OneDrive for Business with Excel
  • Import Power View and Power Pivot to Power BI

Getting Data

  • Available data sources in Power BI Desktop
  • Connecting to data sources
  • Connecting to a database
  • Connecting to a CSV file

Shaping and Transforming Data

  • Introduction to the Query Editor
  • Clean and transform your data with the Query Editor
  • Cleaning irregularly formatted data

Modeling

  • Introduction to modeling your data
  • How to manage your data relationships
  • Optimizing data models
  • Introduction to DAX
  • DAX calculation types
  • DAX functions
  • Create calculated columns
  • Create calculated measures
  • Create calculated tables
  • Explore your time-based data

Visualizations

  • Introduction to visuals in Power BI
  • Create and customize simple visualizations
  • Modify colors in charts and visuals
  • Shapes, text boxes, and images
  • Page layout and formatting
  • Interactions among visualizations
  • Visual hierarchies and drill-down
  • Using custom visualizations
  • R integration in Power BI Desktop

Publishing and Sharing

  • Introduction to the Power BI service
  • Publish Power BI Desktop reports
  • Create and configure a dashboard
  • Share dashboards with your organization
  • Quick insights in Power BI
  • Ask questions of your data with natural language
  • Create custom Q&A suggestions
  • Introduction to security, and workspaces
  • Create workspaces in Power BI
  • Manually republish and refresh your data
  • Install and configure a personal gateway
  • Print and export dashboards and reports
  • Publish to web

 

View outline in Word

BPBEX1

Attend hands-on, instructor-led Power BI Introduction for Excel Users training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Power BI Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews

HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment


ONLC TRAINING CENTERS
800-288-8221
www.onlc.com
Our Classes
Why Register with ONLC
Other Information
For Companies
For Professionals
For Government
Live Classes from Home or Office
About ONLC
Other Details
Connect