1 Day | Class-based & Online

This course qualifies for 6 hours of CPD Credit

Enhance your productivity and data management skills with this practical, hands-on Microsoft Excel Intermediate course. Building on your existing knowledge, you will learn how to work smarter and more efficiently by leveraging Excel’s powerful tools and functions. Discover how to use logical formulas such as IF statements, Lookup functions such as XLOOKUP. sort and filter data for clearer analysis, and apply Conditional Formatting to highlight key information. You will also learn to protect your worksheets against accidental damage. Through guided exercises and real-world examples, this course will give you the confidence and capability to use Excel more strategically in your daily work.

Content:

1. Reviewing Core Excel Skills
   Refresh essential Excel concepts and foundational techniques to ensure a confident transition into more advanced tools and features.
2. Controlling Formula Scope and References
   Understand how relative, absolute, and mixed references impact formulas and apply scoping techniques for accurate results across worksheets.
3. Logical and Lookup Functions
   Use logical operators such as IF, AND, and OR, to create dynamic, decision-based formulas that add intelligence to your spreadsheets. Use VLOOKUP and XLOOKUP to streamline data analysis and automate decisions.
4. Validate and Control Data Entry
   Implement data validation rules and dynamic drop-down lists to improve consistency and reduce errors.
5. Protect and Secure Workbooks and Worksheets
   Apply data protection techniques to safeguard sensitive information and maintain data integrity.
6. Using Conditional Formatting for Insights
   Highlight key trends and exceptions automatically with data bars, colour scales, and icon sets that make patterns easy to spot.
7. Introducing Sparklines for At-a-Glance Analysis
   Incorporate in-cell charts to display quick visual summaries of data trends and comparisons.
8. Managing and Organising Data
   Sort, filter, and refine large data sets to extract relevant information quickly and efficiently.
9. Understanding Pivot Tables
   Use advanced page setup options, print titles, and scaling tools to produce professional, presentation-ready reports.

Learning objectives:

By the end of this Microsoft Excel Intermediate course, participants will be able to:

• Create and apply logical and lookup functions such as IF and VLOOKUP to analyse and evaluate data effectively.
• Use Conditional Formatting techniques to automatically highlight key trends and values for clearer data insights.
• Organise and analyse information efficiently using Excel’s advanced sorting and filtering 
• Enhance the accuracy of your workbooks by using Data Validation to maintain integrity.
• Manage data effectively using Sort, Filter and Pivot Tables.

Prerequisite: Participants are expected to have an essentials level of Microsoft Excel experience before attending this course.