• Corporate Courses
  • CompTIA
Office 365

Microsoft Excel for Office 365 Part 3

Master Excel’s most advanced collaboration, automation and analytics features in just 1 instructor-led day. This course teaches you to link multi-sheet workbooks, secure and share files, write macros, audit complex formulas and forecast trends – preparing you for the Microsoft Office Specialist: Excel Expert certification (Exam MO-211 / legacy MO-201).

Enquire Now

Why choose this course?

  • Work smarter across workbooks. Consolidate data with links, 3-D references and cross-file connections to keep reports in sync.
  • Protect and collaborate with confidence – track changes in real time and lock down sheets or entire workbooks.
  • Automate repetitive tasks using data-validation rules, error checking and time-saving macros.
  • Analyse “what-if” scenarios & trends with Lookup functions, Goal Seek, data tables, scenarios and the Forecast sheet.
  • Tell the story visually – add sparklines, map-based charts and other rich visuals that help decisions jump off the page.
  • Hybrid delivery – attend on-campus or virtually from anywhere in South Africa.
See Course Content

This course is ideal for:

  • Experienced Excel users who troubleshoot large workbooks, collaborate with colleagues and need to automate repetitive analysis tasks.
  • Analysts and finance teams who must model potential outcomes and present strategic insights.
  • Learners completing the Microsoft Office Specialist Excel certification pathway.

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.
  • Practical experience creating and analysing datasets in Excel – including formulas, basic charts, PivotTables and the skills taught in Excel – Part 1 & Part 2 (or equivalent).

Course Content

  • Work with Multiple Worksheets & Workbooks – links, external & 3-D references, data consolidation
  • Share & Protect Workbooks – real-time collaboration, worksheet/workbook protection
  • Automate Workbook Functionality – data-validation, error checking, macro recording
  • Use Lookup Functions & Formula Auditing – VLOOKUP/XLOOKUP, tracing precedents/dependents, Watch Window
  • Forecast Data – data tables, scenarios, Goal Seek, Forecast sheet for trend projection

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.