Training Courses in Perth for: Excel | Word | SharePoint | Project | Outlook | Time Management | Access | PowerPoint | Visio | Publisher | PC Basics | Acrobat
Mobile MOUSe Mobile MOUSe Training Mobile MOUSe

Welcome to Mobile MOUSe, Perth WA

Excel Essentials (Excel Intermediate Training Perth)

Course Calendar Calendar | Course Outline PDF Outline | Enrol Enrol | Course Enquiry Enquire | Course Pricing Pricing | Skills Assessment Assessment

Excel LogoExcel Intermediate Training Course Summary

Mobile MOUSe is the preferred INSTRUCTOR LED Excel intermediate course provider for Australia's largest companies.

COURSE TARGET SKILL SET: INTERMEDIATE
TRAINING COURSE DURATION: 1 Day (9am - 4pm)
TRAINING VENUE: Our Premises (In-house Perth) or Your Premises (Onsite)

Minimum Attendance Requirements

• This training course is not intended for new users to computing.
• Attendees must have keyboard and mouse skills.

Training Course Overview

This Excel Intermediate Training Course will teach attendees how to correctly structure spreadsheets, build functions and formulas as well as easily format spreadsheets using handy tips and tricks (including shortcuts). Attendees will also learn how to link data (and perform calculations) across worksheets and workbooks. Finally in this Excel Intermediate Course, attendees will also learn how to correctly (and easily) structure and manage various types of charts to effectively present your Excel spreadsheet data in a graphical format.

Intended Audience

Excel Users who want to improve or sharpen their existing basic or intermediate skills in Excel. Much emphasis is placed on the quickest and easiest ways to accomplish activities in Microsoft Excel.

Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn See How We Roll


Excel Essentials (Intermediate) Training Outline

PART ONE - FORMULA DESIGN

• Advanced Paste Options
• Entering formulas
• Order of Operations (Enforcing Precedence)
• SUM / AVERAGE / MAX / MIN / COUNT(A) functions
• Percentage formulae
• Absolute and Relative Referencing
• Using the IF function
• Good spreadsheet design

PART TWO - ENHANCING AND REVISING WORKBOOKS

• Naming Ranges
• Cell Styles
• Modifying the Quick Access Toolbar
• Modifying Workbooks
• Moving & copying worksheets
• Grouping worksheets
• More Complex Formulas
• Calculations across sheets and workbooks
• Linking sheets and workbooks
• Using 3D Reference functions (for summary sheets)
• TODAY(), NOW(), EDATE()
• Nesting within an IF function
• Conditional Formatting
• Data Validation
• Subtotals
• Format as Table

PART THREE - CHARTS AND SPARKLINES

• Charts
• Pie / Column / Bar / Line charts
• Scaling & printing chart objects
• Modifying charts
• Editing & formatting charts
• Sparklines (Excel 2010 / 2013 / 2016 / 365 only)

Outline (PDF) Enrol Now Onsite Quote

ADDITIONAL SELF STUDY (MOS CERTIFICATION)

• Worksheet Navigation*
• Printing a worksheet or workbook*
• Apply and modify cell formats
• Merge or split cells*
• Create row and column titles*
• Hide and unhide rows and columns*
• Manipulate Page Setup options for worksheets*
• Manipulate print options for worksheets*
• Create and format worksheets*
• Manipulate workbook views*
• Split and Freeze Panes*
• Create and manage Comments*
• Apply and manipulate illustrations*
• Create and modify images*
• Share spreadsheets by using Backstage* ​

An * ​ indicates that this is covered in our Excel Basics Course - but self study content is provided in our student workbook / prep-guide.

Related Excel Courses in Perth

If you are not sure if this is the right Excel course for you, why not take our zero obligation online excel training course skills questionnaire? Alternatively investigate one of our other Excel Training Course options below...

New Users (Basic Excel Course)
Expert (Advanced Excel Course)
Formula Workshop (Excel Formulas Course - Advanced)
VBA Essentials (Excel VBA Macros Course - Advanced)
Dashboards - Day 1 (Excel Dashboards - Advanced)
Dashboards - Day 2 (Excel Dashboards - Advanced)
Online Microsoft Excel Training Courses

General Notes

Our Inhouse Excel Intermediate Training in Perth is conducted at Unit 1 / 41 Action Rd, Malaga, Perth, WA or... alternatively, our Intermediate Excel Course can be delivered onsite at your premises (office / factory / regional / minesite).

With our onsite excel training options, we come to you with our laptop computers and projection equipment to deliver the Excel course of your choice. We can also deliver custom Excel training courses (i.e. you choose specific aspect(s) of our Excel courses that you would like delivered). Our Microsoft Excel training is structured to Microsoft Office Certification, in addition, every Excel course comes with free online support.

What Students Say

Standard Course Inclusions

Onsite Training (Your Venue)
For all onsite Excel Training we supply the following (all at NO EXTRA COST):

• The Laptops (at no extra cost)
• Face to Face Instructor-Led Training
• The Projection Equipment
• All electric cables and Power boards
• Student Manuals
• Free Downloadable Exercise Files
• Post Course Student Support
• Certificate of Attendance (On Request)
• Dynamic, Qualified Experienced trainers
• An Amazing Training Experience :-)

InHouse Training (Our Venue)
For all Excel Courses our venue we supply the following at no extra cost.

• State of the Art Training Facilities
• Free Parking
• Free Refreshments
• Student Manuals
• Free Downloadable Exercise Files
• Post Course Student Support
• Certificate of Attendance
• Dynamic, Qualified Experienced trainers
• An Amazing Training Experience :-)

Our Social Media Links

Mobile MOUSe Social Media

Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn

Microsoft Certification

Mobile MOUSe is an authorised testing center for the range of internationally recognised Microsoft Office Certifications. Click the graphic below for more information about Microsoft Office Certification.

MOS Testing Centre

Training Facts

There are many myths about training - reasons suggested for postponing skill development. Whether it's a process that is not being followed, technology under utilised – every organisation benefits from training...

More info...

© 2017 - Mobile MOUSe - Microsoft Office Training and Consulting Specialists (Perth - Western Australia) | (08) 9404 7041 | www.mobilemouse.com.au
 
 
Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn