Loading...
Login / Register

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 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

– 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

+ See more details

CTU Training Solutions , Updated: December 6th, 2019

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