|
 Calendar |  Outline |  Enrol |  Enquire |  Pricing |  Assessment
UPCOMING PUBLIC DATES:
Mon 17 Dec, Fri 01 Feb, Mon 18 Feb
PUBLIC (ENROL 1) PRICE: $
265
Mobile MOUSe is the preferred INSTRUCTOR LED Excel advanced course provider for Australia's largest companies.
COURSE TARGET SKILL SET: ADVANCED
TRAINING COURSE DURATION: 1 Day (9am - 4pm)
TRAINING VENUE: Our Premises (In-house Perth) or Your Premises (Onsite)
Minimum Attendance Requirements
• Attendees must already have intermediate or advanced Excel skills.
• Attendees must have keyboard and mouse skills.
This Advanced Excel Course is designed to help attendees develop (or enhance) advanced skills in Microsoft Excel. Attendees will learn how to easily manipulate spreadsheets to easily perform advanced activities in Excel. In addition to learning how to automate every day Excel tasks and processes, attendees will learn how to develop powerful summaries and reports in Excel. Attendees will also learn how to setup, manage, maintain and secure workbooks that are to be used by other users.
Intended Audience
This Advanced Excel Course is designed for people who need to come to grips with more advanced features of Excel. Anyone who reports, edits and maintains larger spreadsheets is an ideal candidate for this training.
|
See How We Roll
|
|
PART ONE - FOREIGN DATA & MANAGING WORKBOOKS
• Importing and Exporting Data
• 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 - MAKING EXCEL EVEN EASIER
• Auditing Formulas
• Locating and Resolving Errors
• Precedents & Dependants
• Watch Window
• Goto > Special
• Naming Ranges
• Creating names in bulk
• Using names in formulas
• VLOOKUP
• HLOOKUP
• SUMIF, AVERAGEIF, COUNTIF
• Advanced Filters
• Grouping & Outlining
PART THREE - AUTOMATING & CUSTOMISING EXCEL
• Advanced Formatting
• Creating custom number & date formats
• Advanced Conditional Formatting (with Formulas)
• Macros
• Global and Local Macros
• Absolute and Relative cell references
• Editing macro code
• Customizing the Ribbon and Quick Access Toolbar |
Outline (PDF) Enrol Now Onsite Quote
PART FOUR - ANALYSING AND SHARING DATA
• PivotTables & PivotCharts
• Using Business Analysis Tools
• Creating data tables
• Using goal seek
• Using solver
• Scenarios
• 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
ADDITIONAL SELF STUDY (MOS CERTIFICATION)
• Manipulate formula options*
• Perform data summary tasks*
• Apply functions in formulas*
• Apply advanced chart features*
• Insert and manipulate form controls*
A * indicates that this is covered in our Excel Essentials Training or on our Formula Workshop Course - but self study content is provided in our student guide / prep-book.
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)
Essentials (Intermediate 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 Advanced Training in Perth is conducted at Unit 1 / 41 Action Rd, Malaga, Perth, WA or... alternatively, our Advanced 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
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.
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...
|
