Microsoft Excel — Foundational

Course Overview

This foundational course gives you the essential Excel skills needed for any office role. You will learn to navigate Excel confidently, enter and format data, write common formulas and functions, create charts, and organise data using sort and filter. No experience needed — every topic builds logically from the basics. By the end you will be able to handle the everyday Excel tasks expected in most professional roles and be prepared for the MO-200 Microsoft Excel Associate exam.

What You Will Learn

• Navigate the Excel interface — ribbon, cells, sheets, workbook management
• Enter, edit, and format data — numbers, text, dates, and currency
• Write essential formulas: SUM, AVERAGE, COUNT, MIN, MAX, IF
• Use relative and absolute cell references correctly
• Create and format bar, line, and pie charts
• Sort and filter data to find and organise information
• Use basic functions: VLOOKUP, CONCATENATE, LEFT/RIGHT/MID, TEXT
• Format worksheets for clear printing and professional presentation

Course Modules

• Excel interface: ribbon, name box, formula bar, sheet tabs, zoom, view options
• Entering data: text, numbers, dates — auto-fill, data series, lists
• Formatting: font, colour, borders, cell alignment, number formats, wrap text
• Formulas and functions: = syntax, SUM, AVERAGE, COUNT, COUNTA, MIN, MAX
• Relative vs absolute references: $A$1 vs A1 — understanding when to use each
• Logical functions: IF statements — simple and nested IF
• Lookup functions: VLOOKUP basics — find data across tables
• Text functions: CONCATENATE / &, LEFT, RIGHT, MID, LEN, TRIM, UPPER/LOWER
• Charts: inserting bar, column, line, and pie charts — formatting and titles
• Sorting: single-level and multi-level sort, sorting by colour
• Filtering: AutoFilter, custom filters, filter by colour
• Printing: page setup, print area, headers/footers, fit to page
• MO-200 exam overview and practice questions

Who Is This Course For?

This course is ideal for school leavers, career starters, administrative staff, receptionists, retail managers, and anyone in a business role who needs to use Excel regularly but has limited or no formal training.

Prerequisites

No prior Excel experience is required. Basic computer literacy (typing, using a mouse, opening applications) is all that is needed.

Delivery & Access

• Blended, online, onsite or on-demand delivery — your choice of format
• Hands-on labs with real environments
• Instructor Q&A support for 30 days
• Verified certificate of completion by BITA
• Study guides, practice questions and reference materials included

Related Courses