Financial Information
Business Analysis: Microsoft Excel 2010
This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version.
ANSWER KEY BUSINESS QUESTIONS
CONTROL COMPANY FINANCES
FORECAST SALES
PREPARE BUSINESS CASES
MAKE BETTER INVESTMENT DECISIONS
IMPROVE QUALITY
USE EXCEL 2010 TO GAIN DEEPER INSIGHTS, MAKE SMARTER DECISIONS, AND EARN MORE PROFITS
Using real-world examples, Carlberg helps you put Excel’s features and functions to work and get the power of quantitative analysis behind your management decisions.
Excel expert Conrad Carlberg shows how to use Excel 2010 to perform the core financial tasks every manager and entrepreneur must master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Using real-world examples, Carlberg helps you get the absolute most out of Excel 2010’s newest features and functions. Along the way, you’ll discover the fastest, best ways to handle essential tasks ranging from importing business data to analyzing profitability ratios.
Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions, insider insights, complete step-by-step projects, and more. It’s all complemented by an extraordinary set of web-based resources, from sample journals and ledgers to business forecasting tools.
• Use Excel analysis tools to solve problems throughout the business
• Build and work with income statements and balance sheets
• Value inventories and current assets, and summarize transactions
• Calculate working capital and analyze cash flows
• Move from pro formas to operating budgets that help guide your management decisions
• Prepare business cases incorporating everything from discount rates to margin and contribution analysis
About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel skills, and presents focused tasks and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions
website MrExcel.com, these books will:
• Dramatically increase your productivity–saving you 50 hours a year, or more
• Present proven, creative strategies for solving real-world problems
• Show you how to get great results, no matter how much data you have
• Help you avoid critical mistakes that even experienced users make
Rating: 
(out of 1 reviews)
List Price: $ 31.99
Price:
Review by Tami Brady for Business Analysis: Microsoft Excel 2010
Rating:
Business Analysis: Microsoft Excel 2010 covers two broad accounting topics: management accounting and financial accounting. The first part of the book looks primarily at day to day accounting procedures. This includes a well thought out discussion on whether to use Quick Books or other readymade accounting programs or to use Excel to create your own templates. There are pros and cons on both sides of the issue. It is also possible, if done carefully, to use the best of both.
Following this discussion, the book moves into how to create various schedules, ledgers, and summaries. For those new to the inner workings of accounting, the book explains some key concepts as well as the purposes behind the various forms and calculations. Various examples are used with instructions on the formulas and layouts. There are also lots of illustrations so that you know you are on the right track.
The book transitions to budgeting and planning. This is the part of the process where Excel really shines. It’s so very easy to analyze, manipulate, and reorganize the data in a variety of different ways to not only see where your business is right now but also project how it could grow. Really, it’s about making good business decisions based on fact and knowledge about the inner workings of your company rather than just tossing a coin in the air and hoping you made the right choices.