Loading...
Login / Register

Microsoft Office Excel 2016 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 analyse 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.
Duration: 5 Day   |   Location : Online
Course Prerequisites:
To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. You... Show More
Request A Quote

Virtual Lecturer-led Interactive Teaching (VLIT)

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

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

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
CTU Training Solutions , Updated: June 8th, 2018

Request A Quote

    Your Name
    Your Surname
    Contact Number
    Your Email
    Company
    Your job title
    Will your training be sponsored?
    Message
    How did you hear about CTU?
    The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

    Join the CTU community

    Join the CTU Community Portal and gain access to superior resources.

    Join for Free