UEN No.: 198802365N

Contact Us
Enquire Now
Course Schedule

Leveraging Functions and Formulas using MS Excel

Funding Validity Period
-
Non-Funded

Course Overview

Explore the power of Excel through this comprehensive course designed to enhance your skills in data manipulation and analysis

Skills Acquired

At the end of the course, participants will be able to use Excel Functions and Formulas more effectively.

Learning Modules

  • Using SUM, AVERAGE, MAX, MIN, COUNT, COUNTA Functions
  • Using Date and Time Functions: TODAY, NOW, DAY, MONTH, YEAR, DATE, TIME
  • Using Mathematical Functions: ROUNDDOWN, ROUNDUP, SUMIF
  • Using Statistical Functions: COUNTIF, COUNTBLANK, RANK
  • Using Text Functions: LEFT, RIGHT, MID, TRIM, CONCATENATE
  • Using Lookup Functions: VLOOKUP, HLOOKUP
  • Use Database Functions: DSUM, DMIN, DMAX, DCOUNT, DAVERAGE
  • Using Logical Function: IF, NESTED-IF, ISERROR, OR, AND
  • Understanding Cell References in Formulas: Relative, Absolute, Mixed Reference
  • Using a 3-D reference within a SUM Function
  • Using TRANSPOSE Function
  • Data Validation: Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time
  • Handling Error displays in Formulas:#######, #REF!, #NAME?, #DIV/0!, #VALUE!
  • Auditing Functions: Trace precedent, dependent cells. Identify cells with missing dependents, Error Checking for Circular Reference, Watch Window
No data was found

Who is this course is for

This course is suitable for participants who need to utilise the various pre-set functions in Microsoft Excel to create formulas and perform calculations.

Academic prerequisites

  • Learners must be able to read, write, speak and listen to English at secondary school level
  • Learner should have working knowledge of Microsoft Excel

Course Fees

Fees Company / Self Sponsored
Full Fee $300
GST $27
Nett Fee Payable (incl. GST) $327

Register Now

Leveraging Functions and Formulas using MS Excel

Download Brochure

Course Highlight

Course Duration

8 HRS

Training Time

9am-6pm

Mode of Training

Classroom

Course Reference Number
Corporate Subsidy
Individual Subsidy
Register
View Dates or Register Now
Make Enquiry
View fees
Register Now

Have More Questions?

Lets start a conversation to upgrade your skillset

Start Improving Now

Other relevant courses

Lorem ipsum dolor sit amet consectetur. Arcu eu diam urna eu lorem leo tellus lectus. Enim proin hac quis placerat maecenas aliquam nunc viverra quis.

NEW

Mastering Excel with AI and CoPilot
UTAP
8 HRS Course
Learn More

WSQ

Registered

Perform Spreadsheet Functions 24 hours
24 HRS Course
Learn More
Power Query and Power Pivot (Excel 365)
8 HRS Course
Learn More

UEN No.: 198802365N

Search
Corporate Training
Enquire Now
Course Schedule
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration