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

• A detailed 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 - 4.00pm)

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

 

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.