MS Excel Flexible Training
You too can benefit from our 25 years
continuous MS Excel flexible training
and development at your level & pace!
Would you like to learn the real power of Excel Spreadsheets from an
expert who has been developing and training Spreadsheets since 1982?
No more waiting for a class to fill, we can train you One-on-One or your organisation’s small group,
in flexible 2 or 3 Hour units at time suitable to you or your staff, at our office or yours.
Call us now on 9275-9188 to experience one of WA’s most popular Microsoft Excel Spreadsheet Training Courses. Our courses are flexible to suit your needs, skill level, and time constraints, at your office, or ours.
More and more of our Happy Clients tell us that they prefer our
method of Two or Three Hours Training at any one time.
We train at 3 Levels: Basic – Intermediate – Advanced,
to allow you to use Excel fully, 2003 and/or 2007.
We also develop Excel Templates for Your Business.
This can be part of the training course.
Call us now on 9275-9188. If we are not in our office, we will
try to get back to you within 5 minutes!
How we Can Help You ………..
-
Provide One-On-One or Small Group (from your organisation) Training.
-
Training can be Customised for Your Skill Level.
-
Training at Two or Three Hours at a time so that you retain what we teach.
-
Totally Hands-On Training at your Speed.
-
Training times are flexible, to suit your busy schedule.
-
Training can include working on your own Workbooks to solve problems.
-
Templates we train you on, can be used at your work.
-
We can come to your office/site, if required.
We also can develop custom reports with data derived from
your Accounting Software such as Myob & Quickbooks.
A past trainee, Lynda, 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”.
Another client, Nelson, 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 wrote the following:
“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 wrote:
“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 learnt 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”.
|
FREE Training Voucher! |
 |
Need help with tedious End-of-Month reporting. Let us automate this function with data from your Accounting Software.
MS Excel to Access Data Conversions
Convert your “stand alone” Excel Spreadsheets into an integrated database. All your vital Business Data can easily be shared and updated by everyone in your Team. Contact us to find out more.
For more information about Excel Training & Support in Perth, please contact us. We aim to Help you to Grow your Business!
Each Excel training course allows for the trainee to work on a “real-life” Excel example which is done first on his/her own, and then revised with the Trainer. Trainees are also encouraged to bring Excel samples from work so that we can assist to setup a working template which they can use with their work.
View the Course Outline below – (We also offer Advanced Training to match your Skill Level):
- 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
Call us Now on (08) 9275-9188 to see how we can solve Your speadsheet problems.
