Excel Data Analysis with Power Pivot

$ 240.00

Module Duration: 3.5 Hours

Class Agenda

Resource Setup 30 Minutes
Training Session 3 Hours
Breaks Prescribed by Instructor

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, Microsoft® 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.

Recommended Preparation: Excel 1 & 2

  • Enable and Navigate Power Pivot
  • Manage Data Relationships
  • Create a Power Pivot Report
  • Create Calculations in Power Pivot
  • Create a Key Performance Indicator
  • Work with Dates and Times in Power Pivot
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.

DETAILED COURSE OUTLINE

Getting Started with Access

Working with Table Data

Querying a Database

Using Forms

Generating Reports

“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top