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

About the Reviewers

Jaime Campbell (CPA, MBA, CTT, MCT)

Leveraging 14 years of teaching experience with seven of those years in the accounting industry, Jaime Campbell leads the technology training and financial modeling services at the accounting firm of Bartolomei Pucciarelli, LLC in Lawrenceville, New Jersey, USA. She provides consulting services and expert instruction on software used by Certified Public Accountants (CPAs) and small businesses. Jaime is a Certified QuickBooks Professional Advisor, Microsoft Certified Trainer (MCT), Certified Technical Trainer (CTT), and Certified Microsoft Master, having earned the highest certifications in Excel, Word, PowerPoint, and Outlook.

Jaime connects her Excel expertise and accounting experience to provide acclaimed financial modeling services for small businesses, creating custom financial models which are dynamic, user-friendly, and compliant. Her clients use these financial statements to obtain venture capital, bank loans, significant contracts, or to evaluate a business expansion or acquisition.

Jaime also prepares financial statements, business and individual tax returns, budgets, projections, and participates in special analysis and operations management projects. Jaime works closely with small business clients to "measure, monitor, and manage" their key performance indicators.

Jaime also teaches business technology courses at Princeton Adult School and gives seminars and webinars on financial and technology topics. Her published articles include "Look like a Tech Wiz with Keyboard Shortcuts," "How to Quickly Find Spreadsheet Errors," "QuickBooks Time-Saving Features," "Untapped Google Applications," and "Remote Access and Office 2010: Communication, Collaboration, and the Cloud."

Jaime is a member of the American Institute for Certified Public Accountants (AICPA) and New Jersey Society of Certified Public Accountants (NJSCPA). She is also a member of the NJSCPA Technology Interest Group and Financial Literacy Interest Group, serves as an Officer on the NJSCPA Mercer County Chapter Board of Directors, and volunteers as a Spanish-language business consultant with the New Jersey Small Business Development Center.

Jaime earned her Master of Business Administration degree from Rutgers Business school and her Bachelor of Music Education from Florida State University.

Palle Korsholm has worked as an Auditor and Controller in productions and distribution companies for 23 years—mostly with tasks with in reporting, budgeting, controlling, internal controls, and process optimizing.

He is currently living in Denmark and has received his Education from the Syddansk University and Copenhagen Business School. He has a Bachelors in Business and a Higher Diploma in Accounting. He also has one in Economy and IT.

Andrew A. Odnoha is retired and currently does consulting work. He has a BBA degree and has worked in the Banking and Accounting field primarily.