COURSES | PRICING | CALENDAR | ENROL | CONTACT | SELF ASSESSMENT | DOWNLOADS | FEEDBACK  
 
  EXCEL | WORD | ACCESS | OUTLOOK | PROJECT | POWERPOINT | VISIO | INFOPATH | PUBLISHER | SHAREPOINT | ACROBAT | PC BASICS |ONLINE COURSES
  TIME MANAGEMENT | PROJECT MANAGEMENT | CONSULTING SERVICES | ONSITE TRAINING | OUR VENUE
 
» QUICK LINKS
 

EXCEL DIGITAL DASHBOARD COURSE (DAY 2) - ADVANCED PERTH

Outline | PDF | Calendar | Enrol | Enquire | Pricing

Mobile MOUSe is the preferred INSTRUCTOR LED 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).

EXCEL DIGITAL DASHBOARDS COURSE (DAY 2) OVERVIEW
Skill Level: Advanced

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.

COURSE DURATION AND TRAINING VENUE

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

COURSE OUTLINE

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 excel self assessment here. More info...

» Excel New Users Course (Basic)
» Excel Essentials Course (Intermediate)
» Excel Expert Course (Advanced)
» Excel Formula Workshop Course (Advanced)
» Excel Dashboards (Day 1) Course (Advanced)
» Excel VBA (Visual Basic for Applications) Course (Advanced)

 

 

[back to the top]

 

LEARN ABOUT OUR ONSITE TRAINING



ABOUT OUR EXCEL DASHBOARD DAY 2 (ADVANCED) COURSE

 

Our Excel Digital Dashboard (Day 2) training in Perth is conducted at your premises (office / factory) or... alternatively, our Excel Digital Dashboard Courses can be delivered at Unit 1 / 41 Action Rd, Malaga, Perth, WA.


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).

 

COURSE PRICING


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). More info...

 

For all of the reasons above (and more), Australias' biggest companies acknowledge the features and benefits of training with Mobile 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 info...

 

OUR TRAINERS

 

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 experience.

 

EACH STUDENT RECEIVES


• The best Excel training in Perth and Western Australia
• A detailed high quality manual -> download a sample
• Free downloadable practice files
• Online support
• A certificate of attendance (on request)
• Zero Hassle, FREE PARKING when attending at our premises

 

 

 

[back to the top]

» CALENDAR

Click the image below to view our current perth training schedule and potentially book your classroom seat(s).

 

Mobile MOUSe course calendar

» 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...

 

More info...

» CERTIFICATION

Mobile MOUSe is an authorised testing center for the range of internationally recognised Microsoft Office Certifications.

 

Microsoft Office Certification

 

More info...

» VENUE & ROOM HIRE

Need a meeting or training room? Options range from a day to a years lease.

 

More info...

 

 

 
Email Mobile MOUSe
Read our terms and conditions...