Microsoft Excel Training Course

Table of Contents

Microsoft Excel Dashboards training course, Microsoft Excel Dashboards Training Course

Excel Dashboards Training Course Overview

Our Microsoft Excel Dashboards training course examines the key Excel skills of data analysis and charting and then considers the best methods to present complex information, key KPI’s and metrics to provide meaningful insight to managers and business leaders.

Microsoft Excel Dashboards training course, Microsoft Excel Dashboards Training Course

Excel Dashboards Five Key Topics

  1. Planning an effective dashboard
  2. Analysing data using Pivot Tables and Formulas
  3. Visualising data using Charts and Sparklines
  4. Combining text, tables and graphics on an Excel worksheet
  5. Creating interactive dashboards
Microsoft Excel Dashboards training course, Microsoft Excel Dashboards Training Course

Course Details

Course Duration: 1 day
Course Availability: Monday – Saturday
Course Types: Group booking, 1-2-1 sessions, online, Bespoke & Public Courses
Course Availability: Monday – Saturday

Microsoft Excel Dashboards training course, Microsoft Excel Dashboards Training Course

Excel Dashboards Training Course Details

Course Location: This Microsoft Excel Dashboard training course can be delivered either at our London training venue or at your offices.

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Tailored Courses: We offer a free consultancy service to help tailor your course to meet your requirements.

Rate: £220 + VAT

Next Public Course: Please Call

Centre and Services

Comfortable & modern facilities
Unlimited access to our online training manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available

On Completion of Excel Dashboards

  • Plan an effective dashboard layout
  • Analyse data using Pivot Tables
  • Analyse data using Excel formulas
  • Appreciate Dashboard Charting techniques
  • Visually present data using traffic lights and slicers
  • Include trendlines
  • Incorporate scenarios to show different outcomes
  • Create an interactive dashboard
  • Use consistent scaling for dashboard elements
  • Distribute a secure dashboard

Excel Dashboards Course Outline

  • Dashboard layout
  • Best Practice
  • Effective use of colour
  • Building a Pivot Table
  • Pivot Table totals
  • Pivot Table fields
  • External data sources
  • Lookup functions: VLOOKUP, INDEX, OFFSET
  • Decision-making functions: IF, CHOOSE
  • Aggregation functions: SUMIFS, COUNTIFS
  • Creating Charts
  • Creating user-defined chart types
  • Changing the default chart type
  • Combining different chart types in one chart
  • Creating custom markers
  • Creating miniature charts suitable for dashboards
  • Using Sparklines
  • Target vs Actual charts
  • Bubble charts
  • Conditional formatting to highlight data
  • Traffic lights
  • Using Linked Pictures and the Camera Tool
  • Using Text Boxes
  • Using Slicers
  • Calculating a trend
  • Inserting trendlines on charts
  • Creating scenarios
  • Options for choosing different scenarios
  • Drop down lists
  • Form controls
  • Linking charts to Form controls
  • Using consistent scaling
  • Moving and scaling graphic objects
  • Hiding worksheets and ranges
  • Security and Protection
Microsoft Excel Dashboards training course, Microsoft Excel Dashboards Training Course
Microsoft Excel Dashboards training course, Microsoft Excel Dashboards Training Course
Microsoft Excel Dashboards training course, Microsoft Excel Dashboards Training Course
Excel Dashboards Hints and Tips