About This Module
This hands-on Microsoft Excel module is designed for delegates who already have a solid understanding of basic spreadsheets and are ready to take their skills to the next level. Ideal for users who can confidently navigate Excel and use simple formulas, this course builds on those foundations to introduce more powerful tools for data analysis, automation, and efficient spreadsheet design.
Delegates who have completed the Excel Spreadsheet Construction course—or who have equivalent experience—will gain the most benefit from this module.
Throughout this interactive session, participants will work directly in Excel, developing practical skills that can immediately be applied in real workplace scenarios.
What You Will Learn
This module takes delegates deeper into Excel’s core functionality, covering a range of intermediate tools and techniques including:
Working Efficiently with Data
- Range Names – Create and manage named ranges to simplify formulas and improve workbook navigation.
- Links – Connect data across sheets and workbooks to maintain consistent, dynamic information.
- Percentages – Use percentages confidently for analysis, comparisons, and reporting.
- Autofilter – Quickly sort and filter large datasets to pinpoint the information you need.
Presenting Data Clearly
- Charts – Build professional charts that communicate trends, comparisons, and insights effectively.
Intermediate Formulas & Logic
- IF Function – Apply logical conditions to automate decision-making within your data.
- SUMIF – Perform conditional calculations to extract meaningful results from large datasets.
Working Across Multiple Sheets
- Grouped spreadsheets – Make simultaneous changes across multiple worksheets.
- Calculations across sheets – Build formulas that pull together information from different areas of your workbook.
- Calculations across multiple ranges – Combine several data points to create more sophisticated analysis.
Security, Linking & Embedding
- Protecting sheets – Safeguard your data and formulas from accidental amendments.
- Object Linking & Embedding (OLE) – Link or embed files, charts, and documents to integrate information seamlessly across applications.
Course Requirements
A minimum of four delegates is required for this course to run. If this number is not met, the session may be rescheduled for a later date.
Looking to go even further?
Build on the skills in this module by exploring our Excel – Advanced course, where you’ll learn automation, advanced formulas, data tools, and enhanced reporting techniques.
Click here to learn more!
Benefits of Attending
Mastering Excel at an intermediate level opens the door to a wide range of practical and professional advantages:
- Greater efficiency – Automate repetitive tasks and reduce manual data handling.
- Better data insights – Use formulas, functions, and charts to uncover meaningful trends.
- Improved organisation – Manage and link large datasets across multiple sheets and documents.
- Career growth – Excel proficiency is highly valued across all industries and roles.
- Real‑world application – Strengthen your ability to build reports, analyse data, track performance, and support decision‑making.
Whether you’re managing budgets, analysing business performance, or maintaining operational data, this course will help you use Excel more confidently and strategically.
