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

Calculating hours with a visual timesheet


When running a business, or working on projects, timesheets are a necessary component of business. As with other data, information in a pure number format is essential, albeit difficult to read at times. Creating a timesheet to represent the hours and times worked graphically, which will allow the analysis of the visual component without having to employ mathematical functions.

In this recipe, you will learn to create a visual timesheet based on the hours entered.

Getting started

This recipe will begin with a pre-formatted timesheet worksheet. Using the following example as a guide, lay out your timesheet exactly as shown. The starting time for the timesheet will be 8:00am and it will end at 20:00 or 8:00pm.

In order to produce the angled times as shown in row 1, select all cells in row 1 starting with E1 through Q1. With the cells highlighted, from the Home tab on the Excel ribbon, select the text alignment button and choose angle counter clockwise...