Presenting the Numbers
The Essentials
A half-day, hands on workshop held at your location.
Presenting the Numbers Course Brochure (513 KB)
Presentation:
Effectively communicating your business data
1 hour
The importance of the numbers to your businessUnderstanding your audience
- Just who are your clients and stakeholders?
- Choosing the presentation style suitable for your audience
- Focusing your message
- General decision rules
- Principles for effective tables
- Making your message stand out
- Principles for effective charts
- How to show the common data relationships: Comparison, Ranking, Component, Boundary, Frequency distribution, Time series, Correlation and Separation
- Is there a formula for the best chart type?
Hands-on:
Essential Business Charting
Excel techniques and tools for the charts you need
to carry your message
2 hours
Practical Graphical Text and Tables- Conditional formatting
- In-cell charting
- Generating charts for the common data relationships
- Formatting and highlighting results
- Themes and colour palettes
- Labelling, gridlines and chart support tools
- Linking text to charts and SmartArt
- Evaluating the results
Frequently Asked Questions (90 KB)
You will learn
- How to identify and communicate your message to
your target audience - The key rules of effective business graphics and charting
- How to generate charts quickly and accurately using the
Excel 2007 toolbox - How to use text effects, SmartArt and graphic objects to make your messages more powerful
Advanced
This session is a follow-on from Presenting the Numbers – The Essentials.
A half-day, hands on workshop held at your location.
Presenting the Numbers Course Brochure (513 KB)
Presentation:
Getting more strategic value from your business data
1 hour
Data representations- An interactive look at some different approaches
to data representation - Example charts & tables: some good, some bad and
some just plain ugly - Presenting information from large data sets
- Working with media limitations: the web, the desktop and a
piece of paper
- Some principles of effective dashboard design – and a look at some try-hard ‘crashboards’
- What should dashboards present?
- Effective representation of Key Performance Indicators vs eye candy and the steam gauge
- Simple techniques for dashboard design
Hands-on:
Advanced Business Charting
Excel techniques and tools for outstanding communications
2 hours
Dynamic charts- Putting the focus on only the information you want your
audience to see ‘Conditional formatting’ of charts - Avoiding the need to develop a new chart every time
the data changes
- Additions to the standard Excel arsenal with:dot plots,
sparklines and bullet graphs - Sharing your data and charts
- Web-based methods for sharing your data with
colleagues and clients
Frequently Asked Questions (90 KB)
You will learn
- How to develop charts that do not need to be changed
when data is added or deleted - How to make charts that focus your audience on what
you want them to see - How to present comparative results for alternate scenarios
Calculate your payback on our courses