Microsoft Office Excel 2016: Data Analysis with Power Pivot

Microsoft Office Excel 2016: Data Analysis with Power Pivot

1/2 Day

 

Description:

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

 

Continuing Education:

This event is eligible for the following continuing education credits:

• CEU: 0.35 credits

• PDU: 3.5 credits

For more information on Continuing Education credits: http://www.expandlearning.com/continuing-education-and-professional-development.php   

 

Prerequisites: 

 

To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating and analyzing basic PivotTables. You can obtain this level of skills and knowledge by taking the following courses:
Microsoft Office Excel 2016: Part 1 (Basic)
Microsoft Office Excel 2016: Part 2 (Intermediate)
Microsoft Office Excel 2016: Data Analysis with PivotTables (recommended)

 

 

Course Outline

Lesson 1: Getting Started with Power Pivot

• Topic A: Enable and Navigate Power Pivot
• Topic B: Manage Data Relationships

 

Lesson 2: Visualizing Power Pivot Data

• Topic A: Create a Power Pivot Report
• Topic B: Create Calculations in Power Pivot

 

Lesson 3: Working with Advanced Functionality in Power Pivot

• Topic A: Create a Key Performance Indicator
• Topic B: Work with Dates and Time in Power Pivot

 

Appendix A: Commonly Used DAX Functions

 

We invite you to attend Microsoft Excel training in Salt Lake City, Utah. Our locally owned and operated West Valley classroom is designed to allow you to get the most out of your Excel class with training delivered by local Excel pros.Attend a Microsoft Excel class in our Salt Lake City, Utah facility and learn to organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. You will also learn to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

Expand Learning Solutions offers local instructor-led training classes in West Valley, Utah for Excel version 2016, 2013, 2010 and 2007. We offer Excel Basic, Intermediate, and Advanced classes in addition to Excel VBA (Excel Programming with Visual Basic for Applications). ​Expand Learning Solutions, also offers Microsoft Excel Training via live online options and self-paced options.​​​​​​​​