Microsoft Office Excel 2016: Data Analysis with PivotTables - CTU Training Solutions
Loading...
Login / Register

Microsoft Office Excel 2016: Data Analysis with PivotTables

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyse that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyse, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.
Duration: 1 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: 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

Lesson 2: Analyzing Data 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

Lesson 3: Working with PivotCharts

  • Topic A: Create a PivotChart
  • Topic B: Manipulate PivotChart Data
  • Topic C: Format a PivotChart
CTU Training Solutions , Updated: June 8th, 2018

Request A Quote

    Your Name
    Your Surname
    Contact Number
    Your Email
    Choose a campus
    Company
    Your job title
    Will your training be sponsored?
    Message
    How did you hear about CTU?
    Agree
    By ticking this box, you confirm that:

    (a) you have read and agree to our Website Terms and Conditions and that

    (b) you have read our Privacy Policy and PAIA Manual.

    If you are under 18 please ask your parent or guardian to confirm this.

    By ticking this box you give us permission to send you information and marketing material about our Brand, Campuses and Programmes.

    If your child is under 18, by checking this box, you give us permission to send your child information and marketing material about our brand, campuses and courses
    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

    Open chat
    1
    Need Help?
    Hello
    How can we assist you today?