Business Analysis with Microsoft Excel and Power BI (5th Edition)

Conrad Carlberg

  • 出版商: QUE
  • 出版日期: 2019-03-22
  • 售價: $1,670
  • 貴賓價: 9.5$1,587
  • 語言: 英文
  • 頁數: 528
  • 裝訂: Paperback
  • ISBN: 0789759586
  • ISBN-13: 9780789759580
  • 相關分類: ExcelPower BI
  • 無法訂購

商品描述

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

商品描述(中文翻譯)

使用 Excel 2016 獲得更深入的洞察力,做出更明智的決策,並獲得更多利潤

使用真實案例,Carlberg 帶領您運用 Excel 的功能和函數,將量化分析的力量應用於管理決策中。

Excel 專家 Conrad Carlberg 展示如何使用 Excel 2016 執行每位經理和企業家必須掌握的核心財務任務:分析報表、規劃和控制公司財務、做出投資決策以及管理銷售和市場營銷。使用真實案例,Carlberg 幫助您充分利用 Excel 2016 的最新功能。在此過程中,您將發現處理從導入業務數據到分析盈利能力比率等重要任務的最快、最佳方法。

成為 Excel 專家從未如此輕鬆!您將找到清晰明確的指示、內部見解、完整的逐步項目等。所有這些都得到了一套非凡的基於網絡的資源的補充,從樣本日記和分類帳到商業預測工具。

• 使用 Excel 分析工具解決業務中的問題
• 建立和處理損益表和資產負債表
• 評估存貨和流動資產,並總結交易
• 計算營運資本並分析現金流
• 從預算到操作預算,幫助指導您的管理決策
• 準備商業案例,包括從折扣率到利潤和貢獻分析的所有內容