Business Analysis with Microsoft Excel

, by Carlberg, Conrad

Write a Review

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780789736642 | 0789736640
Cover: Paperback
Copyright: 6/19/2007

Business Analysis with Microsoft Excel > ISBN13: 9780789736642

Sorry, this item is currently not available.

Supplemental Materials

Extensive coverage of Excel's financial capabilities - for small businesses or major corporations!

Conrad Carlbergis president of Network Control Systems, Inc., a software-development and consulting firm that specializes in statistical and database applications. He holds a Ph.D. in statistics and is a many-time recipient of Microsoft’s Most Valuable Professional Award. He lives near San Diego.

Introduction	p. 1
Taking It on Faith	p. 2
About the Platform	p. 3
How This Book Is Organized	p. 4
Two Special Skills: Named Ranges and Array Formulas	p. 4
Assigning Names	p. 5
Using Array Formulas	p. 6
Conventions Used in This Book	p. 6
Analyzing Financial Statements
Working with Income Statements	p. 11
Keeping Score	p. 11
Choosing the Right Perspective	p. 12
Defining Two Purposes for Accounting	p. 12
Using the Income Statement	p. 13
Choosing a Reporting Method	p. 13
Measuring the Operating and Nonoperating Segments	p. 17
Moving from the General Journal to the Income Statement	p. 18
Getting the General Journal into Excel	p. 18
Understanding Absolute, Relative, and Mixed References	p. 19
Getting the Journal Data to the Ledger	p. 20
Getting the Ledger Data to the Income Statement	p. 23
Managing the Financial Analyses with Accrual Accounting	p. 24
Organizing with Traditional vs. Contribution Approaches	p. 29
Summary	p. 30
Balance Sheet: Current Assets	p. 31
Designing the Balance Sheet	p. 32
Understanding Balance Sheet Accounts	p. 32
Understanding Debit and Credit Entries	p. 33
Getting a Current Asset Cash Balance	p. 34
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Please wait while the item is added to your bag...

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Business Analysis with Microsoft Excel

Summary

Author Biography

Table of Contents

Supplemental Materials