Intermediate Excel Course Perth

Truly the ULTIMATE Intermediate Excel Course in Perth. World Class Intermediate Excel Training that teaches students how to drive and manage spreadsheets with ease.

Intermediate Excel Course Summary

Our Excel Essentials (Intermediate Excel Course) unlocks important skills used in modern business. Students will learn to build more complex formulas as well as control conditional formats. Finally, Tables and Charts are dealt with in detail. Click here to get an full overview of our Intermediate Excel Course.

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

Intermediate Excel Course Details

Learn more about our Intermediate Excel Training and find links to booking options.

Outline: Intermediate Excel Course

You can learn more about our Excel Essentials (Intermediate Excel Course), by drilling down on the topics below.

Formula Design

Formula Order of Operations
SUM / AVERAGE / MAX / MIN / COUNT(A)
Calculate Percentages
Absolute and Relative Referencing
Advanced Paste Options
IF function and Nesting

Enhance & Revise Workbooks

Named Ranges
Cell Styles
Move, Copy and Group worksheets
Calculate and link across sheets & books
3D Formulae
TODAY, NOW, EDATE
Conditional Formats
Data Validation
Subtotals
Format as Table
Flash Fill

Charts and Sparklines

Pie, Column, Bar & Line charts
Scale & Print Charts
Edit & Format Charts
Create & Edit Sparklines

Overview

The knowledge gained from this course includes design, formula nesting and cross workbook calculations. What’s more, Conditional formats and Table concepts are also covered. Last but not least, this course uncovers the secrets to building Charts and Graphs.

Audience & Duration

This one day course (9am to 4pm WST) is an Intermediate Excel Course, that will suit people who are comfortable with Excel, but who want to improve their mid-level or basic Excel skills.

Course Outcome

Course attendees learn to structure sheets, build nested IF formulas and apply Conditional Formatting. Furthermore, students will learn about Excel Tables. Additionally, students will gain skills to link data and perform calculations across sheets and workbooks. By the end of this course, students should also have the skills to manage charts.

Course Attendance

There are a number of ways to attend our Excel Intermediate Course. Most commonly, Public, Virtual and Workplace Courses, as well as online Courses are the preferred delivery methods for this course.

Public and Virtual Excel Courses

We often run Intermediate Excel Courses at our venue in Perth, which can also be attended virtually (via ZOOM or Teams), from anywhere in Australia.

Workplace Intermediate Excel Training

We also offer Workplace Training for companies. This means that we can run courses at your venue, or you can come to ours. With workplace courses, we supply laptops (with no rental fees), and can also cater for virtual students at the same time.

Custom Excel Training

In addition to our Intermediate Excel Course, we also offer many other Training Courses for Excel, as well as custom Excel Training.

Online Intermediate Excel Courses

In addition to our Intermediate Excel Training in Perth, we also offer the option to attend courses 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 posted dates for our Intermediate Excel Training in Perth.

Public & Virtual Dates	Link to Book
19 Jan 2022 (Wed)	BOOK NOW
04 Feb 2022 (Fri)	BOOK NOW
15 Feb 2022 (Tue)	BOOK NOW
02 Mar 2022 (Wed)	BOOK NOW
23 Mar 2022 (Wed)	BOOK NOW

Virtual & Public Pricing

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