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.
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 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.
Public & Virtual Dates
This Excel KPI Dashboards Course is a Two Day Course, run over two consecutive days.
Virtual & Public Pricing
Our Training is 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 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 !!!
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.
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.
EXCEL DASHBOARDS COURSE
Discover our Excel Dashboards Course (Advanced). 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.
VBA (MACROS) EXCEL COURSE
Click to learn about our Excel VBA Course (Advanced). Virtual Classes are also available.
In Business Since
Students Trained
Avg Student Score (out of 10)
Pricing From
Excel Dashboards KPI Course Inclusions
All Mobile MOUSe Excel Courses have the following course inclusions…
IN-HOUSE (Our Venue)
Excel Courses at our Perth venue include the following…
- 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