Calendar | Enrol
Mobile MOUSe is the preferred INSTRUCTOR
Excel dashboard course
provider for Australia's
largest companies. Mobile MOUSe is proud to deliver an advanced dashboard training course
thats unique in Perth, Western Australia.
Don't miss out on this opportunity to enhance your Excel dashboard skills (introduced in our Excel Dashboards Day 1 course).
Take the skills learned on Excel Digital Dashboards (Day 1) to the next level. KPIs are a highly effective way of measuring business success as a result they can be used to measure all sorts of processes within the business, from finance to sales through to production and projects. Dashboards allow easy access to high-level overviews and help make quick decisions. The ability to create an Excel dashboard to keep track of performance and progress can be one of the most effective skills a manager or CEO has.
WHO SHOULD ATTEND THIS COURSE
This course is designed to further enhance the skills learned in our Digital Dashboards (Day 1) course to extending on the focus of developing stunning and easy to read visual representations of data to aid in business decision making or analysis. In order to attend this course, it is a pre-requisite that candidates have already attended the Mobile MOUSe Digital Dashboards (Day 1) course.
DURATION: 1 full
day (9am to 4pm)
VENUE: Onsite (your
premises) or Inhouse (our premises)
MINIMUM ATTENDANCE REQUIREMENTS
• Attendees must already have extremely strong Intermediate or Advanced skills in Excel
• Candidates MUST have attended the Mobile MOUSe Digital Dashboards (Day 1) course
PART ONE - DATA STRUCTURES
• Review of KPI data
• Data cleansing techniques
• Format as Table Formulas
• A deeper look at considerations for better Dashboard structures
PART TWO - ADVANCED FORMULAS FOR DASHBOARDS
• Smarter Use of Functions
• Dynamic Range Names
PART THREE - MORE PIVOTTABLES
• Refresh Pivot considerations when sheets are Protected
• A deeper look at PivotTables
PART FOUR - MORE PIVOTCHARTS
• Additional formatting options for PivotCharts
• Gantt Charts (as a PivotChart)
PART FIVE - OTHER CHARTS
• Bullet Charts and Data Layout
PART SIX - ADVANCED CONDITIONAL FORMATTING
• Conditional Formatting with Data Bars
• Conditional Formatting with Icon Sets
• Conditional Formatting with Formulas
PART SEVEN - DASHBOARD LOCKDOWN
• Cell Protection
• Sheet Protection
• Shape and Object Protection
• Chart Protection
• Workbook Protection
PART EIGHT - AUTOMATION AND FORM CONTROLS
• Automation with Macros and VBA
• Refresh code for protected Pivots
• On-sheet controls for dashboard interaction
IS THIS THE RIGHT EXCEL
COURSE FOR YOU?
Not sure which excel
course is the right one for you? Take our free, zero obligation
New Users Course (Basic)
Essentials Course (Intermediate)
Expert Course (Advanced)
Formula Workshop Course (Advanced)
Dashboards (Day 1) Course (Advanced)
VBA (Visual Basic for Applications) Course (Advanced)
[back to the top]
Digital Dashboard (Day 2) training in Perth
is conducted at your premises (office / factory) or... alternatively,
Excel Digital Dashboard Courses can be delivered at Unit 1 / 41 Action
Rd, Malaga, Perth,
With our onsite
excel training options, we come to you with our laptop computers
and projection equipment to deliver the Excel
course of your choice.
We can deliver custom
Excel training courses (i.e. you choose specific aspect(s)
of our Excel
courses that you would like delivered).
Our pricing structure is unique. The more people you enrol in an excel
course, the cheaper the excel
course becomes (which is great for companies and friends).
For all of the reasons above (and more), Australias'
biggest companies acknowledge the features and benefits of training
MOUSe. Our professional approach and intricate knowledge
of the features and abilities of Excel
have saved our clients millions of dollars after they implemented the
features we have made them proficient in. More
Our trainers are known for their knowledge
and helpful, friendly approach. All of our excel
courses are taught by experienced, certified and qualified
instructors, who individually have a minimum of 15 years training
• The best Excel
training in Perth
• A detailed high quality manual -> download
• Free downloadable practice files
• Online support
• A certificate of attendance (on request)
• Zero Hassle, FREE PARKING when attending at our premises
Click the image below to view our current perth
training schedule and potentially book your classroom seat(s).
» TRAINING FACTS
There are many myths about training - reasons suggested
for postponing skill development. Whether it’s a process that is
not being followed, technology under utilised – every organisation
benefits from training...
Mobile MOUSe is an authorised testing center for
the range of internationally recognised Microsoft Office Certifications.
» VENUE & ROOM HIRE
Need a meeting or training room? Options range
from a day to a years lease.