Course ELK91–150: Microsoft® Excel® for Office 365™: Data Analysis with Power Pivot

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. This course presents information and skills that are appropriate for users of Office 365™ applications.

Duration: 1 Day | Location : Online

Course Prerequisites:
To ensure your success in this course, you should have experience working with Excel and PivotTables. You shou... Show More

Request A Quote

Virtual Interactive Lecturer-led Teaching (VILT)

Virtual instruction environments are designed to simulate the traditional classroom or learning experience. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Course Content

Lesson 1: Getting Started with Power Pivot

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

– See fewer details

Lesson 2: Visualizing Power Pivot Data

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

+ See more details

Lesson 3: Working with Advanced Functionality in Power Pivot

Topic A: Create a KPI
Topic B: Work with Dates and Time in Power Pivot