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

Participants should already be comfortable with basic and intermediate Excel tools before joining this advanced programme.

• VENUE / PLATFORM

• APPLY NOW

About this programme

Use advanced Excel features to improve your spreadsheets, simplify recurring work and become more productive.

Build advanced analytical, automation and visualisation skills through practical tasks. Learn to handle complex datasets, create dynamic reports and make workflows more efficient.

Learning goals

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 ?

For participants with a strong foundation in basic and intermediate Excel who want to extend their knowledge of advanced features and data analysis.

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

Participants are entitled to one free follow-up training session, scheduled later to reinforce their learning.