Business analysis with Microsoft Excel

Summary:

It's time to put the full power of Excel quantitative analysis behind your management decisions! Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers and entrepreneurs need to master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Carlberg helps you make the most of Excel's tools and features in everything from business case development to cash flow analysis. Becoming an Excel expert has never been easier. You'll find crystal-clear instructions, real-world examples, insider insights, step-by-step projects, and much more. It's all complemented by extensive web-based resources, from sample journals and ledgers to business forecasting tools.

Record details

ISBN: 0789759586
ISBN: 9780789759580
Physical Description: xiii, 562 pages : illustrations ; 24 cm
Edition: Fifth edition.
Publisher: [New York] : Que : [2019]
Copyright: ©2019

Content descriptions

General Note:

Includes index.

Formatted Contents Note:

Working with income statements -- Balance sheet : current assets -- Valuing inventories for the balance sheet -- Summarizing transactions : from the journals to the balance sheet -- Working capital and cash flow analysis -- Statement analysis -- Ratio analysis -- Budgeting and planning cycle -- Forecasting and projections -- Measuring quality -- Examining a business case : investment -- Examining decision criteria for a business case -- Creating a sensitivity analysis for a business case -- Planning profits -- Making investment decisions under uncertain conditions -- Fixed assets -- Importing business data into Excel -- Exporting business data from Excel -- Using Excel 2016 and Power bI to analyze QuickBooks data -- Analyzing contributions and margins -- Pricing and costing.