Microsoft Excel Level 4

Topics

  • Challenges of quantitative data presentation
  • Introduction to table and graph design
    • Fundamental challenges of data presentation
    • Key characteristics of quantitative information
    • Differing characteristics and uses of tables and graphs
    • Common quantitative relationships featured in graphs
    • Visual perception and how it applies to data presentation
    • Steps in the visual design process
  • Table design
    • Structure, layout & formatting
  • Graph design
    • Visual objects used to encode values in graphs
    • Matching the right visual encoding objects to the fundamental quantitative relationships in graphs
    • Graph design at the component level
  • The definition and potential benefits of dashboards
  • Current trends in dashboard design
  • Common mistakes in dashboard design
  • The characteristics of well-designed dashboards
  • Steps in the dashboard design process
  • Common dashboard information and techniques for enhancing meaning
  • Selecting appropriate media for displaying the data
  • A library of dashboard display mechanisms
  • The best practices of dashboard design
  • An introduction to visual data analysis
  • Visual characteristics to look for in the data
  • Quantitative business analysis techniques by type
    • Analysing time series
    • Analysing rankings
    • Analysing deviations
    • Analysing distributions
    • Analysing correlations
    • Analysing geo-spatial data

Target Audience: Students who have advanced skills with Microsoft Excel who want to learn about dashboard design using Microsoft Excel

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh

“Professional Microsoft Excel Training in Scotland”