• Corporate Courses
  • CompTIA
Office 365

Microsoft Excel for Office 365 Part 2

Turn your spreadsheets into decision-making powerhouses in just 1 instructor-led day. This intermediate course shows you how to analyse, visualise and present data with advanced functions, lists, charts and PivotTables – moving you closer to the Microsoft Office Specialist: Excel (Microsoft 365 Apps) Exam MO-210 and ultimately Excel Expert (Microsoft 365 Apps) Exam MO-211.

Enquire Now

Why choose this course?

  • Unlock higher-level functions – logical, text, date/time and specialised functions that answer real-world questions quickly.
  • Master data lists with professional-grade sorting, filtering, outlining and database functions for razor-sharp analysis.
  • Turn raw numbers into stories using intermediate–advanced conditional formatting, compelling charts and interactive PivotTables/Charts.
  • Aligned to MOS objectives for MO-210 / MO-211, so every skill you learn counts toward certification.
  • Hybrid delivery – attend on-campus or virtually from anywhere in South Africa.
See Course Content

This course is ideal for:

  • Excel users who already create basic worksheets and want to analyse and present data more effectively.
  • Data professionals who must transform everyday spreadsheets into insightful reports.
  • Anyone progressing along the Microsoft Office Specialist Excel certification path.

Prerequisites

  • Working with Functions – ranges, specialised & logical functions; date/time and text functions
  • Working with Lists – sort & filter, database functions, outlining & subtotals
  • Analysing Data – create/modify tables; intermediate & advanced conditional formatting
  • Visualising Data with Charts – build, customise & enhance charts with advanced features
  • Using PivotTables & PivotCharts – create, analyse & present data; timelines & slicers for interactive filtering

Course Content

  • Lesson 1: Working with Functions
  • Lesson 2: Working With Lists
  • Lesson 3: Analyzing Data
  • Lesson 4: Visualizing Data with Charts
  • Lesson 5: Analyzing Data with PivotTables and Pivot Charts

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.
  • Keyboard and mouse or a compatible pointing device.
  • Fast Ethernet (100 Mb/s or faster) adapter 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.