Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Interviews | October 28, 2014

    Jill Owens: IMG Miriam Toews: The Powells.com Interview



    Some people are compelled by a restlessness from within; others are shaped by the unwieldy forces around them. In Miriam Toews's poignant new novel... Continue »

    spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
4 Remote Warehouse Business- Accounting and Finance
6 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Business Analysis: Microsoft Excel 2010 (Mrexcel Library)

by

Business Analysis: Microsoft Excel 2010 (Mrexcel Library) Cover

 

Synopses & Reviews

Publisher Comments:

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

 

 

 

Book News Annotation:

This update reflects shocks to the financial markets as well as changes in Microsoft Excel since the third edition. Focusing on the basic documents and procedures that underlie sound financial planning and management decisions, Carlberg (president, a software-development and consulting firm that specializes in statistical and database applications) introduces Excel's new features--mainly improved capabilities that have been divided among new functions, in analyzing such aspects as financial statements, structuring and testing business cases, valuing inventories, working with QuickBooks balance sheets, and marketing analysis. Trial access to an online edition is included. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

This is the most practical, wide-ranging, and useful guide to using Microsoft Excel 2010 for business analysis. Long-time Excel MVP Conrad Carlberg shows how to use Excel 2010 to gain insight and solve problems in virtually every area of business, from finance and marketing to quality management. Utilizing real-world examples, he demonstrates how to make the most of powerful new Excel 2010 features, including Sparklines, Excel Web App, Slicer, and Excel's new Solver and calculation engine. Writing for managers and professionals in businesses of all sizes, Carlberg covers these and many other topics: " Analyzing revenues, profits, cash flow, fixed assets, inventories, growth, working capital, and more " Forecasting sales through regression and smoothing approaches " Preparing business cases and pro formas that reflect market size/share, opportunity costs, discount rates, profitability, payback times, and contribution and margin analysis " Using Excel's built-in functions to measure product quality, uncover problems, and identify solutions This book will be indispensable for all Excel user who wants to gain a deeper understanding of where their businesses stand financially, and make better decisions about investments and business priorities. This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

 

  • Shows how to use Excel to take total control over company finances
  • Covers everything from financial statements and marketing to investment decision-making and quality management, using real-world examples
  • Demonstrates powerful new features, including Sparklines, Slicer, and the new Solver
  • Part of the new MrExcel's Library series, edited by Excel legend Bill Jelen
  • About the Author

    Conrad Carlberg is president of Network Control Systems, Inc., a software and consulting firm that specializes in the development of quality control and forecasting tools for the health industry. He holds a Ph.D. in statistics from the University of Colorado, and is a multiple recipient of Microsoft's Most Valuable Professional (MVP) award for Excel. He has 25 years' experience applying advanced statistical analysis in business; using these techniques, he reduced a global enterprise's resale inventory from $24 million to $8 million in 18 months, without resorting to writedowns.

    Table of Contents

    I. Financial Statements and Statement Analysis

    1. Working with Income Statements

    2. Balance Sheet: Current Assets

    3. Valuing Inventories for the Balance Sheet

    4. Summarizing Transactions: From the Journals to the Balance Sheet

    5. Working Capital and Cash Flow Analysis

    6. Statement Analysis

    7. Ratio Analysis

     

    II. Financial Planning and Control

    8. Budgeting and Planning Cycle

    9. Forecasting and Projections

    10. Measuring Quality

     

    III. Investment Decisions

    11. Examining a Business Case: Investment

    12. Examining Decision Criteria for a Business Case

    13. Creating a Sensitivity Analysis for a Business Case

    14. Planning Profits

    15. Making Investment Decisions Under Uncertain Conditions

    16. Fixed Assets

     

    IV. Sales and Marketing

    17.  Revenue Recognition and Income Determination

    18. Importing Business Data into Excel

    19. Analyzing Contributions and Margins

    20. Pricing and Costing

    Product Details

    ISBN:
    9780789743176
    Author:
    Carlberg, Conrad
    Publisher:
    Que
    Subject:
    Accounting - Financial
    Subject:
    Business-Accounting and Finance
    Subject:
    Spreadsheets - General
    Edition Description:
    Trade paper
    Series:
    Mrexcel Library
    Publication Date:
    20100631
    Binding:
    TRADE PAPER
    Language:
    English
    Illustrations:
    Y
    Pages:
    528
    Dimensions:
    9.25 x 7 x 1.064 in 828 gr

    Related Subjects


    Business » Accounting and Finance
    Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
    Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

    Business Analysis: Microsoft Excel 2010 (Mrexcel Library) New Trade Paper
    0 stars - 0 reviews
    $39.99 In Stock
    Product details 528 pages Que - English 9780789743176 Reviews:
    "Synopsis" by ,

    This is the most practical, wide-ranging, and useful guide to using Microsoft Excel 2010 for business analysis. Long-time Excel MVP Conrad Carlberg shows how to use Excel 2010 to gain insight and solve problems in virtually every area of business, from finance and marketing to quality management. Utilizing real-world examples, he demonstrates how to make the most of powerful new Excel 2010 features, including Sparklines, Excel Web App, Slicer, and Excel's new Solver and calculation engine. Writing for managers and professionals in businesses of all sizes, Carlberg covers these and many other topics: " Analyzing revenues, profits, cash flow, fixed assets, inventories, growth, working capital, and more " Forecasting sales through regression and smoothing approaches " Preparing business cases and pro formas that reflect market size/share, opportunity costs, discount rates, profitability, payback times, and contribution and margin analysis " Using Excel's built-in functions to measure product quality, uncover problems, and identify solutions This book will be indispensable for all Excel user who wants to gain a deeper understanding of where their businesses stand financially, and make better decisions about investments and business priorities. This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

     

  • Shows how to use Excel to take total control over company finances
  • Covers everything from financial statements and marketing to investment decision-making and quality management, using real-world examples
  • Demonstrates powerful new features, including Sparklines, Slicer, and the new Solver
  • Part of the new MrExcel's Library series, edited by Excel legend Bill Jelen
  • spacer
    spacer
    • back to top

    FOLLOW US ON...

         
    Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.