Download course directory

Microsoft Excel - Beginner - Virtual Learning

Microsoft Excel - Beginner is a tutor led online course designed to teach you how to use Excel effectively, whether you are brand new or need to refresh your skills.

6 hours
This course is ideal for
professionals, students, and career-switchers alike, this course gives you the Excel foundation you need.

Course Aims

At the end of this course you will be able to confidently navigate Excel and understand its key features, use essential formulas and functions for real tasks, clean, sort, and filter data quickly and effectively, format spreadsheets professionally for clear communication, understand Excel’s role in everyday data analysis.

Course Content

  • Introduction to Excel for Data Analysis - Understand how Excel is used in real-world data workflows.
  • What is Data Analytics? - Grasp the basics of analytics and why Excel is a key player.
  • What is MS Excel? - Get to know the interface, layout, and core functionality.
  • Key Features of MS Excel - Discover Excel’s most useful tools for beginners.
  • Basic Excel Functions & Formulas - Learn how to use SUM, AVERAGE, IF, and more.
  • Data Import, LOOKUP & Cleaning - Bring in external data, use LOOKUP functions, and clean messy datasets.
  • Sorting, Formatting & Filtering - Understand sorting options, master formatting tools, and utilise filtering features effectively.

Additional Information

All Virtual Classes will be conducted over Zoom.

System requirements
• An internet connection – broadband wired or wireless (3G or 4G/LTE)
• Speakers and a microphone – built-in, USB plug-in, or wireless Bluetooth
• A webcam or HD webcam - built-in, USB plug-in
• macOS X with macOS X (10.11) or later
• Windows 11
• Windows 10 Note: Devices running Windows 10 must run Windows 10 Home, Pro, or Enterprise. S Mode is not supported.

Note: On Windows devices, Zoom utilizes WebView2 and Chromium Embedded Framework (CEF) for certain features. If not available, these are downloaded automatically by Zoom, but admins should ensure these are whitelisted on managed devices.