O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Analyzing financial data with pop-up tools

We have discussed and learned how powerful a quick analysis can be for determining profitability and other factors of finance, specifically the snapshot attained from a five-number summary. In this book, we have also discussed methods for formatting data tables and creating analysis worksheets for viewing this information. However, with changing data, the ability to attain a summary analysis on data without having to formally build an analysis can be extremely valuable.

In this recipe, you will learn to create an add-in function that will provide a five-number summary of selected data, on-demand.

How to do it...

We will begin this recipe by opening a new blank worksheet:

  1. Within the Excel worksheet, press ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required