Excel Functions Tailored for
Your Job Role
Embedded Files
In this course, participants will receive focused training on Excel functions. If the course exceeds 3 hours, multiple sessions (3 hours per session) can be arranged to cover all the content. Practice files will be provided during the sessions, and the trainer will guide participants in becoming familiar with these functions. Additionally, the entire session will be recorded, and a link to download the recording will be provided for future reference.
01. Administrative Support
01. Administrative Support
Must-Learn Excel Functions for Administrative Support:
SUM
AVERAGE
MIN / MAX
COUNT / COUNTA
IF
TEXT
CONCAT / TEXTJOIN
VLOOKUP / XLOOKUP
INDEX-MATCH
TRIM
LEFT, RIGHT, MID
NOW
TODAY
NETWORKDAYS
Estimated Training Time & Charges :
For Beginner Participants: 6–7 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 4–5 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
02. Customer Service
02. Customer Service
Must-Learn Excel Functions for Customer Service:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
RANK
Estimated Training Time & Charges :
For Beginner Participants: 6–7 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 4–5 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
03. Inventory Management
03. Inventory Management
Must-Learn Excel Functions for Inventory Management:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
ROUND, ROUNDUP, ROUNDDOWN
INDEX-MATCH
MIN / MAX
Estimated Training Time & Charges :
For Beginner Participants: 7–8 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 5–6 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
04. Human Resources (HR)
04. Human Resources (HR)
Must-Learn Excel Functions for Human Resources:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
NETWORKDAYS
RANK
ROUND, ROUNDUP, ROUNDDOWN
Estimated Training Time & Charges :
For Beginner Participants: 6–7 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 4–5 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
05. Sales & Marketing
05. Sales & Marketing
Must-Learn Excel Functions for Sales & Marketing:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
RANK
ROUND, ROUNDUP, ROUNDDOWN
INDEX-MATCH
SUMPRODUCT
Estimated Training Time & Charges :
For Beginner Participants: 6–7 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 4–5 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
06. Finance & Accounting
06. Finance & Accounting
Must-Learn Excel Functions for Finance & Accounting:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
ROUND, ROUNDUP, ROUNDDOWN
INDEX-MATCH
PMT
NPV
IRR
FV
PV
RATE
SLN
DB
Estimated Training Time & Charges:
For Beginner Participants: 10–12 hours | RM 1,450 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,250 per personFor Intermediate Participants: 6–8 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per person
07. Suppy Chain & Logistics
07. Suppy Chain & Logistics
Must-Learn Excel Functions for Supply Chain & Logistics:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
ROUND
MATCH
INDEX
SUMPRODUCT
DATEDIF
NETWORKDAYS
FORECAST
Estimated Training Time & Charges:
For Beginner Participants: 7–8 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 4–5 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
08. Procurement
08. Procurement
Must-Learn Excel Functions for Procurement:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
ROUND, ROUNDUP, ROUNDDOWN
INDEX-MATCH
SUMPRODUCT
IFERROR
MIN / MAX
FORECAST
Estimated Training Time & Charges:
For Beginner Participants: 7–8 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 5–6 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
09. Project Management
09. Project Management
Must-Learn Excel Functions for Project Management:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
ROUND, ROUNDUP, ROUNDDOWN
INDEX-MATCH
SUMPRODUCT
NETWORKDAYS
WORKDAY
PMT
IFERROR
Estimated Training Time & Charges:
For Beginner Participants: 7–8 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 5–6 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
10. Commercial Excellence
10. Commercial Excellence
Must-Learn Excel Functions for Commercial Excellence:
SUM
AVERAGE
COUNT / COUNTA
IF
VLOOKUP / XLOOKUP
TEXT
CONCAT / TEXTJOIN
LEFT, RIGHT, MID
TRIM
NOW
TODAY
COUNTIF / SUMIF
AND / OR
ROUND, ROUNDUP, ROUNDDOWN
INDEX-MATCH
SUMPRODUCT
RANK
IFERROR
Estimated Training Time & Charges:
For Beginner Participants: 7–8 hours | RM 1,200 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,000 per personFor Intermediate Participants: 5–6 hours | RM 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 per person
Page updated
Google Sites
Report abuse