ASK Training

Course Description

During our course “Microsoft Excel: Advanced Formulas and Functions” We will cover

  • How to perform advanced searching
  • Data retrieval with Lookup functions
  • Creation of statistic reports with criteria applied using Statistical functions
  • Extraction of required text from given string using Text functions,
  • And many more

 

Specifically, this course focuses on practical examples that will help individuals easily transit to using these formulas and functions in real-world scenarios. During this course, participants will also be shown some of the most challenging formulas and functions in Excel. While learning to put them to their best use.

 

Nonetheless, examples like an enhanced searching in LookUp Functions, Complex formulas in Excel will be taught in this course too.

Course Objectives

At the end of this course, you should be able to:

Use logical formulas to create conditions and return either TRUE or FALSE when their arguments are evaluated1

Use logical formulas to create conditions and return either TRUE or FALSE when their arguments are evaluated.

Use IFERROR ISERROR to identify and handle errors in a formula

Use IFERROR & ISERROR to identify and handle errors in a formula.

Control the math values by using the functions for accurate presentation1

Control the math values by using the functions for accurate presentation

Date functions to calculate and work out values related to days months and years.

Date functions to calculate and work out values related to days, months and years.

Identify extract clean up the text values in a long records

Identify, extract, clean up the text values in a long records

Use advanced presentation functions to manage a presentation file

Use lookup function to search for a value in a large database and returning the value in the same row in the index number position.

Use logical formulas to create conditions and return either TRUE or FALSE when their arguments are evaluated1

Use logical formulas to create conditions and return either TRUE or FALSE when their arguments are evaluated.

Use IFERROR ISERROR to identify and handle errors in a formula

Use IFERROR & ISERROR to identify and handle errors in a formula.

Control the math values by using the functions for accurate presentation1

Control the math values by using the functions for accurate presentation

Date functions to calculate and work out values related to days months and years.

Date functions to calculate and work out values related to days, months and years.

Identify extract clean up the text values in a long records

Identify, extract, clean up the text values in a long records

Use advanced presentation functions to manage a presentation file

Use lookup function to search for a value in a large database and returning the value in the same row in the index number position.

Course Outline

You will be learning the following:

  • IF, OR, AND, NOT
  • COUNTIFS, SUMIFS, AVERAGEIFS
  • MEDIAN, LARGE, SMALL
  • DAY, DAYS, MONTH, YEAR
  • WEEKDAY, WEEKNUM, DATEVALUE
  • NETWORKDAYS, WORKDAY, EDATE, EOMONTH, DATE
  • VLOOKUP, HLOOKUP, CHOOSE
  • MATCH, INDEX, OFFSET
  • IFERROR, ISERROR,
  • ISBLANK, ISNUMBER, ISTEXT
  • TYPE
  • ROUND, ROUNDUP, ROUNDDOWN
  • CEILING, FLOOR, INT
  • TRUNC, MOD, SUMPRODUCT
  • TEXT, VALUE, TRIM, LEN
  • LEFT, RIGHT, MID
  • FIND, SEARCH, REPLACE, SUBSTITUTE
  • DCOUNT, DCOUNTA, DGET
  • DAVERAGE, DSUM, DMIN, DMAX

Course Fees And Grants

S$535.00 per participant (Incl. GST)

 

Click here for UTAP Fundings

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueOct-22Nov-22Dec-22Jan-23Feb-23Mar-23
Microsoft Excel: Advanced Formulas and Functions TGS-2020503211JTC Summit25-26-28-29-16-17-
TGS-2020503211Mountbatten Square-21-22-30-31-13-14

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

S$535.00 per participant (Incl. GST)

 

Click here for UTAP Fundings

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRP Portal, you are strongly encouraged to use this platform for registration.

Browse Courses

Learning Paths

Master Microsoft Office

Master Microsoft Office

Become a Web Designer

Become a Web Designer

Become a Digital Marketer

Become a Digital Marketer

Become a Video Producer

Become a Video Producer