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.

Book a Public Course

Book Corporate Course

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



WORKPLACE TRAINING

Learn about our Corporate Workplace Training Options

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.

Book a Public Course

Book Corporate Course

Request Quote / Date

Enquire Now

Send Us a Text

Public & Virtual Dates

Here are the currently advertised dates for our Advanced Excel Training in Perth.

Public & Virtual Dates	Link to Book
20 Jan 2022 (Thu)	BOOK NOW
17 Feb 2022 (Thu)	BOOK NOW
24 Mar 2022 (Thu)	BOOK NOW

Virtual & Public Pricing

Our Courses are truly affordable. Take a look at our pricing table below.

Public (One Day)	Price per Head
Enrol 1	$265
Enrol 2	$255
Enrol 3	$245
Enrol 4	$235
Enrol 5	$225
Concession Card	$175
5 Course Vouchers	$1,175
10 Course Vouchers	$2,250
20 Course Vouchers	$4,000
Corporate / Workplace	GET QUOTE
Custom Training	GET QUOTE
One on One	GET QUOTE

Excel Training Courses and Support Mobile MOUSe Perth WA

Course Outline (PDF)

Excel Skill Assessment

Related Excel Courses

Excel Consulting

Reuben, Downhole Surveys

\"Joes presentation is brilliant, he is engaging, informative and extremely knowledgeable. Top bloke. I will recommend him to my company. The facilities at Mobile MOUSe are excellent.\"

Silvana, Prime Laundry

\"The course was absolutely brilliant, Graeme is an excellent instructor and I have taken a lot from this course. Thank you, Thank you, Thank you :)\"

Natasha, Woodside

\"Thanks, it was great! Everything was perfectly timed, very enthusiastic trainer and a lot of great takeaways from today. I look forward to attending the next one in a few months.\"

Lisa, Georgiou Group

\"Great trainer!! Russell presented the course really well....very funny and helpful! The facilities were great too. Nothing bad to say at all....would totally recommend Mobile MOUSe to others!\"

Andreas, Sinostruct

\"Easily the best course I have been to. Graeme you do a wonderful job at keeping the course upbeat and interactive. Thank you, learnt so much\"

Roni, Ranger Drilling

\"Very good teaching technique, class control and time management. Very well presented. Great facilities, teaching aids and take home information for future reference. Money well spent.\"

Emma, Brikmakers

\"I thought this course was fantastic. I learned a lot, which will be valuable to my experience and skill set and relatable to my current role. Graeme is an Exceptional trainer, very good at his job.\"

Kristy, BHP Billiton Iron Ore

\"This is the most fun we have had on a course in ages, and learnt so MUCH! Russ was awesome, Thank you!\"

Lisa, Eni Australia Ltd

\"Everything was explained brilliantly. Small class which was great as was more comfortable asking questions. Trainer was very approachable and very knowledgeable.\"

Nicole, Wirtgen Australia

\"Graeme was very interactive with the class and did a great job at keeping everyone involved. The Facilities are also very good. Thank you!\"

Garry, Office of Transport Security

\"I have an extensive training background. The content, pace of delivery and quality of delivery was exceptional. Preparation was obvious and contributed to the course quality. Thank you so much\"

Andrea, HFM Asset Management

\"I attended the courses today with Russell and yesterday with Graeme, they are both amazing! I cant stress enough how great their customer service is, they are very patient and passionate about what they do. Well done guys!\"

Stacey, City of Nedlands

\"The training was awesome and the instructor very helpful! This is my second or third training course I have done with Mobile MOUSe and I would come back again!\"

TRAINING UPDATES

COURSE SPECIALS

We offer some amazing course discounts and specials. Join our mailing list in order to become eligible.

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 !!!

EXCEL CONSULTING