Power Pivot and Power Query for Excel 2016
Learn how to use the Excel 2016 add-ins Power Pivot and Power Query to manipulate, query, distribute and visualize your data.
GK# 6939
Learn how to use the Excel 2016 add-ins Power Pivot and Power Query to manipulate, query, distribute and visualize your data.
GK# 6939
Power Pivot, Power Query, Power View, 3D maps are free add-ins that expand and combine the features and capabilities of Excel. It includes the ability to import, manipulate and work with large amounts of data from a variety of data sources both inside and outside Excel.
This course will cover techniques for manipulating and querying data, the structure of DAX functions, ways to distribute and visualize data using Pivot Charts, Slicers, Sparklines, Timelines, Power View and 3D maps.
By the end of this course, users should be comfortable with navigating the Power Pivot and Power Query applications, manipulating data, creating queries and reports, using DAX functions, and distributing and visualizing data.
Getting Started with Power Pivot
Manipulating Power Pivot Data
Manipulate Power Pivot Data Using DAX Functions
Extract Data from Tables Using Functions
Work with Time Dependent Data
Power Query and When to Use It
(NOTE: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both.)
Data Sources
Organizing Data
Queries
Create PivotTables
Bringing It All Together with Visualizations
Students should be comfortable using the Excel 2016 interface and have a firm understanding of how Excel works and what it is used for. Understanding and experience with formulas, functions, and PivotTables is strongly recommended.
Individuals interested in learning more about Power Pivot and Power Query applications.
This Office course comes with extended access to the following benefits:
This course is available in the following formats:
Experience live, expert-led online training from the convenience of your home, office or anywhere with an internet connection.
Receive face-to-face instruction at one of our training center locations.