Excel - Starting off with Formulas and Functions (Intermediate)

HRDCORP CLAIMBLE COURSES (SBL-KHAS)

INTRODUCTION

This 2-day learning incorporates newer functions from Excel 365 to reduce non-value adding time spent in spreadsheets.

It is updated with new functions from Microsoft for Excel 365. Participants who do not have the newer Excel versions are also encouraged to sign up to view these new functions.

OBJECTIVE

You will be able to understand and apply crucial formulas and functions in your work environment. You will be taught specific formulas on how they work best in specific scenarios and when they do not work.

C OURSE REQUIREMENT

• Stable Internet Connection

• Webcam and Earphones

• Required software: Excel 365

• If the participant has 2 computer monitors it is encouraged that the participant use them.

*This is a hands-on workshop, packed with exercises. All participants must each have a Computer/Laptop.

COURSE CONTENT

Module 1: Introduction

• Absolute and Relative Cell References

• The Formula Bar and the Insert Function Tool

• The Name Box, Naming and Editing Cell Ranges

• The Status Bar

• Basic Excel Function Syntax

• Nested Formulas

Module 2: The New Array Formula Platform

• Evaluating Array Formulas vs Normal Formulas

Module 3: Logical Functions

• IF

• IFS

• IFERROR

Module 4: Sum and Count Functions

• SUMIF, SUMIFS, DSUM

• AVERAGE, AVERAGEA

• COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS

• SUMPRODUCT

Module 5: Text Functions

• CONCATENATE

• LEFT, RIGHT, MID, TEXT

• LOWER, UPPER, PROPER

• TRIM, CLEAN

• SUBSTITUTE

• FIND

• TEXT

Module 6: Date and Time Functions

• The Date Format and Value of Date Cells

• EDATE, EOMONTH, DAYS, DAYS360, NETWORKDAYS, NETWORKDAYS.INTL, NOW

Module 7: Form Controls

• Scroll Bar

• Drop-Down Box

Module 8: Look-Up Related Functions

• VLOOKUP

• INDEX, MATCH

• XLOOKUP

• TRANPOSE

• UNIQUE

• FILTER

• SORT

• Working Functions with Form Controls

Module 9: Other Important Tools on Formulas

• Formula Auditing

• Displaying Formulas

• Error Checking and Tracing Errors

• Evaluating Formulas

• Calculation Options

• Copying and Pasting Formulas

• Comparing Conditional Sum, Count Functions with Database Functions

Module 10: Quick Summation Methods

• Using Shortcut Keys and AutoSum

Module 11: Customizing Number Formats

• Examining Number Formats and Changing Them

• Customizing Number Formats with Advanced Methods

WHEN & WHERE

18 & 19 August 2025 (Monday & Tuesday); 9.00am to 5.00pm

Remote Online Learning (Zoom)

WHO SHOULD ATTEND

Data Analysts, Project Managers, Revenue Managers, Finance Managers, Human Resources and anyone who uses Excel regularly and wish to have an in-depth dive on critical and essential Excel functions and formulas.

T RAINING INVESTMENT

RM 1,400.00 per participant for 2 days (inclusive of Service Tax, Online Course Materials, E-Certificate of Attendance)

HRD Corp Claimable (SBL-Khas)

REGISTER HERE: https://carriera.com.my/index.php/training-registration-hrdf-sbl-claimable/

DOWNLOAD BROCHURE HERE: https://carriera.com.my/wp-content/uploads/2025/06/Excel-Starting-off-with-Formulas-and-Functions-Intermediate.pdf