Course Overview
Our Excel Level 2 training is designed for users who already know the basics or have been on our Level 1 course but want to master logical functions, advanced formatting, and data validation.
By the end of this one-day course, you’ll know how to use logical formulas, link worksheets, secure data, and design spreadsheets that are efficient, professional, and error-free.
Recap & Performing Essential Calculations
-
Refreshing SUM, AVERAGE, MIN, MAX and counting functions
-
Using Absolute, Relative, and Mixed Referencing and why they are crucial for good formulas
-
Use Named Ranges and Tables to keep your formulas tidy and efficient
Enhancing Spreadsheet Functionality
-
Moving, linking, and referencing data across multiple worksheets
-
Create dynamic summary sheets for live reporting
-
Best practices for spreadsheet design and organisation
-
Recap of basic charts and how to create more advanced chart types
Logical Functions for Decision-Making - Make your Spreadsheets Smarter
-
Understanding and applying IF statements to speed up tasks, enter data and reduce errors
-
Creating IF formulas to automate decision-making
-
Combining IF with comparison operators (greater than, less than, equals) for even more options
Data Handling & Analysis
-
Sorting & filtering beyond the basics – multi-level sorting, custom filters
-
Using Date & Time functions for automated tracking
-
Creating drop-down lists and data validation rules
Auditing & Reviewing Workbooks
-
Tracing precedents and dependents to understand formula relationships
-
Using Formula Auditing tools to identify and fix errors
-
Using comments and notes for improved collaboration – no more endless email chains!
Data Validation & Security
-
Creating drop-down lists and data validation rules
-
Using Data Validation to prevent incorrect inputs and control your data
-
Protecting worksheets and locking cells to prevent accidental changes
Upcoming Public Courses
Book instantly onto one of our regular public courses below.
Are you an organisation with four or more attendees?
Please contact us to arrange a private in-house course at a discounted rate per person.
Contact Us
Whether you are looking for a quote for group training, or just want to know more, we'd love to hear from you.
Key Benefits
This Excel Level 2: Intermediate - Data Analysis and Efficiency course will equip you with powerful intermediate Excel skills to dramatically enhance your data analysis capabilities and significantly improve your spreadsheet efficiency.
-
Use IF statements to automate decision-making in Excel.
-
Structure and manage formulas more effectively with named ranges and linking.
-
Sort, filter, and format data professionally to improve readability.
-
Apply data validation rules to create error-free spreadsheets.
-
Secure worksheets and troubleshoot common formula errors.
Who is it for?
-
Individuals who have successfully completed Excel Level 1: Introduction or possess equivalent foundational Excel skills.
-
Business professionals who regularly work with data and want to enhance their data analysis capabilities using Excel's intermediate features.
-
Excel users who need to create more dynamic and insightful reports and dashboards.
-
Anyone seeking to significantly improve their efficiency and accuracy when working with spreadsheets and data.
-
Teams and departments looking to elevate their intermediate Excel proficiency for enhanced data management and analysis.
Delivery and Logistics
Delivery: live online or in-house delivery at your premises (for private in-house courses).
Duration: 1 day.
Included: comprehensive course materials. Hands-on exercises and detailed notes for every topic so you will be able to do everything that the instructor does. By the end of the day you will have a course file filled with practical notes and examples for easy reference.