Microsoft Excel Essentials for Administrators and Executives

Fee: RM 1,200 per pax (1-on-1) | RM 1,000 per pax (group) | Duration: ~ 8 hours |
Choose: 4 sessions x 2 hours or 2 sessions x 4 hours | PROMO🔥

Training Objective:

Participants will be equipped to apply key formatting, create basic formulas and charts, use useful Excel shortcuts, and confidently manage spreadsheets on a Windows PC to enhance their productivity in daily administrative or executive tasks.

Training Outcome:

Apply essential formatting, create basic formulas and charts, and use the most common time-saving Excel shortcuts.

☑️Complete routine tasks in minutes instead of hours.

☑️Overcome the fear or discomfort with spreadsheets.

☑️Gain lasting confidence in managing Excel like a pro

Module 1

Excel Cell Formatting Mastery: Numbers, Texts & Alignment Essentials

1.1 Excel Introduction: Interface, Structure & Essentials

1.2 Must-Know Cell Formatting Tricks

Module 2

Excel Layout & Navigation Mastery:  Smart Strategies for Efficient Spreadsheets

2.1 Mastering Filtering & Sorting

2.2 Paste Special Secrets: Save Time & Work Smarter!

2.3 Navigate Sheets Like a Pro: Effortlessly Move Rows, Columns, Sheets & More!

2.4 Print Like an Expert: Must-Know Tricks for Perfect Results

Module 3

Excel Functions & Formula Skills: From Basics to Powerful Lookups

3.1 Absolute vs. Relative References: Unlock the Secret Behind Every Smart Formula!

3.2 From Basics to Brilliance: Learn Excel Functions That Do the Heavy Lifting for You! [SUM, SUMIF, COUNT, COUNTIF, VLOOKUP, XLOOKUP, TEXTJOIN, CLEAN, TRIM]. ChatGPT for formula creation.

3.3 Clean Data: Spot & Remove Duplicates Like a Pro!

3.4 Text Magic Made Easy: Join, Organize & Transform Data in Seconds!

Module 4

Data Visualization & Excel Shortcuts: Work Faster, Present Smarter

4.1 Create Basic Charts Like an Expert!

4.2 Fifteen (15) Excel Shortcuts You’ll Wish You Knew Sooner – Work Faster, Smarter, Better!