| |
Excel – formulas & functions 
Building basic formula
- Understanding operator precedence
- Relative and absolute address notation
Using names in formulas
- Inserting names into a formula
- Applying names to formulas
Working with links in formulas
- Concepts of external references
- Updating links and changing link source
Formatting numbers, dates and times
- Numeric display formats
- Date and time display formats
Understanding Excel’s error values
- #DIV/0!
- #N/A
- #NAME?
- #NULL!
- #REF!?
- #VALUE!?
Working with text functions
- Char(), code(), lower(), upper(),proper(), dollar(),
- fixed(),text(),trim(),clean(),rept(),left(),right(),mid(), replace(),substitute()
- Extracting first name, last name
 |
|
 |
| |
Client Testimonial
“… Their training programmes are well organised, practical and useful in our work. I am particularly impressed by their training materials and their highly professional trainers.”
Mr. Thomas Ng – Head of Graphic Unit
Hong Kong University of Science and Technology
“… I must say that I have benefited greatly. Each course is well designed, interesting and easy to follow as well as practical. The result is instant… I have no hesitation in recommending these Photoshop computer courses … to those interested in pursuing the satisfaction of image management. “
Dr. Francis Siu (FPSA, FRPS, EFIAP, Hon FPSHK)
"Very enjoyable. Useful material that can be applied for job & normal uasge."
Mr Oliver So
more ...
|
|
 |
|
 |
|
Working with date and time functions
- How to return a date, a time
- How to return part of a date or part of a time
- Calculating the difference between two dates or between two times
Working with Math function
- Round(), mround(), rounddown(), roundup(), ceiling(), floor()
Working with Database functions
- Dsum(), Daverage(), Dcount(), Dmin(), Dmax()
Working with Financial functions
Working with Logical functions
- AND, FALSE, NOT, OR, TRUE, IF, SUMIF(), COUNTIF()
Working with lookup functions
- Lookup(), Vlookup(), Hlookup(), Index(), Match(), Offset()
|
