2 DAYS TRAINING
For a comprehensive quote on this course module, please don’t hesitate to contact us. We are happy to provide further details.
Introduction:
Welcome to the Excel Intermediate Training program, where we’re set to enhance your Excel skills. Throughout this course, we’ll delve into essential topics, starting with reinforcing Formula Basics, ensuring you have a robust understanding of more complex calculations. We’ll then explore practical aspects such as Working with Multiple Worksheets, and diving into effective strategies for organizing and managing data across various sheets.
As we progress, we’ll unravel the power of text manipulation with Working with Text Formulas and venture into time-related calculations in Working with Date and Time Formulas. The course will guide you through creating dynamic formulas with Conditional Formulas, visually enhancing your data through Conditional Formatting, ensuring data integrity with Data Validation, and finally, crafting formulas that efficiently lookup values. By the end of this program, you’ll not only master advanced Excel features but also gain the confidence to apply them in real-world scenarios. Join us on this journey toward Excel mastery!
Learning Objectives:
Enhance participants’ understanding of Formula Basics
Equip participants with the skills to effectively work with Multiple Worksheets
Empower participants with advanced techniques in Working with Text Formulas and
Working with Date and Time Formulas
Introduction to Conditional formulas, Conditional Formatting, Data Validation, and Lookup formulas
HRDC Certificate Of Attendance:
Yes
Target Audience:
Office admin
Senior Executive
Engineers
Managers
Methodology:
Face-to-Face or Online
Hands-on exercises