I'm pleased to announce the publication of my new book:
MEANINGFUL GRAPHS: CONVERTING DATA INTO INFORMATIVE EXCEL CHARTS
It is designed for those who want to create more effective graphs in Excel but who don't have the time or interest to become experts in graph design and Excel techniques. Written in a conversational tone, it contains:
- Step-by-step instruction on how to incorporate the best design principles into Excel charts
- Over 130 full color examples - graphs, tables, and illustrations - with accompanying data to facilitate practice
- TIPS and In Practice experiences in using graphs
- Chart-related statistical discussions (Pareto charts, run charts, correlations)
- Sections on using graphs in PowerPoint presentations including chart animation.
In essence, it contains all the essential information you will need to make your graphs more informative and more effective in problem-solving. I truly hope you enjoy it and find it valuable in your work.
Beneath the image of the cover are two files. One provides a more detailed Overview of the book and the other presents Extracts from the book (Table of Contents, List of Appendices, sample sections from the text, and the Index).
Collecting data is the first step in any improvement effort - but it's only the first step. Whether these data are useful or not is very dependent on their conversion into information that clinical and management staff can utilize to improve the quality of care/services.
Data as data are meaningless.
Data presented as information are priceless.
Converting data into useful information involves skills in data analysis, in constructing effective charts, and in creating dynamic presentations.
The trick, of course, is lecturing about data without boring the audience to death. I do this through the use of humor, real hospital examples, stories from my time in the trenches, and PowerPoints that are almost completely devoid of bullet point slides. Audiences often find this a refreshing change from the typical presentation and a particularly pleasant surprise for presentations on data and data analysis.
My presentations (see Presentations tab) are ideal for a conference, hospital or college meeting where there is a desire on the part of planners to include a plenary or workshop on data analysis which is content rich but interesting and engaging as well. I have given my presentations to physicians, nurses, and other clinical and administrative staff at facilities or conferences/symposiums around the country.
A common form of feedback I get is "I wasn't looking forward to a presentation on data but you made it interesting and fun." (see Testimonials tab for more feedback on my presentations.)
If you would like to receive a free copy of the handout from my Charts Workshop - "Rules for Charts" - just email me at Smith1862@optonline.net and I'll be happy to email you the PDF. It's an 11 page document (not copies of PPT slides) which gives some of the rules you should follow to create really effective charts and presents examples of common chart problems.