Leveraging Functions and Formulas using MS Excel
Who Should Attend
This course is suitable for participants who need to utilise the various pre-set functions in Microsoft Excel to create formulas and perform calculations.
Course Duration
1 Day
Total Training Duration (Hour)
8
Course Outline
- 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
Course Learning Outcome
- Learners must be able to read, write, speak and listen to English at secondary school level
- At the end of the course, participants will be able to use Excel Functions and Formulas more effectively.At the end of the course, participants will be able to use Excel Functions and Formulas more effectively.
Pre-requisites
- 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 Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $300.00 | $327.00 |
Please note that prices are subjected to change.
