Sibbald Training
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.
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.