Excel Training in Perth
Find out why Mobile MOUSe / Scope Computer Vision is fast becoming
the preferred excel
training provider for some of WA's largest companies.
We now have a course thats new and unique here
in Perth, Western Australia. Check
out our new Excel
Formula Course.

•
Our Excel
training in Perth is conducted at your premises (office
/ factory) or...
• Alternatively, our Excel
Courses can be delivered at Unit 19 / 1904 Beach Rd,
Malaga, Perth, WA.
• Nationally recognised microsoft
excel training
• Small
group & one on one training (recommended 5 students
per class)
(maximum of 14 per class)
• We come to you with our laptop computers and
projection equipment to deliver our excel
course.

•
A detailed high quality manual -> download
a sample
• Free downloadable practice files
• Free online support
• A certificate of attendance (on request)

We currently offer three levels of Microsoft
Excel training...
• Microsoft
Excel Essentials ( intro & intermediate )
• Microsoft
Excel Expert ( advanced )
• Microsoft
Excel Formula Workshop ( advanced )
|
Code |
Course |
Duration |
Outline |
| ICAU1130B |
Microsoft Excel Essentials |
1 day |
|
| ICAU3126A |
Microsoft Excel
Expert |
1 day |
|
| ICAU3126A |
Microsoft Excel Formula Workshop |
1 day |
|
 |
Course
Enrolment Form |
|
|
| CHECK
COURSE DATE AVAILABILITY |

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)

• Essentials : One full day (9am - 4.00pm)
• Expert : One full day (9am - 4.00pm)
• Formula Workshop : One full day (9am - 4.00pm)

• Our
excel introductory course is based on Certificate
I in Information Technology, specifically ICAU1130B - Operate
a Spreadsheet Application
• All of our
courses are structured to Microsoft
Office Specialist (MOS) content
• 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 Essentials Course
What is assumed of the Students
• Students have fundamental keyboard skills.
• Students have fundamental mouse skills.
• Students have a fundamental knowledge of Windows.
Who Should Attend?
Users who want to improve or sharpen their exisiting basic or intermediate
skills in Excel. Much emphasis is also placed on the quickest and
easiest ways to accomplish activities in Excel.
Please note that this course is not intended for brand
new users to a computer. Attendees should already have fundamental
keyboard and mouse skills.
Venue and Duration
Venue:
Onsite (your premises) or Inhouse (our premises)
Duration:
1 Full Day (9am - 4pm)
Part One: Worksheet and Workbook Basics
• The Excel Layout
• Cells & Data
• Highlight, Insert & Delete cells, rows, columns
• Cut, copy & paste
• Entering & Editing Cell Data
• Using the Autofiller
• Creating Date and Number patterns
• Create custom fill patterns
• Entering and modifying formulas
• SUM / AVERAGE / MAX / MIN / COUNT / COUNTA functions
• Percentage formulae
• Absolute and Relative References
• Checking Spelling
• Using Find & Replace
• Filtering lists
• Modifying Toolbars (Excel 2003)
• Modifying the Quick Access Toolbar (Excel 2007)
Part Two: Formatting and Printing
• Formatting Worksheets (Row, Cell & Column formats)
• Number formats
• Aligning, Rotating, Merging, Indents, Text Wrapping
• Applying borders & colours
• Adjusting column width & row heights
• Applying AutoFormats & Styles
• Previewing, Printing & Altering Page Setups
• Setting page options
• Setting margins in the page setup dialog box
• Setting headers & footers
• Changing sheet settings
• Page Break Preview
• Inserting and removing page breaks
• Changing print settings
Part Three: Enhance and Revise Workbooks
• Modifying Workbooks
• Inserting and Deleting worksheets
• Modifying worksheet names
• Moving & copying worksheets
• More Complex Formulas
• Linking Worksheets and Workbooks
• Using 3D Reference functions (for Summary Sheets)
• Using the IF function
Part Four: Charts and Graphics
• Pie / Column / Bar / Line charts
• Scaling & printing chart objects
• Modifying charts
• Editing & formatting charts
• Working with Graphics
Part Five: Collaboration
• Web Publishing in Excel
• Creating and Editing hyperlinks
• Using Comment
home

Advanced Excel Course
What is assumed of the Students
• Students have very good keyboard skills.
• Students have very good mouse skills.
• Students have considerable experience in Excel.
• Students have a solid knowledge of Windows.
Who Should Attend?
This course is designed for people who need to come to grips with
more advanced features of Excel. Anyone who reports, edits and maintains
larger spreadhseets 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 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: Foreign Data & Managing Workbooks
• Importing and Exporting Data
• Importing workbooks created in other versions of Excel
• Importing data from other applications
• Using the text import wizard
• Importing a Web Page
• Exporting Data
• Managing Workbooks
• Applying a template
• Editing a template
• Creating a template
• Consolidating Data
Part Two: Formula Auditing
• Auditing Formulas
• Locating and Resolving Errors
• Finding Precedents & Dependants
• Watch Window
Part Three: Making Excel even Easier
• Goto > Special
• Naming Ranges
• Creating names in bulk
• Using names in formulas
• Lookup & Reference Functions
• Using VLOOKUP
• Using HOOKUP
Part Four: Subtotals, Lists and Ranges
• Creating Subtotals
• Defining & Applying Advanced Filters
• Using Grouping & Outlining
• Data Validation
Part Five: Automating and Customising Excel
• Advanced Formatting
• Creating custom number formats
• Codes for dates and times
• Use Conditional Formatting
• Cell Value conditions
• Using formulas as conditions
• Creating Macros
• Recording a macro
• Absolute and Relative cell references
• Editing macro code
• Customizing Toolbars and Menus
• Creating a custom toolbar (Excel 2003)
• Adding macros to toolbars and menus (Excel 2003)
• Creating a custom Quick Access Toolbar (Excel 2007 / 2010)
• Adding macros to the Quick Access Toolbar ( 2007 / 2010)
Part Six: Analysing Data
• PivotTables & PivotCharts
• Creating / Modifying PivotTables
• Grouping and Filtering PivotTable items
• Summaries & Formats for fields
• Creating PivotCharts
• Using Business Analysis Tools
• Creating data tables
• Using goal seek
• Using solver
• Scenarios
Part Seven: Sharing Excel Data
• Passwords, Protections and Properties
• Protecting a workbook
• Protecting worksheets and ranges
• Allowing users to edit ranges
• Collaborating with Others
• Creating a shared workbook
• Highlight, accept & reject changes
• Merging workbooks
home
|