Microsoft Excel – Advanced
"Unlock Excel's Potential: Advanced Training for Data Wizards!"
Join Online training on
Date: 12 / 08 / 2023
Day: Saturday
Duration
1 Days
Time
8am-6pm
rest on 1pm-2pm
Fee
RM 159
- PRE-REQUISITES
To enroll in Microsoft Excel training at the advanced level, participants are expected to have a solid foundation in basic and intermediate Excel skills
- VENUE / PLATFORM
- APPLY NOW
Training Overview
Microsoft Excel – Advanced is designed for the participant who wants to leverage on the Advanced functions and features to improve productivity and enhance your spreadsheets to simplify your daily work activities.
Individuals who already possess a strong foundation in Excel and want to take their skills to the next level. This comprehensive course empowers participants to become proficient in advanced data analysis, automation, and visualization techniques. Through hands-on exercises and real-world scenarios, participants will gain the expertise needed to efficiently manipulate complex data sets, create dynamic reports, and streamline their workflows.
Course Objectives
At the end of the course, you will be able to
- Use and Manage defined Names. Display & trace Formulas and understand Errors
- Use Advanced functions in Date, Time, Logical, Text and Lookups
- Use Data Validation to control the data being accepted such as controlled text length and drop list
- Create Scenarios, use of Goal Seek & Solver
- Group and Outline Data & Using Subtotals
- Consolidate Data by Position or Category, and Use Formulas
- Use and format of PivotTable, PivotChart and Slicers
- Record, play and delete a Macro. Adding a Macro to the Quick Access Toolbar
Course Outline & Module
- Conditional Functions
- Lookup Functions
- Auditing
- Protection and Security
- Introduction to Macros and Automation
Who Should Attend Microsoft Excel Advanced ?
The Microsoft Excel Advanced training is designed for individuals who already possess a strong foundation in basic and intermediate Excel skills and are looking to enhance their proficiency in advanced Excel features and data analysis techniques.
Students
Office Workers
Entrepreneurs and Small
Business Owners
Administrative Staff
Training Packages
Certificate of Completion Provided
Participants will receive a Certificate of Completion on the last day of training.
Personalised Mentorship
Get a knowledgeable mentor who guides your learning and is focused on answering your questions, motivating you and keeping you on track.
Follow Up Training
Every participant entitles for 1 free follow up training. Follow up training will be scheduled in the future. This will help you to catch up your learning.
