Excel and PowerPoint Don’t Mix…

SpreadsheetVery often presentations will include financials or other figures. And, of course, the presenter believes that the best way to present this data is by cramming as much as he can into a gigantic Excel spreadsheet and then copying and pasting that 6,250-cell spreadsheet onto one small PowerPoint slide. Impressive, right? Think again, presenter… this has zero impact. And, it will even distract from your presentation because people will lose focus as they won’t be able to see what you are referring to and follow along.

Spreadsheets are used for analyzing, not for communicating. They are fantastic for quickly figuring out totals or averages or for doing hundreds or even thousands of calculations instantly on rows and rows of data. They are not, however, great for presenting. Simply put, they contain way too much information. My advice is to simplify: do you really need to present all of the data? Or just the results?

By focusing on the results in some sort of summary fashion like a table, the audience can see the numbers big and clear. You can explain how you arrived at each number if you see fit. You can walk them through it step by step but you don’t need to show the entire process. Use colors, percentages, underlining, boldface, and other effects to highlight key figures or show comparisons or differences within the results. With a summary table you have a powerful, focused image that you can now play around with and be creative.

In the end, the audience will remain more focused and in tune with your presentation and you will be able to get your point across more succinctly and effectively.

Tagged , , , , , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: