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 premesis (office / factory) or...

• Alternatively, our Excel Courses can be delivered at Unit 13 / 795 Beaufort St, Mt Lawley, Perth, WA.

• Nationally recognised microsoft excel training

• 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 to deliver our excel course.

• A 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
ICAITU130a	Microsoft Excel Essentials	1 day	download view
EX-ADV	Microsoft Excel Expert	1 day	download view
EX-FRM	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 - 3.30pm)

• Our excel introductory course is based on Certificate I in Information Technology, specifically ICAITU130a - 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 11 years training experience)

• Our trainers are known for their friendly and helpful 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 10 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 basic keyboard skills.
• Students have basic mouse skills.
• Students have a basic knowledge of Windows.

Note that this course is well suited to users who would like to improve or sharpen their exisiting basic or intermediate skills in microsoft excel. If you would like to fully get your head around the standard and intermediate options in microsoft excel, this course is for you. Much emphasis is also placed on the quickest and easiest ways to accomplish activities in microsoft excel.

Session 1: Worksheet and Workbook Basics

1.1 The Excel Layout

• Default Excel toolbars

1.2 Cells and Data
1.3 Worksheet Layouts

• Selecting Cells, Rows, Columns and Ranges
• Deleting Cell Contents
• Deleting a cell or a range of cells
• Inserting and Deleting Rows and Columns
• Cut, Copy and Paste

1.4 Entering and Editing Cell Data

• Editing Cell Data
• Entering Formulas
• Creating Totals Formulas

1.5 Checking Spelling in a Worksheet
1.6 Using Find and Replace

• Finding and Replacing Text
• Finding and Replacing Formatting

1.7 Filtering lists

• AutoFilter
• Custom Filters

Session 2: Managing Workbooks

2.1 File Management within Dialog Boxes

• Creating a New Folder
• Opening a Workbook as Read Only or as a Copy
• Deleting, Moving and Copying Workbooks

2.2 Creating a Workbook from a Template
2.3 Modifying Toolbars
2.4 Saving Workbooks using Different Names & Formats

• Saving Workbooks with Different Filenames
• Saving a Workbooks/sheets in previous Excel formats
• Saving a Workbook in a Non-Excel File Format

Session 3: Formatting and Printing Worksheets

3.1 Formatting Worksheets (Row, Cell & Column formats)

• Number Formats

3.2 Formatting Text

• Aligning Text
• Rotating, Merging, Shrinking to Fit and Text Wrapping
• Applying Borders and Colour

3.3 Adjusting Worksheet Layouts

• Adjusting Column Width and Row Heights

3.4 Applying AutoFormats and Styles

• AutoFormats
• Styles

3.5 Previewing, Printing and Altering Page Setups

• Setting Page Options
• Setting Margins in the Page Setup Dialog Box
• Setting Headers and Footers
• Changing Sheet Settings

3.6 Setting Print Options

• Using Page Break Preview
• Inserting Manual Page Breaks
• Change the Print Settings

Session 4: Enhancing & Revising Workbooks

4.1 Modifying Workbooks

• Inserting Worksheets
• Deleting Worksheets
• Modifying Worksheet Names
• Moving and Copying Worksheets

4.2 Creating Complex Formulas

• Using 3D References
• Creating and Revising Formulas

4.3 Constructing Formulas using Functions

• Using Statistical Functions
• Using Date and Time Functions
• Using Financial Functions
• Using Logical Functions

Session 5: Charts and Graphics

5.1 Charts

• Pie Charts
• Moving, Sizing and Printing Chart Objects
• Printing Charts as Objects or Worksheets
• Creating Series Charts
• Modifying Charts
• Editing and Formatting Charts
• Resizing and Deleting Objects in a Chart
• Formatting the Chart with the Chart Toolbar

5.2 Working with Graphics

• Inserting and Positioning Pictures

Session 6: Workgroup Collaboration

6.1 Web Publishing in Excel

• Creating Hyperlinks
• Inserting a Hyperlink

6.2 Using Comments

• View and Edit Comments

Advanced Excel Course

What is assumed of the students?

• Students have reasonable keyboard skills.
• Students have reasonable mouse skills.
• Students have reasonable experience in Excel.
• Students have a basic knowledge of Windows.

Note that this course is well suited to users who already have intermediate skills and experience in microsoft excel and would like to take their knowledge and ability in excel to the next level. If you would like to automate many of your daily repetitive tasks in microsoft excel, you would also benefit from this course.

Session 1: Foreign Data & Managing Workbooks

1.1 Importing and Exporting Data

• Importing data created in other versions of Excel
• Importing data from other applications
• Using the text import wizard

1.2 Importing a Web Page
1.3 Exporting Data
1.4 Publishing Worksheets and Workbooks

• Publish worksheets and workbooks on the web

1.5 Using the Spreadsheet Component

• Publishing a page with the chart component

1.6 Managing Workbooks

• Applying a template
• Editing a template
• Creating a template

1.7 Working with Workspaces

• AutoFilter
• Custom Filters

1.8 Consolidating Data

• Use data consolidation

Session 2: Managing Workbooks

2.1 Auditing Formulas

• Auditing formulas

2.2 Locating and Resolving Errors

• Using the formula checker to resolve errors

2.3 Finding Precedents

Session 3: Making Excel even Easier

3.1 Naming Ranges

• Creating names in bulk
• Using names in formulas

3.2 Lookup & Reference Functions

• Using VLOOKUP
• Using LOOKUP
• Using INDEX and MATCH

Session 4: Automating and Customizing Excel

4.1 Advanced Number Formatting

• Creating custom formats
• Spacing codes
• Codes for dates and times
• Codes for text

4.2 Use Conditional Formatting

• Using formulas as conditions

4.3 Creating Macros in Excel

• Recording a macro
• Assigning shortcut keys
• Absolute and Relative cell references
• Editing macros
• Running macros
• Opening files that contain macros

4.4 Customizing Toolbars and Menus

• Adding commands to toolbars and menus
• Creating a custom toolbar
• Adding macros to toolbars and menus

Session 5: Subtotals, Lists & Ranges

5.1 Creating Subtotals
5.2 Defining & Applying Filters

• Define & Apply advanced filters

5.3 Using Grouping & Outlining

• Add group & criteria to ranges
• Automatically outlining a worksheet
• Manually outlining a worksheet

5.4 Using Data Validation

• Adding & creating validation rules

5.5 External Data & Creating Queries

• Retrieving external data
• Creating database queries
• Creating web queries
• Creating XML queries

Session 6: Analysing Data

6.1 PivotTables & PivotCharts

• Creating PivotTables with the wizard
• Adding items to the PivotTable
• Modifying the table layout
• Filtering PivotTable items
• Grouping PivotTable items
• Summary & format for data fields
• Applying an AutoFormat
• Creating PivotCharts

6.2 Using Business Analysis Tools

• Using the what-if-tools
• Creating data tables

6.3 Formatting & Modelling

• Using goal seek
• Using solver
• Working with scenarios

Session 7: Sharing Excel Data

7.1 Passwords, Protections and Properties

• Setting Workbook passwords
• Protecting a workbook
• Protecting worksheets and ranges
• Unlocking ranges
• Allowing users to edit ranges
• Setting workbook properties

7.2 Collaborating with Others

• Creating a shared workbook
• Tracking changes
• Updating changes
• Conflicting changes between users
• Include in personal view
• Highlight, accept & reject changes
• Merging workbooks

home

Onsite training at our clients premises. We come to you !! Alternative venues available.

We provide laptops for the duration of the course. No strain on your IT resources.

All courses come with a quality manual, workbook & exercise cdrom, unlike other providers.

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.