Microsoft Excel – Intermediate (online)

Content

This course will cover:

• Cell Referencing: Mastering Absolute ($) vs. Relative references and using Named Ranges for readable formulas
• Essential Functions: Using Logic (IF), Lookups (VLOOKUP), and dynamic Date functions (TODAY).
• Advanced Formula Techniques: Nesting functions within each other and linking data across different workbooks.
• Conditional Formatting: Using formulas and rules to automatically highlight outliers, deadlines, or trends.
• Charting: Creating professional charts and understanding which chart type fits your data story.
• Excel Tables: Using “Modern Excel” Tables for dynamic ranges and structured referencing.
• Pivot Tables: Summarizing large datasets into interactive reports (grouping, filtering, and sub-totalling).
• Data Validation: Creating dropdown lists to control user input and prevent errors.
• Protection: Locking specific cells and password-protecting workbooks to prevent accidental damage.
• Custom Formatting: Masking numbers with text labels and formatting negative values professionally.

Outcomes

• Build complex, dynamic formulas that update automatically when data changes.
• Summarize thousands of rows of data instantly using Pivot Tables.
• Create visually compelling reports using Charts and Conditional Formatting.
• Secure spreadsheets so that other users cannot break formulas ordeletecritical data. 
• Link data across multiple files to create a “single source of truth.”
• Ensure data accuracy by restricting what users can type into specific cells.

Who Should Attend

Ideal for regular Excel users who feel they are “hitting a ceiling” with their current skills. If you spend too much time manually updating reports, fixing broken formulas, or formatting data repeatedly, this course is for you.

Benefits to You and Your Organisation 

• Individual Benefit: Drastically reduce the time spent on monthly reporting through automation and better data structure.
• Organisational Benefit: Improve data integrity by implementing validation and protection, reducing the risk of “human error” in critical business sheets.
• Organisational Benefit: Standardise reporting capability across the team, ensuring data is presented professionally and accurately.