Details
About the workshop
Take your Excel skills to the next level with this hands-on course for intermediate users. Learn advanced features and techniques to work faster, create smarter workbooks, and manage data with precision.
Excel proficiency isn’t just about spreadsheets, it’s a tool for better decision-making, increased efficiency, and improved business outcomes. Whether you’re analysing data, streamlining workflows, or presenting insights clearly, this course equips you with practical skills you can use immediately.
Build confidence, save time, and stand out in your role by mastering the techniques that make Excel an essential professional skill.
Agenda
Module 1: Data Management
- Working with multiple worksheets and workbooks
- Sorting and filtering data
- Data validation and error checking
- Text to Columns
Module 2: Intermediate Formulas and Functions
- Logical Functions (IF, AND, OR)
- Lookup and Reference Functions (VLOOKUP, XLOOKUP)
- Date and Time Functions
- Text Functions
- Dynamic formulas and relative cell reference
- Range Names
Module 3: Data Visualisation
- Conditional formatting
- Charts and sparklines
- Data Tables
- Pivot tables
Tailor Your Training Experience
To make sure you get the learning solution that’s right for you, we offer different levels of tailoring to suit your needs. Choose from three levels of customisation:
1.Off the Shelf
Love what you see? Great! Choose this option to take one of our most popular courses and bring it in-house for your team. Includes a pre-course consult session with our facilitator to make sure we hit the mark, and deliver the right learning experience for you.
2.Customised
Make sure you get the most from the course you choose, by tailoring the content to get the right fit for you. Speak to our team, who will work with you to pick and mix from a curated bank of training modules to help customise your learning experience.
3.Premium
Not on the list? Let us know what you’re looking for and we will find the right solution. Our team of learning specialists will work with you to develop a unique training course for your business. Through an in-depth consultation process, we will work with you to profile your learning needs and build a bespoke program from the ground up.
Speak with one of our team today to find which option is right for you.
Who Will Attend
Designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks.
All roles across all industries including: Employee, Junior Management, Middle Management, Senior Management, Top Management