Course Description

Microsoft Excel: Advanced Formulas and Functions will cover how to perform advanced searching and 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. The course focuses on practical examples that will help users easily transit to using these formulas and functions in real-world scenarios. Participants will be shown some of the most challenging formulas and functions in Excel and how to put them to their best use.

 

Example like how to do an enhanced searching in LookUp Functions. Complex formulas in Excel will be taught 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$540.00 per participant (Incl. 8% 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

CourseCodeVenueJun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23
Microsoft Excel: Advanced Formulas and Functions TGS-2020503211JTC Summit15-16-10-11-16-17-14-15
TGS-2020503211Mountbatten Square-20-21-11-12-16-17-

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$540.00 per participant (Incl. 8% 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 HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

ASK Training