Advanced Excel Course Perth
The ULTIMATE Advanced Excel Course in Perth. Discover our World Class Advanced Excel Training that teaches students how to implement advanced spreadsheet concepts with ease.
Excel Expert (Advanced Excel Course) Summary
This Advanced Excel Training covers a number of topics for advanced Excel users, such as Macros and Pivots, as well as how to solve problems with formulas. Additionally, students will learn about lookup formulas and how to manage workbook security.
COURSE DETAILS
Click to view details about this Training Course
COURSE DATES
View our available Public & Virtual Course Training Dates
COURSE PRICING
Check out our amazing Public & Virtual Course pricing
REMOTE TRAINING
You can also attend Virtually (Remotely). Learn how it works
Excel Advanced Course Perth Details
Learn more about this Course and find links to booking options.
Outline: Advanced Excel Course
You can learn more about this Advanced Excel Training Course, by drilling down on the topics below.
Manage Workbooks & Data
- Importing Data
- Export Data
- Manage Workbooks
- Create and Edit Templates
- Consolidate Data
Making Excel Easier
- Audit Formulas
- Locate and Resolve Errors
- Precedents & Dependants
- Watch Window
- Goto > Special
- Named Ranges
- Names in formulas
- VLOOKUP & HLOOKUP
- SUMIF, AVERAGEIF, COUNTIF
- Group & Outline
Automate and Customise
- Custom Number & Date formats
- Conditional Formats (with Formulas)
- Record Macros
- Global and Local Macros
- Edit macros
- Customise Ribbons and Toolbars
Analyse and Share
- PivotTables & PivotCharts
- Business Analysis Tools
- Data Tables
- Goal Seek and Solver
- Scenarios
- Protect Workbooks
- Protect Worksheets
- Allow Users to Edit Ranges
- Collaborate with Others
- Shared Workbooks
- Highlight, Accept & Reject Changes
- Merge Workbooks
Advanced Excel Course Overview
This course deals with advanced Microsoft Excel concepts, and as a result, students will learn how to use Excel’s automation and summary features.
Knowledge gained not only includes best design practices, but also grants students the ability to automate tasks and perform data analysis in MS Excel.
Furthermore, course attendees will develop powerful summaries, reports and perform data analysis. Finally, students will also gain skills to setup, manage, maintain as well as secure workbooks for use by other users.
Audience & Duration
This one day course (9am to 4pm WST) is a Advanced Excel Course, which means that it is aimed at Intermediate and Advanced Excel users who already have solid Excel skills.
Course Outcome
Students will learn about best practices for Microsoft Excel data. Consequently, topics like Macros and Pivot Tables and Charts are covered. Equally important, students learn how to perform data analysis and create powerful summaries. This is all in addition to gaining skills for sharing and securing data.
Course Attendance
We offer a number of different ways to attend our Perth based Training, such as Public or Virtual Courses, as well as Workplace Training options. This is all in addition to the fact that you can also attend our courses online.
Public and Virtual Advanced Excel Courses
We often run Advanced Excel Training at our venue in Perth, which can also be attended virtually (via ZOOM or Teams), from anywhere in Australia.
Workplace Excel Training
We also offer Workplace Training for companies. This means that we can run our Advanced Excel Training course at your venue, or you can come to ours. With workplace courses, we supply laptops (with no rental fees), while still catering for virtual students.
Custom Training
In addition to this course, we also offer many other Excel Courses, notwithstanding the fact that we also offer custom Excel Training.
Online Courses
In addition to our Advanced Excel Training in Perth, we also offer the option to sit your course via our online training portal.
Public & Virtual Dates
Here are the currently advertised dates for our Advanced Excel Training in Perth.
Virtual & Public Pricing
Our Courses are truly affordable. Take a look at our pricing table below.
TRAINING UPDATES
Course Specials
We offer some amazing course discounts and specials. Join our mailing list in order to become eligible.
We now also accept Afterpay. You can select this option when completing your course booking online.
Microsoft Excel Consulting Perth, Australia
Not only does Mobile MOUSe offer the best Advanced Excel Course in Perth. But we also offer tailored Excel support and assistance for any type of spreadsheet.
Our Perth based Microsoft Excel Support is world class, due to our years of experience and expertise.
Get Excel Support by contacting us today !!!
Microsoft Excel Training Courses
In addition to our Advanced Excel Training, here are our related Microsoft Excel Training Courses for Australia and Perth.
BASIC EXCEL TRAINING COURSE
Learn more about our Excel New Users (Basic Excel Course). Virtual Classes are also available.
INTERMEDIATE EXCEL TRAINING COURSE
More about our Intermediate Excel Training Course. Virtual Classes are also available.
ADVANCED EXCEL TRAINING COURSE
Discover our Excel Expert (Advanced Excel Course). Virtual Classes are also available.
EXCEL FORMULA WORKSHOP COURSE
Learn about our Excel Formulas Course (Advanced). Virtual Classes are also available.
EXCEL DASHBOARDS COURSE
Discover our Excel Dashboards Course (Advanced). Virtual Classes are also available.
VBA (MACROS) EXCEL COURSE
Click to learn about our Excel VBA Course (Advanced). Virtual Classes are also available.
EXCEL POWER QUERY COURSE
Info on our Excel Power Query Course (Advanced). Virtual Classes are also available.
EXCEL POWER PIVOTS COURSE
More on our Excel Power Pivot Training Course (Advanced). Virtual Classes are also available.
In Business Since
Students Trained
Avg Student Score (out of 10)
Pricing From
Advanced Excel Training Inclusions
All Mobile MOUSe Excel Courses have the following course inclusions…
IN-HOUSE (Our Venue)
Excel Courses in Perth (at Our Venue) normally include…
- State of the Art Venue
- Face to Face Courses
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Refreshments and Snacks (Free)
- Free Parking
- Dynamic Trainers
- Really Affordable Training
- An Amazing Training Day 🙂
ONSITE (Your Venue)
Our Workplace Training normally includes these features…
- Laptops (no rental fees)
- Face to Face Training
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Projection Equipment
- Cables & Power Boards
- Dynamic Trainers
- Very Affordable Training
- An Amazing Training Day 🙂
Virtual Excel Courses
In short, Virtual Training (via ZOOM or TEAMS) features include…
- Face to Face Training
- Interactive Virtual Classroom
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Fewer Travel Costs
- No Public Health Worries
- Dynamic Trainers
- Really Affordable Training
- An Amazing Training Day 🙂
Courses Online (Self Paced)
Our Online Courses include the following features…
- Online Portal
- Same Trainers
- Manual (PDF)
- Certificate (PDF)
- Exercise Files
- Free Post Course Help
- Fewer Travel Costs
- No Public Health Worries
- Dynamic Trainers
- Really Affordable Training
- Learn at Your Own Pace