Details
About the workshop
This technical course covers advanced features and functionalities for intermediate level users who have a basic understanding of Excel and want to expand their knowledge and skills to work more effectively with the program and learn more about its advanced features, run by Excel master Lance Rubin.
Fluid Excel skills are essential for business professionals who need to organise and analyse data quickly and accurately. Learning how to use Excel effectively can save time and improve efficiency, which can result in cost savings and improved business outcomes. Additionally, Excel proficiency is a desirable skill set for many jobs and industries, making it a valuable investment in personal and professional development.
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.
Session module titles for brochure:
- Strategies and skills to build solutions to critical business questions
- Data analysis, manipulation and management
- Intermediate application for formulas and logical functions
- Data modelling, visualisation, KPIs, and calculations
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