Business Analysis with Microsoft Excel, 5th edition

Published by Que Publishing (December 17, 2018) © 2019

  • Conrad Carlberg

VitalSource eTextbook

$44.05 AUD

Price Reduced From: $48.95 AUD

Permanently unavailable
ISBN-13: 9780134862552
Business Analysis with Microsoft Excel
Published 2018

Access details

  • Digital eBook
  • Instant access
  • Available online, offline and via apps
  • Accessible through the VitalSource Bookshelf

Features

  • Crystal-clear instructions
  • Make highlights and notes
  • Listen as the Bookshelf reads to you
  • Search across the eBook content

Becoming an Excel expert has never been easier

Business analysis expert Conrad Carlberg shows you how to use Excel to perform core financial tasks all managers and entrepreneurs need to master: analysing 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.

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.

  • Introduction
  • Part I: Analyzing Financial Statements
  • Chapter 2: Power BI: An Overview
  • Chapter 3: Balance Sheet: Current Assets
  • Chapter 4: Valuing Inventories for the Balance Sheet
  • Chapter 5: Summarizing Transactions: From the Journals to the Balance Sheet
  • Chapter 6: Working Capital and Cash Flow Analysis
  • Chapter 7: Statement Analysis
  • Chapter 8: Ratio Analysis
  • PART II Financial Planning and Control
  • Chapter 9: Budgeting and Planning Cycle
  • Chapter 10: Forecasting and Projections
  • Chapter 11: Measuring Quality
  • PART III Investment Decisions
  • Chapter 12: Examining a Business Case: Investment
  • Chapter 13: Examining Decision Criteria for a Business Case
  • Chapter 14: Creating a Sensitivity Analysis for a Business Case
  • Chapter 15: Planning Profits
  • Chapter 16: Making Investment Decisions Under Uncertain Conditions
  • Chapter 17: Fixed Assets
  • PART IV Sales and Production Analysis
  • Chapter 18: Importing Business Data into Excel
  • Chapter 19: Exporting Business Data from Excel
  • Chapter 20: Using Excel 2016 and Power BI to Analyze QuickBooks Data
  • Chapter 21: Analyzing Contributions and Margins
  • Chapter 22: Pricing and Costing

Need help? Get in touch