Excel 2010 Financials Cookbook

Exploit the flexibility of Excel to the max by using it to manage and analyze your financial data. These hands-on recipes will give you the techniques you need to go from casual user to power user.

Overview

• Harness the power of Excel to help manage your business finances
• Build useful financial analysis systems on top of Excel
• Covers normalizing, analysing, and presenting financial data
• Clear and practical with straight forward, step-by-step instructions

What you will learn from this book

• Normalize financial data in Excel, so that data from different sources can be easily compared
• Organize your money and finances in the best way to enable easy and powerful analysis of that data
• Present your financials graphically using charts and other methods
• Discover powerful analysis functions in Excel, and combine existing functions to create new ones

Approach

The Cookbook format means each technique is explained with step-by-step instructions, and you can jump straight to the techniques you need. You won't need to read this book from start to finish in order to get value out of it.

Who this book is written for

This book is for anybody who wants to use Excel to manage their revenues, budgets, and other financials. It's especially suitable for small businesses that already use Excel and want to get more from it.

In Detail

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.

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.

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.