Excel - Presenting Data
- 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.
- 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