Learn how to communicate better with numbers
Whether you are distributing a report or giving a presentation, you have a lot of numbers to present and only a few minutes to get your point across. Your audience is busy and has a short attention span. Don't let an amateur presentation bog you down, confuse your audience, and damage your credibility. Instead, learn how to present numerical information effectively—in the same way you learned how to speak or write. With Painting with Numbers, you'll discover how to present numbers clearly and effectively so your ideas and your presentation shine.
Use the Arabic numeral system to your advantage master the use of layout and visual effects to communicate powerfully
Understand how audiences process your information and how that affects your "personal brand image"
Learn how to be perceived as a professional who truly understands the business concepts and issues underlying your numbers
Use software tools, including Excel, PowerPoint, and graphs, efficiently and to drive home your point
Author Randall Bolten shares his decades of experience as a senior finance executive distilling complicated information into clear presentations, to help you make your numerical information more comprehensible, meaningful, and accessible. Painting with Numbers is brimming with hands-on advice, techniques, tools, rules, and guidelines for producing clear, attractive, and effective quantation (the word the author has coined for the skill of presenting numbers).
Table of Contents
- Title Page
Part I: The Rules
- CHAPTER 1: Numerals Matter
- CHAPTER 2: Looks Matter
- CHAPTER 3: Words Matter
- CHAPTER 4: Your Audience Matters
PART II: THE TOOLS
CHAPTER 5: You Can Pay Me Now . . .
- The Instant Payoff Tips
- Instant Payoff Tip #1: Set Up Templates and Styles
- Instant Payoff Tip #2: Customize Your Toolbar
- Instant Payoff Tip #3: Learn Some Shortcut Keys
- Instant Payoff Tip #4: Use Consistent Formats
- Instant Payoff Tip #5: Learn to Use Excel as a Database
- Instant Payoff Tip #6: Learn to Use the Lookup & Reference Functions
- Instant Payoff Tip #7: Organize Data for Easy Computation
- Instant Payoff Tip #8: Learn to Use Automated Help
- Instant Payoff Tip #9: Don't Learn Too Many Ways to Do the Same Thing
CHAPTER 6: . . . Or Pay Me Later
- The Long-Term Payoff Tips
- Long-Term Payoff Tip #1: Use Sensible, Intelligent Filenames and Folder Organization
- Long-Term Payoff Tip #2: Use Consistent Formats
- Long-Term Payoff Tip #3: Design Intelligent, Intelligible Formulas
- Long-Term Payoff Tip #4: Use Named Ranges
- Long-Term Payoff Tip #5: Use Named Formulas or Macros
- Long-Term Payoff Tip #6: Links: A Force That Can Be Used for Good or Evil
- Long-Term Payoff Tip #7: Make Different Types of Cells Visually Distinguishable and Physically Separate
- Long-Term Payoff Tip #8: Document Your Work!
- Long-Term Payoff Tip #9: Check Your Work!
- Long-Term Payoff Tip #10: Avoid Cool New Features
- CHAPTER 7: Graphs: The “Cartoons” of Numbers
- CHAPTER 8: The Pitfalls of Presentations and PowerPoint
- CHAPTER 5: You Can Pay Me Now . . .
PART III: REAL MASTERY
- CHAPTER 9: It's Clear, But Is It Meaningful?
- CHAPTER 10: 53 . . . Uh, Is That a Lot?
CHAPTER 11: The One Report Every Organization Needs
- A Sample Natural P&L, and What Makes It a Good One
- 1. One Page!
- 2. Decision-Focused Line Items
- 3. Appropriate Dollar Amounts, Neither Too Big Nor Too Small
- 4. Intuitive Organization of the Line Items
- 5. Understandable Categories, Meaningful to All Users
- 6. Plain-English Terminology
- 7. Consistent Look-and-Feel
- 8. Key Results Equal to the Corresponding Numbers in the Accounting System (or an Explanation Why Not)
- Mapping the Chart of Accounts
- Generate a Natural P&L from a Spreadsheet, or from the Accounting System?
- Now Let's Talk about the Columns
- APPENDIX 11 A: A Sermon to the Accounting Purists
- CHAPTER 12: The Gaps in GAAP
- APPENDIX 12 A: Some Notes on GAAP
- CHAPTER 13: Quantation: It's Not Just for Business Anymore
- CHAPTER 14: Quantation in Ordinary Life
PART IV: WRAP-UP
CHAPTER 15: Speaking Truth to Power
- My “Tell the Truth” Syllogism
- Reason #1 for Telling the Truth: It's the Right Thing to Do
- Reason #2: It's in Your Employer's Interest
- Reason #3: It's in Your Interest
- Reason #4: You Will Get Caught
- Reason #5: It's the “Gotcha” of This Book
- Don't Be So Smug, You Civil Servants and Elected Officials!
- Your Audience Has a Role, Too
- CHAPTER 16: Now, What's the First Thing You Do?
- CHAPTER 15: Speaking Truth to Power
- Appendix: Jazz Meets Theology
- About the Author
- Title: Presenting Financials and Other Numbers So People Will Understand You: Painting with Numbers
- Release date: April 2012
- Publisher(s): Wiley
- ISBN: 9781118172575