INTRODUCTION

This comprehensive one-day training program is designed to build upon your existing Excel knowledge and take your skills to the next level. Throughout the day, we will dive into intermediate-level concepts and techniques that will empower you to manipulate data, perform advanced calculations, and create visually appealing reports and analyses.

This training is specifically tailored for individuals who are familiar with the basics of Excel and are eager to expand their proficiency in this powerful spreadsheet software. Whether you’re a business professional, analyst, student, or anyone who works with data, this training will equip you with the necessary tools and techniques to work more efficiently and effectively in Excel.

We have carefully structured the training agenda to cover a wide range of topics, including data manipulation and analysis, formulas and functions, advanced formatting techniques, data analysis tools, data validation, and collaboration features. By the end of the day, you will have gained valuable skills and knowledge that can be immediately applied to your everyday work tasks.

Throughout the training, we encourage active participation, as you will have opportunities to practice the concepts through hands-on exercises and engage in discussions. Additionally, we will provide you with valuable resources and references to support your continued learning beyond this training.

 

COURSE OBJECTIVES

Enhanced Spreadsheet Proficiency

Participants will gain fundamental skills in Excel, enabling them to navigate the interface, enter data, and perform basic calculations. This proficiency forms the basis for more advanced Excel usage in professional settings.

Improved Data Accuracy

Understanding basic formulas and functions equips participants with the ability to perform accurate calculations, reducing the risk of errors in their work.

Efficient Data Management

Participants will learn data sorting, filtering, and manipulation techniques, allowing them to organize and manage data effectively. This skill is crucial for tasks involving large datasets.

Visual Data Representation

Through the creation and customization of charts and graphs, participants will learn how to visually represent data. This skill aids in making data-driven decisions and conveying information effectively to others.

Time-saving Techniques

Knowledge of shortcuts and efficient formula copying methods enhances productivity, enabling participants to accomplish tasks in less time.

 

COURSE CONTENT

DAY 1 : INTERMEDIATE EXCEL SKILLS AND TECHNIQUES

TEMPLATES

• Using templates
• Creating Excel templates

PASTE SPECIAL OPTIONS

• Using Paste Special to add, subtract, multiply & divide
• Using Paste Special ‘values’.
• Using Paste Special transpose option

PIVOT TABLES

• Using a Pivot
• Filtering and Sorting Data
• Grouping Data
• Creating and using a pivot
• Filtering and sorting data within a pivot
• Automatically grouping data in a pivot table and renaming
• Manually grouping data in a pivot table and renaming

INPUT TABLES

• One-input data
• Two-input data

STATISTICAL FUNCTIONS

• COUNT
• COUNTA
• COUNTIF
• COUNTBLANK

 

DAY 2 : ADVANCED EXCEL SKILLS AND TECHNIQUES

TRACKING & REVIEWING CHANGES

• Enabling or disabling the ‘track changes’
• Sharing, comparing and merging

SCENARIOS

• Scenario
• Scenario summary

FINANCIAL FUNCTIONS

• FV
• PV
• NPV
• RATE
• PMT

LOOKUP FUNCTIONS

• VLOOKUP
• HLOOKUP
• XLOOKUP

DATABASE FUNCTIONS

• DSUM
• DMIN
• DMAX
• DCOUNT
• DAVERAGE

MACROS

• Using Macros
• Assigning a Macro to a Button on the Quick Access Toolbar
• Deleting Macros

 

METHODOLOGY

An adult learning approach using a combination of lectures and simulation, exercises, hands-on with close supervision by the trainers, presentation, management games & group discussions

 

WHO SHOULD ATTEND?

Open to all

 

 

TRAINER (either one of them)

Fakhrul Syahmi (either one of them)

Hazry Hidzir

Shamsiyah Abd Kadir

Suhaily Georga Abdullah

Adila Diyana Erwan

Kamil Rohman

 

FEES (WITHOUT ACCOMODATION)

RM1,100.00 per pax

Early Bird RM1,000.00 per pax

(20 days before program)

2 pax RM 1,050.00 per pax

3 pax > RM1,000.00 per pax

(This fees is inclusive of 2 morning tea breaks, 2 lunch , 2 afternoon tea breaks, notes and certificate of attendance for the participants)