Download course directory

Microsoft Excel - Advanced - Virtual Learning

Microsoft Excel - Advanced 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 who already have a basic understanding of Excel and want to advance their skills. It’s perfect for anyone who works with data regularly and wants to improve efficiency, reporting, and decision-making using advanced Excel tools.

Course Aims

At the end of this course you will be able to master Excel's interface and Navigation, create and troubleshoot advanced formulas, build and customise PivotTables & PivotCharts and present data with clear visualisations.

Course Content

Introduction to Excel for Data Analysis
• Excel interface overview
• Workbooks and worksheets
• Data organisation basics

Basic Excel Functions and Formulas
• SUM, AVERAGE, COUNT, and other core functions
• Absolute vs. relative cell references
• Basic error checking in formulas

Data Import, LOOKUP, and Cleaning
• Importing data from external sources
• Using VLOOKUP and HLOOKUP
• Removing duplicates and handling missing data

Sorting, Formatting, and Filtering Data
• Sorting techniques
• Applying conditional formatting
• Using filters to isolate data

Data Visualisation with Charts and Graphs
• Creating bar, line, and pie charts
• Customising chart elements (titles, labels, legends)
• Choosing the right chart for your data

PivotTables and PivotCharts
• Building PivotTables
• Creating PivotCharts
• Grouping, slicers, and calculated fields

Dashboard Building and Design
• Principles of effective dashboard design
• Integrating charts, PivotTables, and slicers
• Enhancing interactivity and dynamic reporting

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.