1 / 33

Terrific Tables: Excel & PowerPoint Mastery with Nolan Haims

Join Nolan Haims in this informative session to learn efficient table design techniques in Excel and PowerPoint. Explore tips on aligning text and numbers, removing clutter, adding visualizations, and more. Perfect for improving your table skills!

ohearn
Download Presentation

Terrific Tables: Excel & PowerPoint Mastery with Nolan Haims

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Tuesday 3:45-4:15 Terrific Tables Nolan Haims #PRESUM18 | @NolanHaims | Nolan@NolanHaimsCreative.com

  2. GLANCEABLE REFERENCEABLE

  3. The Better Table Checklist .00 Excel or PowerPoint Left/Right Align Text Ditch The Color Right/Decimal Align Numbers Round Your Numbers Remove Grid Lines Shade with a Subtle Hand Remove Unit Repetition Increase White Space Highlight Outliers & Negatives Add Subtle Dividers Add Visualization

  4. Excel or PowerPoint Add/delete rows, columns Pre-defined styles Manual formatting Conditional formatting Heat mapping Sort Filter Calculate and total values Functions Custom number formatting Sparklines Save out a custom style Connect to external data Much, much more… Add/delete rows, columns Pre-defined styles Manual formatting

  5. [Demo]

  6. Ditch The Color

  7. Remove Grid Lines

  8. Shade with a Subtle Hand

  9. Shade with a Subtle Hand

  10. Increase White Space

  11. Add Subtle Dividers

  12. Left/Right Align Text

  13. Left/Right Align Text

  14. Right/Decimal Align Numbers

  15. Round Your Numbers .00

  16. Remove Unit Repetition

  17. Highlight Outliers & Negatives

  18. Highlight Outliers & Negatives 386,664

  19. Add Visualization

  20. Add Visualization

  21. Finances Fundraising

  22. Financials in dollars Detailed financial model avalable on request

  23. Financials in dollars Detailed financial model avalable on request

  24. Templeton Global Bond Ad FTSE WGBI USD

  25. The Better Table Checklist .00 Excel or PowerPoint Left/Right Align Text Ditch The Color Right/Decimal Align Numbers Remove Grid Lines Round Your Numbers Shade with a Subtle Hand Remove Unit Repetition Increase White Space Highlight Outliers & Negatives Add Subtle Dividers Add Visualization

  26. Terrific Tables Nolan Haims #PRESUM18 | @NolanHaims | Nolan@NolanHaimsCreative.com

More Related