商品描述
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 分析工具解決整個業務中的問題
• 建立並處理損益表和資產負債表
• 評估庫存和流動資產,並總結交易
• 計算營運資金並分析現金流
• 從預算表轉向幫助指導管理決策的營運預算
• 準備商業案例,涵蓋從折現率到利潤和貢獻分析的所有內容