Course description
Take your Excel skills to the next level with this intermediate Excel training.
Learn how to work with formulas, logical functions, data validation, and worksheet security to manage data more efficiently and confidently.
This course is perfect for those who understand the basics but want to improve their Excel proficiency.
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.
Upcoming start dates
Suitability - Who should attend?
- 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.
Outcome / Qualification etc.
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.
Training Course Content
Recap & Performing Essential Calculations
- Refreshing SUM, AVERAGE, MIN, MAX, COUNT functions
- Using Absolute, Relative, and Mixed Referencing
- Working with Named Ranges and Tables for better formula efficiency
Enhancing Spreadsheet Functionality
- Moving, linking, and referencing data across multiple worksheets
- Best practices for spreadsheet design and organisation
- Recap of basic charts and looking at more advanced chart types
Logical Functions for Decision-Making - Make your Spreadsheets Smarter
- Understanding and applying IF statements
- Creating basic IF formulas to automate decision-making
- Combining IF with comparison operators (greater than, less than, equals)
Advanced 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
- Adding comments and notes for improved collaboration
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
Course delivery details
Looking for Excel training just for yourself or a small number of attendees?
We run regular public courses for anyone to join - just contact us to book.
We can also run private in-house courses for your organisation, or 1-2-1 tuition.
Delivery: live online or in-house delivery at your premises.
Duration: 1 day.
Included: comprehensive course materials. Hands-on exercises 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 notes and examples for your reference.
Request info
Mark Baglow Training
I’m Mark Baglow - the founder and lead trainer of Mark Baglow Training. I'm an experienced trainer with a passion for helping professionals build confidence, improve communication, and lead effectively. With a background in corporate training and education, I bring...