相關主題
商品描述
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets.
Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including the latest improvements to arrays, formula error handling, and statistics. McFedries' step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate- to advanced-level formula construction, and help you leverage Excel's most useful functions in your everyday work. Becoming an Excel expert has never been easier
By reading this book, you will:
- Improve business analyses by adding intelligence and knowledge to your models
- Replace cumbersome formulas with convenient predefined functions
- Radically simplify complex calculations with Office 365's new dynamic arrays
- Use conditional formatting to reveal anomalies, problems, or opportunities
- Calculate loan payments, interest costs, terms, and amortization schedules
- Project the future value of investments, and plan to achieve investment goals
- Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return
- Sort, filter, and analyze tabular data, from customers to inventory
- Easily analyze huge data sets with PivotTable calculations
About This Book
- For everyone who wants to get more done with Microsoft Excel in less time
- For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
商品描述(中文翻譯)
專家Paul McFedries幫助您掌握Excel 2019和Office 365工具，以建立更強大的試算表。使用Excel 2019和Office 365的核心功能，建立能解決業務問題並提供可靠答案的試算表。借助他無與倫比的經驗，Paul McFedries幫助您充分利用公式和函數，包括陣列、公式錯誤處理和統計學的最新改進。McFedries的逐步項目將引導您完成關鍵任務，從建立時間表到預測現金流和應收帳款。他的實用示例和清晰的指導將揭示中級到高級公式構建的神秘，並幫助您在日常工作中充分利用Excel最有用的功能。成為Excel專家從未如此輕鬆。通過閱讀本書，您將：- 通過為模型添加智能和知識來改進業務分析- 使用方便的預定義函數替換繁瑣的公式- 通過Office 365的新動態陣列徹底簡化複雜計算- 使用條件格式設定揭示異常、問題或機會- 計算貸款支付、利息成本、期限和攤銷表- 預測投資的未來價值，並計劃實現投資目標- 掌握基本的折現和現金流分析工具，包括淨現值和內部收益率- 對表格數據進行排序、篩選和分析，從客戶到庫存- 使用樞紐表計算輕鬆分析大型數據集關於本書- 適用於希望在更短時間內更高效地使用Microsoft Excel的所有人- 適用於商業和金融專業人士、企業家、學生和其他需要高效管理和分析數據的人
