Home > Store

Business Analysis with Microsoft Excel and Power BI, 5th Edition

Business Analysis with Microsoft Excel and Power BI, 5th Edition

eBook (Watermarked)

  • Your Price: $28.79
  • List Price: $35.99
  • Estimated Release: Aug 25, 2018
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2019
  • Dimensions: 7" x 9-1/8"
  • Pages: 528
  • Edition: 5th
  • eBook (Watermarked)
  • ISBN-10: 0-13-486250-3
  • ISBN-13: 978-0-13-486250-7

USE EXCEL 2016 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 2016 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 2016’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

Sample Content

Table of Contents

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

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership