Mobile MOUSe online

     
 
Excel Training | Word Training | Access Training | Outlook Training | PowerPoint Training | Visio Training | Project Training | Publisher
 

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.

excel course information

• Our Excel formula course in Perth is conducted at your premises (office / factory) or...

• Alternatively, our formula courses can be delivered at Unit 19 / 1904 Beach Rd, Malaga, 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

what is provided in the excel training course

• A detailed high quality manual -> download a sample

• Free downloadable practice files

• Free online support

• A certificate of attendance (on request)

excel course training fees

Option 1
AT OUR premises
Enrol 1 Student...........................................................
$ 255.00
Enrol 2 Students..........................................................
$ 240.00 ea.
Enrol 3 Students..........................................................
$ 230.00 ea.
Enrol 4 Students..........................................................
$ 220.00 ea.
Enrol 5 Students..........................................................
$ 215.00 ea.
   
NOTE: Hassle Free - FREE PARKING at our premises  
   
Option 2
AT OUR premises
Buy 10 Vouchers (single enrolment 1 day courses)......... $ 2000.00
   
NOTE: Hassle Free - FREE PARKING at our premises
   
Option 3
AT YOUR or OUR premises (MAX OF 14 per GROUP)
Enrol up to 5 students for the day..................................
$ 1075.00
This special enrol up to 5 rate is only applicable to Essentials courses and does not cater for Microsoft Access.
   
Enrol up to 10 students for the day................................
$ 1575.00
Each extra enrolment over 10 students (per head)..........
$ 100.00 ea.
   

Option 4
REGIONAL

Regional / Country Training.......................................... Phone
   
Other Options  
One on One training (price starting from)....................... Phone
Hourly Rate (starting at)............................................... Phone
One on One training (price starting from)....................... Phone
Hourly Rate................................................................. Phone
 

* Prices quoted are for Perth Metro (phone for regional pricing)
* ALL ICA COURSES are GST FREE / EXEMPT  
* ALL OTHER COURSES are GST INCLUSIVE  
* If no parking is freely available, a parking fee will be levied.
   

• 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)

excel training - course duration

• One day (9am - 4.00pm)

training certification offered

• 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.

Mobile MOUSe

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

custom excel training

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

trainer and support information

• All courses are taught by experienced, certified and qualified instructors, (minimum of 15 years training experience)

• Our trainers are known for their knowledge and helpful, friendly 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 14 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 very good keyboard skills.
Students have very good mouse skills.
Students have a solid knowledge of Windows.
Students have a considerable experience with Excel.

This course is designed for people who need to come to grips with more complex formulas. Anyone who regularly setups and maintains formulas or need to understand more complex formulae, is an ideal candidate to attend this course.

Please note that this course is not intended for novice users of Microsoft Excel. Attendees should already have High Intermediate or Advanced skills in Microsoft Excel..

Venue and Duration

Venue:
Onsite (your premises) or Inhouse (our premises)

Duration:
1 Full Day (9am - 4pm)

Part One: Common Formulae

• BIMDAS
• SUM / AVERAGE / MEDIAN / MIN / MAX
• Percentages / Absolute Referencing
• IF
• MODE / LARGE / SMALL

Part Two: Count Formulae

• COUNT / COUNTA
• COUNTBLANK
• COUNTIF / COUNTIFS

Part Three: Date and Time Formulae

• TODAY / NOW
• DATEDIF / DAY / MONTH / YEAR / DATE
• WORKDAY / NETWORKDAYS / EDATE

Part Four: Lookup Formulae

• VLOOKUP / HLOOKUP / LOOKUP
• INDEX / MATCH / INDIRECT

Part Five: Rounding Functions

• ROUND / ROUNDUP / ROUNDDOWN / MROUND
• CEILING / FLOOR / INT

Part Six: Financial Functions

• RATE / NPER / PV / PMT

Part Seven: Text Functions

• CONCATENATE / &
• LEFT / RIGHT / MID
• TRIM / REPLACE / LEN
• TEXT / REPT
• UPPER / LOWER / PROPER

Part Eight: Database Functions

• DAVERAGE / DCOUNT / DCOUNTA
• DMAX / DMIN / DSUM
• DGET / DVAR / DVARP
• DSTDEV / DSTDEVP

Part Nine: Other Useful Functions

• VAR / VARP
• STDEV / STDEVP
• RANK / PERCENTILE
• ISBLANK / ISNUMBER / ISTEXT
• ISERR / ISERROR / ISNA
• SUBTOTAL
• SUMIF / SUMIFS

Part Ten: Array Functions

• Creating multiple cell arrays
• Creating single cell arrays
• Creating custom array functions

Part Ten: Formula Auditing

• Auditing Formulas
• Locating and Resolving Errors
• Finding Precedents & Dependants
• Watch Window

 

 
 
   
 
 
 

Microsoft Word Training Perth
Excel Training Perth
Access Training Perth
PowerPoint Training Perth
Outlook Training Perth
Project Training Perth
Visio Training Perth
Publisher Training Perth

 
 
 

Onsite training at our clients premises. We come to you !! Our venue is also available.

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

All courses come with a quality manual and downloadable practice files.

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.