Excel Functions & Formulas: Tips & Tricks

Microsoft Excel Functions & Formulas Training Course Microsoft® Excel Tips & Tricks
By TED Integrated
Course Title:
Tips & Tricks in Microsoft® Excel Functions & Formulas
Training Category:
Information Technology
Target Audience:
Those who have good basic of Microsoft® Excel and would like to discover the secrets of functions & formulas that make them standout from the crowd.
Duration:
2 Days
Public Training Events
Jun 2017 ›
Venue:
TED Learning Center, Binjai 8, Malaysia
Schedule:
Mon 19 Jun 2017 - Tue 20 Jun 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,000.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.

Course Introduction ›

Formulas are critically important to every Excel users. They are what make a spreadsheet a spreadsheet. This one-of-a-kind course delivers all the tips and techniques one needs to maximize one of the most powerful spreadsheet tools: formulas. The more you know about formulas, the better your spreadsheets will be. Hence the course is to aim to get the most out of worksheet formulas.

Course Objectives ›

Upon completion of this 2-day Microsoft® Excel Functions & Formulas training course, participants should be able to:

  • Have a deep understanding on how functions work and how functions complement each others.
  • Develop mega formulas by combining various functions in a single formula hence creating powerful spreadsheet.

Course Outline ›

DAY 1

Module 1: Date & Time Category Functions

  • TODAY
  • NOW
  • DATE
  • DATEDIF
  • DAY
  • MONTH
  • YEAR
  • YEARFRAC
  • EDATE
  • EOMONTH
  • WEEKDAY
  • WEEKNUM
  • NETWORKDAYS.INTL
  • WORKDAY.INTL

Module 2: Logical Category Functions

  • AND
  • OR
  • IF
  • Nested IF
  • IFERROR

Module 3: Financial Functions

  • SYD
  • FV
  • PMT
  • RATE

Module 4: Working with Names

  • What's in a Name?
  • Creating Names Using the Define Name Dialog Box
  • Creating Names Using the Name Box
  • Rules for Naming Names
  • Creating Names Automatically
  • Naming Entire Rows and Columns
  • Creating Multisheet Names
  • Creating a List of Names
  • Using Names in Formulas
  • Applying Names to Existing Formulas
  • Deleting Names
  • Deleting Named Cells or Ranges
  • Redefining Names
  • Changing Names
  • How Excel Maintains Cell and Range Names
  • Name Problems when Deleting Sheets
  • The Secret to Understanding Names
  • Naming Constants
  • Naming Text Constants

Module 5: Information Category Functions

  • CELL
  • IS Functions
  • ISEVEN
  • ISODD
  • TYPE
DAY 2

Module 6: LookUp & Reference Category Functions

  • CHOOSE
  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • OFFSET
  • INDEX
  • MATCH
  • INDEX & MATCH

Module 7: Text Category Functions

  • CLEAN
  • CONCATENATE
  • EXACT
  • LEFT
  • MID
  • RIGHT
  • LEN
  • FIND
  • SEARCH
  • REPLACE
  • SUBSTITUTE
  • LOWER
  • PROPER
  • UPPER
  • REPT
  • TEXT
  • TRIM

Module 8: Math Category Functions

  • ABS
  • POWER
  • SQRT
  • EVEN
  • ODD
  • INT
  • TRUNC
  • MOD
  • PRODUCT
  • CEILING
  • FLOOR
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SUBTOTAL
  • SUMPRODUCT
  • SUMIF
  • SUMIFS

Module 9: Statistical Category Functions

  • COUNT
  • COUNTA
  • COUNTIF
  • COUNTIFS
  • COUNTBLANK
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
  • MODE
  • RANK
  • CORREL
  • TREND

Contact us now ›

Related Courses ›

Published by: ,