• Corporate Courses
  • CompTIA
Office 365

Microsoft Excel for Office 365 – Data Analysis with PivotTables

Turn raw rows into razor-sharp insights in this 5 day instructor-led course. This focused workshop shows you how to prepare data, build sophisticated PivotTables and PivotCharts, and surface trends that drive better decisions – perfect preparation for the data-analysis objectives in the MOS Excel Associate/Expert certifications (MO-210 & MO-211).

Enquire Now

Why choose this course?

  • Go far beyond “Insert → PivotTable”. Master advanced grouping, multi-source models, custom calculations and interactive slicers to answer complex questions fast.
  • Visualise on the fly—create and format PivotCharts that update automatically as your data changes.
  • Designed for busy analysts. One concentrated day gives you an immediate productivity boost and stacks neatly with our Excel Part 1–3 pathway.
  • Hybrid delivery – attend on-campus or virtually from anywhere in South Africa.
See Course Content

This course is ideal for:

  • Experienced Excel users who already build basic PivotTables and want deeper analysis power.
  • Finance, sales and operations professionals responsible for summarising large data sets.
  • Learners progressing toward MOS Excel Associate/Expert certification.

Prerequisites

  • Microsoft® Windows® 10 Professional or Enterprise
  • Microsoft® Office 365™ license (which provides the Microsoft Office apps) Note: The Office 365 plan you use depends on the licensing available in your environment. If you wish to use a trial version, Office 365 Business Premium is acceptable. This course was not tested with Office 365 Home or Office 365 Personal; some features might not be available in these editions.
  • Hands-on experience with Excel and basic PivotTables – equivalent to our Excel Part 2 course.

Course Content

  • Prepare Data & Create PivotTables – clean data, build PivotTables from local, multi-table and external sources
  • Analyse Data with PivotTables – summarise, group, filter, format and refresh data for dynamic insight
  • Work with PivotCharts – build, customise and polish charts that stay in sync with your PivotTables

Hardware Requirements

For this course, you will need one workstation for each student and one for the instructor. Each computer will need the following minimum hardware configurations:

  • 1 gigahertz (GHz) 64-bit (x64) processor.
  • 2 gigabytes (GB) of Random Access Memory (RAM).
  • 32 GB available storage space.
  • Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
  • Bootable DVD-ROM or USB drive.
  • Keyboard and mouse or a compatible pointing device.
  • Fast Ethernet (100 Mb/s) adapter or faster and cabling to connect to the classroom network.
  • IP addresses that do not conflict with other portions of your network.
  • Internet access (contact your local network administrator).
  • (Instructor computer only) A display system to project the instructor’s computer screen.

Interested?

Enquire today and one of our consultants will be in touch.