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)

• 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

Onsite training at our clients premises. We come to you !! Alternative venues available.

We provide laptops for the duration of the course. No strain on your IT resources.

All courses come with a quality manual, workbook & exercise cdrom, unlike other providers.

Cost-effective price structure. The more students you enrol, the cheaper the course.

Structured (but flexible) nationally accredited curriculum.

Courses are also designed around Microsoft Office User Specialist certification.

Small personalised groups and one-on-one training.

6 months of free post-course support.

We can also design and provide custom, tailor made courses.

Certified, qualified and experienced trainers.

Training some of the biggest companies in Western Australia.