Excel - Presenting Data

Outline

  • This half-day course explores the range of visual presentation tools that help to communicate numbers and stats in easy to read views: Charts and Graphs.
  • Also covered in this course are how these can be incorporated into Word reports and PowerPoint presentation slides, the use of Conditional formatting, the use of KPI's and project Gantt-type charts.
  • Data presented in a row or column is useful, but patterns can be hard to spot at a glance - this course introduces Sparkline Charts - enabling visual representations of data with one click.
  • This course is an excellent project management tool.

Content

  • Introduction to visual presentation tools
  • Communication of numbers and stats in easy to read views - Charts and Graphs
  • Conditional formatting
  • Key Performance Indicators (KPIs)
  • The RAG system, (a popular project management method of rating for issuing status reports, based on Red, Amber (yellow), and Green colors used in a traffic light rating system).
  • Sparkline charts - a tiny chart in a worksheet cell that provides a visual representation of data. Sparklines are used to show trends in a series of values, such as economic cycles or to highlight maximum and minimum values - positioning a Sparkline near its data for greatest impact. One advantage of using Sparklines is that, unlike Charts, Sparklines are printed when you print a worksheet that contains them
  • Project Gantt-type charts
  • Explores the range of presentation tools to use with Word and PowerPoint


Show the next months in

Location Dates Time Price exc. VAT   Status
Contact Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This