• Corporate Courses
  • CompTIA
Office 365

Microsoft Excel for Office 365 Part 1

Build a rock-solid spreadsheet foundation in just 1 instructor-led day. This hands-on course teaches you to create, calculate, format, print and manage workbooks – putting you on the fast track to the Microsoft Office Specialist: Excel Associate certification (Exam MO-200) and laying the groundwork for Excel Expert (MO-201).

Enquire Now

Why choose this course?

  • Master the essentials – fast. Learn navigation, formulas, formatting and printing in a single intensive day so you can work smarter immediately.
  • Covers both Excel Desktop & key web features, plus OneDrive integration, so you’re productive wherever you log in.
  • Mapped to MOS objectives for Excel Associate (MO-200) and aligned with the follow-up Excel Expert exam (MO-201).
  • Hybrid delivery – attend on-campus or virtually from anywhere in South Africa.
See Course Content

This course is ideal for:

  • Professionals and students who need a practical, ground-level grasp of electronic spreadsheets.
  • Excel self-taught users ready to replace trial-and-error with best practices.
  • Anyone beginning the Microsoft Office Specialist Excel certification journey.

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.
  • Basic Windows-10 skills: opening apps, navigating files/folders and using keyboard/mouse. No prior spreadsheet knowledge required.

Course Content

  • Getting Started with Excel – navigate the UI, use commands, create/save workbooks, enter data, Excel Help
  • Performing Calculations – build formulas, insert functions, reuse calculations
  • Modifying a Worksheet – insert/delete cells & ranges, search/replace, proofing & research tools
  • Formatting a Worksheet – text & number formats, alignment, colours/borders/styles, basic conditional formatting, templates
  • Printing Workbooks – preview/print, page layout, headers & footers
  • Managing Workbooks – organise worksheets, customise views, set workbook properties

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.