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

Highlighting user edits and storing the versions


In order to gauge financial strength and create proper forecasting, it is necessary to collect data from multiple sources. Within that data collection, it is also necessary to provide datasheets to others. When sharing worksheets, Excel will allow you to utilize track changes to see what was edited; however, with regards to user functionality, this method falls short.

In this recipe, you will learn to create an add-in to an Excel worksheet that will not only track changes, but will also mark the changes to identify the location of the changed data and create a cell comment with the past values for easy reversal and historical tracking.

How to do it...

We will start by opening the Visual Basic Editor (VBE) in Excel and displaying a blank code window:

  1. 1. Within Excel, press Alt + F11 to open the visual basic editor (VBE):

  2. 2. Double click on the label for Sheet1 to open a blank code window.

    Excel will display Sheet1 at the top of the window and...