Training Course:Excel - Formulas and FunctionsSchool/Trainer:Ian Fraser Consulting
Melbourne, Victoria, Australia
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' At the end of the course participants will be able to:
Understand basic mathematical formulas in Excel
Understand the BODMAS method of calculations
Use absolute references when copying formulas
Create linking formulas between worksheets
Understand and use a variety of functions in Excel
Course Topics
Formulas
What is a formula
BODMAS theory
Creating a formula
Copying formulas
Absolute References in formulas
Linking Formulas
Advantages of Linking
Creating a link
Functions
What is a function
Function syntax
Using Paste Function
Date Functions
The Today function
The Now function
Text Functions
The Upper function
The Lower function
The Proper function
Math and Trig Functions
The Sum function
Using AutoSum
The Average function
The Min function
The Max function
The Count function
The CountA function
The CountBlank function
The Int function
The Round function
The RoundUp function
The RoundDown function
Financial Functions
The Payment Function (PMT)
Logical Functions
The If Function
The Countif function
Is Functions
The IsError Function
The IsText function
The IsBlank function
Lookup Functions
The VLookup Function
The HLookup function
...''
Please go to the school's official website for training price and schedule:
http://www.ianfraserconsulting.com.au/
Phone:(03) 9489 7989
School Address:
Ian Fraser Consulting
10 Wakanui Street
Northcote Victoria 3070
Australia
Jobs & Resumes: Melbourne
Houses & Roommates: Melbourne
Travel Agencies: Melbourne
Search other schools for Excel - Formulas and Functions training resources.
Other training courses offered by Ian Fraser Consulting:
Adobe Acrobat
Adobe Dreamweaver
Adobe Photoshop
Adobe Illustrator
InDesign CS3
Access Introduction
Access Advanced
Excel Introduction
Excel Advanced
Excel - Managing Databases
Frontpage Introduction
Outlook
Powerpoint Introduction
Powerpoint Advanced
Project Advanced
Project Introduction
Publisher
Word Advanced
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later. |
|
| 
