Excel KPI Dashboards Course Perth

The ULTIMATE Excel KPI Dashboards Course in Perth. Discover our World Class Excel KPI Training that teaches students how to build powerful Excel (KPI) Dashboards.

Excel KPI Dashboard Course Summary

This Excel Dashboards (Excel KPI Dashboards) Course covers a number of important topics for advanced Excel users, such as creating and managing powerful Excel Dashboards and Summaries. Furthermore, students will also learn how to Structure and Automate Excel KPI Dashboards.

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 KPI Dashboards Course Details

Learn more about this Course and find links to booking options.

Outline: Excel KPI Dashboards Course

You can learn more about this Excel KPI Dashboards Course, by drilling down on the topics below.

Part One (Day 1)

PART 1 – STRUCTURE DATA

Understand KPI data
Understand data structures
Format as Table

PART 2 – USE OF SHAPES AND OBJECTS

Dashboard menus with Shapes & Objects
Hyperlinks
Hiding Tabs

PART 3 – USEFUL DASHBOARD FORMULAS

Link Sheets and Workbooks
Range Names
Logical, Stat. and Text Functions
Lookup and Reference Functions

PART 4 – PIVOTTABLES AND SLICERS

Create and Manage Pivot Tables
Create and Manage Slicers

PART 5 – PIVOT AND OTHER CHARTS

Create and Format Pivot Charts
Speedometer Charts

PART 6 – BASIC CONDITIONAL FORMATS

Add and Manage Conditional Formats

PART 7 – AUTOMATION

Data Validation
Intro to Macros and VBA

Part Two (Day 2)

PART 1 – DATA STRUCTURE

Review of KPI data
Data cleansing
Table Formulas
Further ideas for better structures

PART 2 – ADVANCED FORMULAS

Smart Use of Functions
Dynamic Ranges

PART 3 – MORE PIVOTTABLES & CHARTS

Considerations for protected sheets
A Deep look at Pivot Tables
Additional format options for Pivot Charts
Gantt Charts (as a Pivot Chart)
Bullet Charts and Data Layout

PART 4 – CONDITIONAL FORMATS (ADV)

Conditional Formats with Data Bars, Icon Sets and Formulas

PART 5 – DASHBOARD LOCKDOWN

Cell, Sheet, Chart as well as Shape and Object Protection
Workbook Protection

PART 6 – AUTOMATE & FORM CONTROLS

Automate with VBA
Refresh protected Pivots
On-sheet controls

Overview

This advanced two day Excel Dashboard Training Course is designed to teach attendees to discover (or enhance their existing) Excel Dashboard skills in order to build, automate and improve KPI or Dashboard summaries.

Furthermore, knowledge gained includes writing Excel VBA code, as well as building controls for filtering and displaying Dashboards via Charts and Formulas.

Audience & Duration

This two day Excel Dashboards Course (9am to 4pm WST) is an Advanced Course, which means that it is suitable for users who have solid, advanced skills in Microsoft Excel. Therefore, it will not suit anyone with limited Excel skills.

Course Outcome

Students will learn how to build, maintain and automate Excel Dashboards from scratch. At the same time, guidance is given about best practices for Excel Dashboards. Consequently, attendees should be confident to create code and controls that control the behaviour and appearance of an Excel KPI Dashboard.

Excel KPI Dashboards 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 Excel Dashboard Courses

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

Workplace Excel VBA Courses

We also offer Workplace Training for companies. This means that we can run the course 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 KPI Dashboards Training

In addition to this course, we also offer many other Training Courses for Excel, as well as custom Excel Training.

Online Excel VBA Courses

In addition to our standard delivery, 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

This Excel KPI Dashboards Course is a Two Day Course, run over two consecutive days.

Public & Virtual Dates	Link to Book
07 Mar 2022 (Mon)	BOOK NOW

Virtual & Public Pricing

Our Training is truly affordable. Take a look at our pricing table below.

Public (Two Day)	Price per Head
Enrol 1	$600
Enrol 2	$600
Enrol 3	$600
Enrol 4	$600
Enrol 5	$600
Concession Card	$400
5 Vouchers	$1,175
10 Vouchers	$2,250
20 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 Excel Dashboard 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

Related Microsoft Courses

In addition to our Excel KPI Dashboards Course (Excel Dashboards Course), here are some related Microsoft Office Training Courses for Australia and Perth.