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	download view
ICAU3126A	Microsoft Excel Expert	1 day	download view
ICAU3126A	Microsoft Excel Formula Workshop	1 day	download view
	Course Enrolment Form		download
CHECK COURSE DATE AVAILABILITY

• 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

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.