Excel Formula Workshop Perth
Mobile MOUSe / Scope Computer Vision is proud to announce a course
thats new and unique here in Perth, Western
Australia. Don't miss out on an opportunity to harness
the power of Excel. Click to download
the outline or click here to view
the outline.

•
Our
Excel formula course in Perth is conducted
at your premesis (office / factory) or...
• Alternatively, our formula
courses can be delivered at Unit 13 / 795 Beaufort St, Mt Lawley, Perth, WA.
• Small
group & one on one training (recommended 5 students
per class)
(maximum of 10 per class)
• We come to you with our laptop computers and
projection equipment

•
A high quality manual -> download
a sample
• Free downloadable practice files
• Free online support
• A certificate of attendance (on request)

| AT OUR PREMESIS... |
|
| Enrol 1 Student........................................................... |
$
255.00 |
| Enrol 2 Students.......................................................... |
$ 235.00 ea. |
| Enrol 3 Students.......................................................... |
$ 225.00 ea. |
| Enrol 4 Students.......................................................... |
$ 215.00 ea. |
| Enrol 5 Students.......................................................... |
$ 205.00 ea. |
| One on One training (price starting from)....................... |
$ 585.00 |
| Hourly Rate................................................................. |
$ 120.00 |
| |
|
| AT YOUR PREMESIS (MAX
OF 10 per GROUP)... |
|
| Enrol up to 10 students for
the day................................ |
$ 1275.00 |
| *
as of 1/1/2009 - if no onsite parking is freely available, a
parking fee will be levied. |
| One on One training (price
starting from)....................... |
$ 585.00 |
| Hourly Rate (starting at)............................................... |
$ 135.00 * |
| |
|
| *
Prices quoted are for Perth Metro (phone for regional pricing) |
| * ALL ICA COURSES are
GST FREE / EXEMPT |
|
| * ALL OTHER COURSES
are GST INCLUSIVE |
|
| |
|
• The more candidates you enrol, the cheaper
the course
• Our pricing structure is great for companies
and friends
• No hidden fees !!! All inclusive (note the
point below)
• Depending on the training location, a small
surcharge may apply (usually only applicable for one-on-one onsite
training)

• One day (9am - 3.30pm)

• All of our Nationally recognised training
is offered in association with Scope
Vision. Scope
Vision have won numerous National and State business awards.
Visit Scope
Vision. Training courses are also based on Certificate
I in Information Technology.

Not sure which course is the right one for you?
Take one of our free - zero obligation self
assessments here.

• Custom
sessions (i.e. you choose specific aspect(s) of Microsoft Word
that you would like to learn about), are also available

•
All courses are taught by experienced, certified and qualified instructors,
(minimum of 11 years training experience)
• Our trainers are known for their friendly
and helpful approach
• Each course comes with six months of free
online support
Remember, our pricing structure is unique. The more people you
enrol (we recommend a maximum of 5 students per class, but will
train up to 10 in a class) the cheaper our courses become (which
is great for companies and friends).
If you have any questions, queries or comments, please do not hesitate
to contact us.

Excel Formula Workshop
What is assumed of the students?
• Students have reasonable keyboard skills.
• Students have reasonable mouse skills.
• Students have a knowledge of Windows.
• Students have a strong exisiting knowledge of Excel.
Note that this course is well suited to users who work with microsoft excel on a regualr basis. If you would like to improve your knowledge of microsoft excel formulas or if you would like to take the functionality of your excel spreadsheets to the next level, through the creation of intermediate and advanced formulas, then this course is for you.
Session 1: Common Formulae
1.1 PEMDAS (BOMDAS) or (BEMDAS)
1.2 Named Ranges
• Naming Ranges Individually
• Creating Names in Bulk
• Using Names in Formulas
1.3 Simple Formulae
• SUM
• AVERAGE
• MIN
• MAX
• IF
• MODE
• LARGE
Session 2: Count Formulae
2.1 COUNT
2.2 COUNTA
2.3 COUNTBLANK
2.4 COUNTIF
Session 3: Date and Time Formulae
3.1 TODAY
3.2 NOW
3.3 DAY
3.4 MONTH
3.5 YEAR
3.6 NETWORKDAYS
3.7 DATEDIF
Session 4: Lookup and Reference Formulae as well as an Intro to
Nesting
4.1 VLOOKUP
4.2 HLOOKUP
4.3 LOOKUP
4.4 INDEX and nested MATCH
Session 5: Database Functions
5.1 DAVERAGE
5.2 DCOUNT
5.3 DCOUNTA
5.4 DMAX
5.5 DMIN
5.6 DSUM
5.7 DGET
5.8 DVAR
5.9 DVARP
5.10 DSTDEVP
5.11 DSTDEV
Session 6: Rounding Functions
5.1 ROUND
5.2 ROUNDUP
5.3 ROUNDDOWN
5.4 CEILING
5.5 FLOOR
5.6 INT
Session 7: Financial Functions
7.1 RATE
7.2 NPER
7.3 PV
7.4 PMT
Session 8: Other Useful Functions
8.1 VAR
8.2 VARP
8.3 STDEV
8.4 STDEVP
8.5 SMALL
8.6 RANK
8.7 TEXT
8.8 UPPER
8.9 LOWER
8.10 PROPER
8.11 OFFSET
8.12 MEDIAN
8.13 ISBLANK
8.14 ISTEXT
8.15 ISERROR
8.16 ISNUMBER
8.17 ISTEXT
8.18 SUMIF
8.19 SUBTOTAL
Session 9: Arrays, Concatenation & More
9.1 Joining results with Concatenation
9.2 Nailing more nested formulae
9.3 Array formulae
9.4 Custom {AVERAGE(IF)}
9.5 Custom {SUM(IF)}
9.6 Custom {MIN(IF)}
Session 10: Formula Auditing
10.1 Auditing Formulas
• Auditing formulas
10.2 Locating and Resolving Errors
• Using the formula checker to resolve errors
10.3 Finding Precedents
|