Training Courses in Perth for: Excel | Word | SharePoint | Project | Outlook | Time Management | Access | PowerPoint | Visio | Publisher | PC Basics | Acrobat
Mobile MOUSe Mobile MOUSe Training Mobile MOUSe

Welcome to Mobile MOUSe, Perth WA

Excel Dashboard Training Course - Day 2 (Advanced)

Course Calendar Calendar | Course Outline PDF Outline | Enrol Enrol | Course Enquiry Enquire | Course Pricing Pricing | Skills Assessment Assessment

Excel LogoExcel Dashboards (Day 2) Training Summary

Mobile MOUSe is the preferred INSTRUCTOR LED Excel Digital Dashboards course provider for Australia's largest companies.

COURSE TARGET SKILL SET: ADVANCED
TRAINING COURSE DURATION: 1 Day (9am - 4pm)
TRAINING VENUE: Our Premises (In-house Perth) or Your Premises (Onsite)

Minimum Attendance Requirements

• Attendees must already have Advanced Excel skills.
• Candidates MUST have attended the Digital Dashboards (Day 1) course.

Training Course Overview

Take the skills learned on our Excel Digital Dashboards (Day 1) to the next level. Key Performance Indicators (KPI) 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. Advanced Excel 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.

Intended Audience

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.

Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn See How We Roll


Excel Dashboards Training Course Outline

PART ONE - DATA STRUCTURES

• Review of KPI data
• Data cleansing techniques
• Format as Table Formulas
• Deeper look at dashboard structure considerations

PART TWO - ADVANCED DASHBOARD FORMULAS

• Smarter Use of Functions
• Dynamic Range Names

PART THREE - MORE ON PIVOTTABLES

• Refresh considerations on Protected sheets
• A deeper look at PivotTables

PART FOUR - MORE ON PIVOTCHARTS

• Additional PivotChart formatting
• Gantt Charts (as a PivotChart)

PART FIVE - OTHER CHARTS

• Bullet Charts and Data Layout

Outline (PDF) Enrol Now Onsite Quote

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

Related Excel Courses in Perth

If you are not sure if this is the right Excel course for you, why not take our zero obligation online excel training course skills questionnaire? Alternatively investigate one of our other Excel Training Course options below...

New Users (Basic Excel Course)
Essentials (Intermediate Excel Course)
Excel Expert (Advanced Excel Course)
Formula Workshop (Excel Formulas Course - Advanced)
VBA Essentials (Excel VBA Course - Advanced)
Dashboards - Day 1 (Excel Dashboards - Advanced)
Online Microsoft Excel Training Courses

General Notes

Our Inhouse Excel Dashboards Training in Perth is conducted at Unit 1 / 41 Action Rd, Malaga, Perth, WA or... alternatively, our Excel Dashboard Courses can be delivered onsite at your premises (office / factory / regional / minesite).

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 also deliver custom Excel training courses (i.e. you choose specific aspect(s) of our Excel courses that you would like delivered). Our Microsoft Excel training is structured to Microsoft Office Certification, in addition, every Excel course comes with free online support.

What Students Say

Standard Course Inclusions

Onsite Training (Your Venue)
For all onsite Excel Training we supply the following (all at NO EXTRA COST):

• The Laptops (at no extra cost)
• Face to Face Instructor-Led Training
• The Projection Equipment
• All electric cables and Power boards
• Student Manuals
• Free Downloadable Exercise Files
• Post Course Student Support
• Certificate of Attendance (On Request)
• Dynamic, Qualified Experienced trainers
• An Amazing Training Experience :-)

InHouse Training (Our Venue)
For all Excel Courses our venue we supply the following at no extra cost.

• State of the Art Training Facilities
• Free Parking
• Free Refreshments
• Student Manuals
• Free Downloadable Exercise Files
• Post Course Student Support
• Certificate of Attendance
• Dynamic, Qualified Experienced trainers
• An Amazing Training Experience :-)

Our Social Media Links

Mobile MOUSe Social Media

Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn

Microsoft Certification

Mobile MOUSe is an authorised testing center for the range of internationally recognised Microsoft Office Certifications. Click the graphic below for more information about Microsoft Office Certification.

MOS Testing Centre

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

© 2017 - Mobile MOUSe - Microsoft Office Training and Consulting Specialists (Perth - Western Australia) | (08) 9404 7041 | www.mobilemouse.com.au
 
 
Mobile MOUSe YouTube Channel Mobile MOUSe Facebook Mobile MOUSe LinkedIn