Professional Course

Data Modeling and Dashboards using Excel Power Tools

10 weeks
10 weeks
This provider usually responds within 48 hours 👍

Course description

Excel provides a set of tools that allow you to save time cleaning, formatting and importing data from a variety of sources. These tools also assist in creating and updating standard reports and dashboards to dynamically visualize data.   

Data Modeling and Dashboards using using Excel Power Tools is a certificate program and non-credit-bearing. There are no degree requirements for the program.

Do you work at this company and want to update this page?

Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

Who should attend?

This course will provide you with a working knowledge of powerful Excel tools you can use to enhance visual representations of data. You should have a working knowledge of the data analysis and modeling tools that are covered in our Introduction to Data Modeling using Excel course.

Training content

This course will introduce you to the most effective ways to build dashboards using Microsoft Excel's powerful data modeling and business intelligence tools: Power Query, Power Pivot and Power View. By the end of the program, you will be able to use these tools to make effective data visualizations for reports and presentations.

This course will develop your skills in the following tools:

  • Get and Transform - imports, cleans, formats and combines data from a variety of sources​.
  • Power Query - takes the time and energy out of updating reports.
  • Power Pivot - create data models that make seamless connections between a variety of data sources. 
  • Power View and Power Map - create interactive dashboards that communicate the story of your data.

Course delivery details

You can complete this program at your own pace, anywhere and anytime, as long as you have a computer with access to the internet and a web browser. On the program start date, you'll receive access and must complete the program within 10 weeks. 

The program consists of five modules that you must complete in sequence.  Each module contains:

  • Instructor-led videos and resources
  • Follow along practice exercises for active learning
  • Application activity to reinforce the skills in each module

You will need to submit the application activity to unlock the next module. These activities will ensure you understand and are able to apply the skills covered in each module. These activities can be resubmitted as many times as necessary for mastery of the content.


The cost of this program is $1,250

Certification / Credits

You will earn a certificate after completing this program

Contact this provider

Contact course provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
If you want us to recommend other suitable courses, please fill out all fields below and check the box beside "Please recommend similar options"
Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
University at Buffalo - School of Management
339 Jacobs Management Center
14260-4000 Buffalo New York

UB School of Management | A Tradition of Excellence

Since 1923, the UB School of Management has built an impressive reputation as one of the best schools of business in the world. The comprehensive range of our academic portfolio, the expertise of our faculty and the worldwide success of our...

Read more and show all training delivered by this supplier