Excel BI Tools: Power BI for Excel Users is unfortunately unavailable

Thankfully we have 90 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Excel BI Tools: Power BI for Excel Users

at ONLC Training Centers - Gurnee

(7)
Course Details
Price:
$795
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Gurnee, Suburbs
1800 Nations Dr Ste 117
At Dilleys Rd
Chicago, Illinois 60031
(Map)
Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

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 individuals who are not IT professionals but need to easily create and publish reports with Power BI.

Prerequisites:

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

*** NOTE: This class also available in as a Microsoft Official Course ***

While this course is designed for average end users needing to learn essential Power BI skills, there is also a more in-depth version of this class. The 3-day Analyzing Data with Power BI (20778) course is for IT professionals and power users wanting a deeper dive into the material and/or who are preparing to pass the related Microsoft certification exam. Microsoft Software Assurance Vouchers can also be accepted as payment for the official course. For more details on the course, go to
20778: Analyzing Data with Power BI

Course Outline:

Getting started
  • Introducing Power BI
  • Using 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
  • Import Power View and Power Pivot to Power BI
Getting Data
  • Overview of Power BI Desktop
  • Getting started with Power BI Desktop
  • Connect to data sources in Power BI Desktop
  • More advanced data sources and transformation
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
  • Create calculated columns
  • Optimizing data models
  • Create calculated measures
  • Create calculated tables
  • Explore your time-based data
  • Introduction to DAX
  • DAX calculation types
  • DAX functions
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
  • Group 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
  • Quick insights in Power BI
  • Create and configure a dashboard
  • Ask questions of your data with natural language
  • Create custom Q&A suggestions
  • Share dashboards with your organization
  • Install and configure a personal gateway
  • Introduction to content packs, security, and groups
  • Publish Power BI Desktop reports
  • Print and export dashboards and reports
  • Manually republish and refresh your data
  • Create groups in Power BI
  • Use content packs
  • Update content packs
  • Publish to web

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 7950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (4)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

90 Top Choices

Virtual Excel for Beginners

This class is temporarily being offered remotely.

at Donna Sanabria - Virtual Learning via Zoom

Have you been wanting to learn Excel, but never had time for a long training course?  Do you have a project that requires Excel, but don’t know how to get started?  Are you looking to add another skill to your resume and give yourself a competitive advantage?  In this course you will learn how to get started and gain confidence with...

Saturday Oct 3rd, 10am - 2pm Eastern Time

Virtual Intermediate Excel

This class is temporarily being offered remotely.

at Julie Khidekel - Virtual Learning via Zoom

In this intermediate Excel course, master tools such as pivot tables, formulas, macros, data analysis & more with hands-on exercises. You'll also learn some advanced formatting tools such as conditional formatting, sorting and filtering, and some major time-saving tips like freeze panes. Materials Needed to Fully Participate: Microsoft Excel...

Wednesday Sep 30th, 6:30pm - 9:30pm Eastern Time

Excel for Mac Level 1

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets...

Saturday Sep 26th, 10am - 5pm Eastern Time

Intermediate Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

Wednesday Sep 30th, 10am - 5pm Eastern Time

Excel for Business Fundamentals

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques. Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing....

Tuesday Sep 29th, 10am - 5pm Eastern Time

Advanced Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Thursday Oct 1st, 10am - 5pm Eastern Time

Microsoft Excel Essentials

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019. This course is great for someone...

Monday Nov 9th, 10am - 6pm Eastern Time

Microsoft Excel Expert (Level 3)

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Tuesday Nov 10th, 10am - 6pm Eastern Time

Excel at Excel: Getting Down the Basics

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Thursday Sep 24th, 11am - 5pm Eastern Time

Excel at Excel: Getting Down the Basics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Thursday Sep 24th, 11am - 5pm Eastern Time

Excel at Excel: Getting Down the Basics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own).  It introduces a range of Excel topics giving students a taste of the...

Thursday Sep 24th, 11am - 5pm Eastern Time

Excel at Excel: Getting Down the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Thursday Sep 24th, 11am - 5pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Tuesday Oct 20th, 11am - 5pm Eastern Time

Excel Power BI for Desktop: Data Summarization

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Full Course Name: "Excel Power BI for Desktop: Data Summarization and Visualization" In this one-day Excel for Windows session, you will learn how to use Microsoft's free Power BI for Desktop app to produce stunning interactive summarization reports full of modern charts/visuals. In class, you will connect to external data sources, create relational...

Friday Sep 25th, 9am - 4pm Pacific Time

Excel at Excel: Getting Down to the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Saturday Nov 7th, 11am - 2pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

Tuesday Oct 20th, 11am - 5pm Eastern Time

Online Excel Genius 9 : String Functions and Goal Seek

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the world’s most popular spreadsheet application.  Each class will cover a topic in depth and then give students exercises that...

Tuesday Sep 29th, 10:30am - 12:30pm Eastern Time

Free

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Wednesday Sep 30th, 9pm - 11:55pm Eastern Time

Excel VBA Macros: Write Custom Excel Macros in VBA

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is ideally suited...

Tuesday Oct 6th, 9am - 4pm Pacific Time

  (2 sessions)
$895

2 sessions

Excel 2016/2019: Data Analysis with Pivot Tables

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Online Virtual Class, Online, California 00000

Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only will students be able to summarize data to analyze, but they can organize the data in a way that can be meaningfully presented to others. Who Should Attend Students taking this course are experienced Excel users who are seeking...

Monday Sep 28th, 6am - 2pm Pacific Time