Book Image

Excel 2010 Financials Cookbook

By : Andre Odnoha
Book Image

Excel 2010 Financials Cookbook

By: Andre Odnoha

Overview of this book

<p>Excel is one of the mostused software tools in the world and just about every business has a copy somewhere. Despite its power and flexibility it is not always clear how to use it to perform some of the most important tasks in any business: organizing, analysing, and presenting financial information.<br /><br />Excel 2010 Financials Cookbook contains a rich collection of useful techniques for handling financial data in Excel. From integrating data from a variety of different sources, through organazing and analyzing financial data, to presenting it in a variety of graphical forms, this book has you covered.<br /><br />The book deals first with "normalizing" financial data -- that is, bringing data from a number of different sources into a single format where you can analyze them together. Then you'll learn techniques for managing and analyzing the data before discovering ways to present it graphically. The book then looks at Excel's built in features for financial analysis, and even shows how you can combine the built in features to build your own analysis functions.</p>
Table of Contents (14 chapters)
Excel 2010 Financials Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Displaying financial summary formulas within their cells


When viewing financial summaries that utilize formulas, there are numerous reasons that you may need to view the formulas. In a sheet that utilizes many formulas, it may take a great deal of time to view each individual formula by selecting the cell and displaying the formula within the formula bar.

In this recipe, you will learn to display all the formulas within a sheet listed within the cell that contains a formula.

How to do it...

The following sheet contains a transaction register that utilizes formulas to provide a total of credit, debit, and remainder balances:

While displaying the active Excel sheet that contains formulas to be displayed, on your keyboard press Ctrl + ~ (tilde):

The Excel sheet now displays all of the formulas currently used. To turn off this display, simply press CTRL + ~ again.

How it works...

The calculation answer displayed within a cell is a type of formatting; CTRL + ~ toggles formatting within Excel. You may also notice that any formatting such as date and currency formatting will also be removed.

There's more...

Access to formatting can also be accomplished by right-clicking on the highlighted area and selecting Format. The formatting options will allow you to see all of the formatting options available before toggling these formats.