• Corporate Courses
  • CompTIA
Office 365

Microsoft Excel for Office 365 – Data Analysis with Power Pivot

Turn massive data sets into fast, flexible insight in just a 1-day instructor-led workshop. Learn to model, relate, calculate and visualise complex data with Power Pivot – skills that strengthen your journey toward MOS Excel Expert certification (MO-211 / legacy MO-201).

Enquire Now

Why choose this course?

  • Get productive with Power Pivot in hours. Enable the add-in, build relationships and load multi-source data – all before lunch.
  • Answer tough questions, fast. Create measures, KPIs and smart time-intelligence calculations using DAX.
  • Tell the story visually. Design interactive Power Pivot reports that update live with slicers, timelines and PivotCharts.
  • 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 PivotTables and now need larger, relational models.
  • Analysts in finance, sales or operations who crunch millions of rows and require repeatable, auditable calculations.
  • Learners progressing toward MOS Excel 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 formulas and PivotTables – equivalent to Excel Part 2 and Data Analysis with PivotTables.

Course Content

  • Getting Started with Power Pivot – enable & navigate the add-in; manage data relationships
  • Visualise Power Pivot Data – build Power Pivot reports; create calculations with DAX
  • Advanced Functionality – define KPIs; apply time-intelligence functions for YOY, YTD, rolling periods

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.