especially powerful

Presenting a Spreadsheet?

personal competitive advantage in presenting the spreadsheet
Presenting the Spreadsheet does not have to be Painful

Financial analysis of the firm is essential, and there are few occasions when financial data do not make their way into a presentation, usually in the form of presenting a spreadsheet.

With financial data, you can discover the firm’s profitability, general health, and potential.  You can get reasonable answers to the question: “How are we doing?”

But . . .

. . . and it is an especially powerful but.

The results of your financial analysis invariably constitute the ugliest section of a presentation.

Presenting a Spreadsheet without Hypnosis

Something about a spreadsheet mesmerizes students and faculty alike.

A spreadsheet splayed across the screen gives the impression of heft and gravitas.

A spreadsheet seems important, substantial.

Everyone nods.

As a presenter, you stare back at the screen behind you, at the phalanx of numbers.  You wave your hand at the screen with the words “As you can see –”

Mesmerize your audience
You need not hypnotize your audience with a staid spreadsheet presentation

And then you call out seemingly random numbers.  Your classmates or colleagues in the audience watch with glazed eyes.

It’s almost mystical.

Perhaps one or two people nod.

Your professor sits sphinx-like.  Some folks shuffle papers, actually digging through a handout you mistakenly distributed beforehand.

No one has a clue as to what you’re talking about or how it actually relates to the real world.

You get through it, finally, and you’re relieved.  And you hope that you were vague enough that no one can even think about asking a question.

This is quite common.

And it’s Ugly

So ugly.

There is a best way that makes things easier for everyone.

Three Steps:  Orient, Eliminate, Emphasize

First, orient your audience to the overall financial context.  If you take information from a balance sheet or want to display company profit growth for a period of years, then display the sheet in its entirety to orient the audience.

Tell the audience they view a balance sheet.  Walk to the screen and point to the information categories.  Say “Here we have this number” . . . “Here we have this category.”

Second, eliminate everything on the screen that you will not talk about.  You strip the visual down to the basic numbers and categories you use to make your point.

Third, emphasize the important points by increasing the size, coloring them, or bolding the numbers.  You can illustrate the meaning of the numbers by utilizing a chart or graph.

If you follow this basic advice, presenting a spreadsheet can be, if not glorious, at least pain-free and even a pleasant experience for your audience.

You can improve the finance portion of your presentation immensely and be on your way to an especially powerful presentation that achieves your personal competitive advantage.

For more on presenting a spreadsheet in the best light, consult The Complete Guide to Business School Presenting.