Loading...
Login / Register

Course ELK91–149: Microsoft® Excel® for Office 365™: Data Analysis with PivotTables

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with ... Show More
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 Instructor-Led Training (V-ILT)

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.

Duration
1 Day

Course Schedule

Upcoming dates for Course ELK91–149: Microsoft® Excel® for Office 365™: Data Analysis with PivotTables

Course Content

Lesson 1: Preparing Data and Creating PivotTables

  • Topic A: Prepare Data
  • Topic B: Create a PivotTable from a Local Data Source
  • Topic C: Create a PivotTable from Multiple Local Data Sources
  • Topic D: Create a PivotTable from an External Data Source

– See fewer details

Lesson 2: Analyzing Data by Using PivotTables

  • Topic A: Summarize PivotTable Data
  • Topic B: Organize PivotTable Data
  • Topic C: Filter PivotTable Data
  • Topic D: Format a PivotTable
  • Topic E: Refresh and Change PivotTable Data

+ See more details

Lesson 3: Working with PivotCharts

  • Topic A: Create a PivotChart
  • Topic B: Manipulate PivotChart Data
  • Topic C: Format a PivotChart

+ See more details

CTU Training Solutions , Updated: December 6th, 2019

Share with friends

Request a Quote

    Your Name
    Your Surname
    Contact Number
    Your Email
    Company
    Which campus would you like to study at?
    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