NewEra Technology Facebook
Excel Power BI Tools Level 1: Dashboards and Power Pivot for Excel - Course Information
PRINT
SEND TO A FRIEND
Name: Excel Power BI Tools Level 1: Dashboards and Power Pivot for Excel
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 395
Description:
This class will cover the elements commonly used to create dashboards in Excel. These elements will include graphing data using charts and sparklines, creating buttons and interactivity for users, and summarizing data through the use of pivot tables.

Users will also be introduced to the PowerPivot add-in and its role in creating pivot tables.
Prerequisites:
Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.

Participants should also have experience with Excel’s basic functions. (eg. Excel 2010 or 2013 Level 1)
Outline:
Dashboards and Power Pivot for Excel

Introduction to Dashboards:
• What are they for?
• What do they look like?
• What elements are included in a typical dashboard?

Dashboard elements:
• Chart/Graphs and Sparklines
• Conditional Formatting (incl. flags, shapes and other indicators)
• Pivot Tables
• Pivot Charts
• Slicers
• User interface items

Getting Started with PowerPivot
• Explore the PowerPivot Application
• Import Data from Various Data Sources
• Refresh Data from a Data Source
• Create Linked Tables

Manipulating PowerPivot Data
• Organize and Format Tables
• Create Calculated Columns
• Sort and Filter PowerPivot Data
• Create and Manage Table Relationships

Creating PowerPivot Reports
• Create a PivotTable
• Create PivotCharts
• Filter Data Using Slicers
• Present PivotTable Data Visually

Creating KPI’s
• Base Value (Measure)
• Target Value (Goal)
• Status thresholds

Using DAX Functions in PowerPivot
• Manipulate PowerPivot Data Using DAX Functions
• Extract Data from Tables Using Functions
• Work with Time Dependent Data
Guaranteed to run courses