Calendar | Enrol
Mobile MOUSe is the preferred INSTRUCTOR
Excel advanced course
provider for Australia's
THIS COURSE IS TAILORED TOWARDS STUDENTS OBTAINING THE MICROSOFT
OFFICE EXPERT OR MASTER CERTIFICATION (MOS).
Excel Course is designed to help attendees develop (or enhance)
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.
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 spreadsheets is an ideal
candidate for this training.
DURATION: 1 full
day (9am to 4pm)
VENUE: Onsite (your
premises) or Inhouse (our premises)
MINIMUM ATTENDANCE REQUIREMENTS
• This course
is not intended for new users to computing or spreadsheets.
• Attendees have Intermediate
• Attendees must have keyboard and mouse skills.
PART ONE - FOREIGN DATA & MANAGING
• 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
• SUMIF, AVERAGEIF, COUNTIF
• Advanced Filters
• Grouping & Outlining
PART THREE - AUTOMATING & CUSTOMISING
• Advanced Formatting
• Creating custom number & date formats
• Advanced Conditional Formatting (with Formulas)
• Global and Local Macros
• Absolute and Relative cell references
• Editing macro code
• Customizing the Ribbon and Quick Access Toolbar
PART FOUR - ANALYSING AND SHARING DATA
• PivotTables & PivotCharts
• Using Business Analysis Tools
• Creating data tables
• Using goal seek
• Using solver
• 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 EXPERT CERTIFICATION)
• Manipulate formula options*
• Perform data summary tasks*
• Apply functions in formulas*
• Apply advanced chart features*
• Insert and manipulate form controls*
* Covered in our Excel
Essentials Training or on our Formula
Workshop Course - but self study content is provided
in our student MOS prep-book.
IS THIS THE RIGHT EXCEL
COURSE FOR YOU?
Not sure which excel
course is the right one for you? Take our free, zero obligation
New Users Course (Basic)
Essentials Course (Intermediate)
Formula Workshop Course (Advanced)
Dashboards (Day 1) Course (Advanced)
Dashboards (Day 2) Course (Advanced)
VBA (Visual Basic for Applications) Course (Advanced)
[back to the top]
advanced training in Perth
is conducted at your premises (office / factory) or... alternatively,
Excel Courses can be delivered at Unit 1 / 41 Action Rd,
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 deliver custom
Excel training courses (i.e. you choose specific aspect(s)
of our Excel
courses that you would like delivered).
Excel training is structured to Microsoft
Office Certification, in addition, every Excel
course comes with free online support.
Our pricing structure is unique. The more people you enrol in an excel
course, the cheaper the excel
course becomes (which is great for companies and friends).
For all of the reasons above (and more), Australias'
biggest companies acknowledge the features and benefits of training
MOUSe. Our professional approach and intricate knowledge
of the features and abilities of Excel
have saved our clients millions of dollars after they implemented the
features we have made them proficient in. More
Our trainers are known for their knowledge and
helpful, friendly approach. All of our excel
courses are taught by experienced, certified and qualified
instructors, who individually have a minimum of 15 years training
• The best Excel
training in Perth
• A detailed high quality manual -> download
• Free downloadable practice files
• Online support
• A certificate of attendance (on request)
• Zero Hassle, FREE PARKING when attending at our premises
Click the image below to view our current perth
training schedule and potentially book your classroom seat(s).
» 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...
Mobile MOUSe is an authorised testing center for
the range of internationally recognised Microsoft Office Certifications.
» VENUE & ROOM HIRE
Need a meeting or training room? Options range
from a day to a years lease.