Join our 1-day virtual Excel class and take your spreadsheet skills to the next level with expert-led training designed for real-world data challenges.
Whether you’re working in finance, marketing, operations, or administration, Excel is a critical tool that can unlock powerful insights and streamline your workflow. This course is built for professionals who already know the basics and are ready to dig deeper into data analysis, automation, and professional-level reporting.
You’ll go beyond formulas and charts—learning how to build dashboards, automate calculations, and work confidently with large, complex datasets. The training is highly practical, hands-on, and focused on real business scenarios, so you can apply your new skills immediately.
Course Modules
-
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
