Microsoft Excel Expert Training and Programming

Beginner to Intermediate. (6 Hours – 3 x 2 Hour Units)

Getting started with Excel:

• Starting Excel
• Selecting ranges
• Exiting Excel

Working with worksheet data:

• Creating new workbooks
• Entering data
• Saving and closing new workbooks

Editing data:

• Opening existing workbooks
• Working with Text
• Editing cell data
• Saving and closing a workbook with a different filename

Basic Formulae:

• Addition, @Sum, Auto-Sum
• Subtraction
• Multiplication
• Division
• Percentage
• Date
• Error Trapping & Tips to Avoid Disaster!
• Cross Checking Formulae

Deleting and moving data:

• Erasing cell data
• Cutting and pasting data
• Moving data using the drag-and-drop feature
• Undo

Printing worksheets:

• Defining page setup options
• Creating headers and footers
• Changing margins
• Changing print size
• Previewing print jobs
• Printing worksheets

Formatting worksheets:

• Inserting and deleting rows and columns
• Changing column widths
• Changing the alignment of data

Using numeric formats:

• Using the number format
• Using the currency format
• Using the comma format
• Using the percent format
• Using the data format

Intermediate Features (3rd Unit on 6 Hour Course or 1st Unit on Intermediate / Advanced

Course over 4 or 6 hours:

• Using Excel as a Database
• Data Entry Form
• Sorting
• Filtering
• Conditional Formatting
• Multi-Worksheet linking
• Protect your Formulae
• Intro to Charts

2nd Unit on Intermediate/Advanced Course:

• Count Functions
• Summary Levels
• Lookup Formulae
• Logical Formulae
• More Charting
• Named Ranges
• Absolute References
• Filling Data
• Pivot Tables
• Validations
• Pick Lists
• Import/Export
• Web Queries
• Macros

One-on-One (or your small group) 6 Hours Training (at our Office)

Only $370.00 + GST per person

For our Introduction to Excel Course (6 Hours).

Group Discounts are available.

Eg: 2 people trained at the same time = $250.00+GST Each.

(3 x 2 Hour Units OR 2 x 3 Hour Units )

on different days to suit your busy schedule)

This is incredible value for Customised One-on-One Training.

Saturday training is also available.

More and More attendess are learning how easy it is to makehuge mistakes in Excel which can cost $1000s. We show you how to minimise such potential costly mistakes!

Dominique Bremner writes…

I have been running a business with my husband since 1998 and recently upgraded from MS Office 2003 to 2010, being self-taught I could see I needed to up skill immediately to make the most of the software.

Ivor’s company seemed to be the only training company offering the one on one training I desired so I booked in for some excel training.

The training was broken down into three sessions of two hours which I found was just enough to cover a good amount of new information and retain it, this also enables you to go away and digest the information and practice in your own time before moving onto the next session. I found the one on one training to be invaluable, much more beneficial than a classroom situation. Ivor is professional and patient and has many tips and tricks which you wouldn’t get in a classroom.

I am very happy with my training and would highly recommend Ivor, I will be back for some Word training and some advanced Excel Training.

11th July 2011.

Lynda (HR Administrator) writes:

Your suggestion of 3 x 2 hour sessions over 3 days was perfect. It allowed me to learn at a steady pace and facilitated me to have time to practice what I had learned in one session before moving on to the was paramount in my success in grasping all the aspects of
Excel that I requested be covered in my training. The formulas training in particular was absolutely brilliant and again your style of delivery in allowing me to do everything myself greatly assisted me in grasping all the concepts.

Nelson (Business Consultant) writes:

Thanks very much again for completing the additional changes to the templates so promptly this morning. I must say that I am totally impressed with your competence and urgency in this matter for my client and will most certainly be utilising your skills and services again in the future as well as passing on your information for any requested
templating/databasing work.

Reg (Business Owner) writes:

I just wanted to thank you for the training provided. Although I was sceptical about spreading the training over 3 x 2 hour sessions at first, I have to say that I found it very beneficial. I was able to take in the information gradually and go away and think about it.This allowed me to prepare with any questions before the next lesson.
I also found the one on one approach to training very beneficial. I was able to ask questions and get the answers I needed.

Karen (Teacher Co-ordinator) writes:

Firstly, thank you for sending such a wonderful teacher. I have been using excel for a number of years and feel reasonably confident with it. I learn’t some great things and when I asked specifically about conditional formatting, your trainer took his time to explain to me in easy to understand terms how this worked. He is a real credit to your company,acted very professionally and was able to help everyone at all levels.

Deborah (Office Administrator) writes:

Connie said your Trainer was great very helpful, kept things simplistic, splitting the training into 3 days was perfect as it doesn’t become too overwhelming.

Sandy (Personal Assistant to CEO) writes:

Thank you so much for your one on one training for Basic Excel. You made learning easy with your calm, patient style of training and made me feel at ease to ask questions when I did not understand something. I preferred the 2 hour sessions spread over 2 weeks as this enabled me to take what I learnt from each lesson and put it into practice before moving on to the next one.