Applied Microsoft Excel (App-XL) in Statistics, Economics, Business, and Finance Perspective For Microsoft Excel Users and Learners
暫譯: 應用 Microsoft Excel (App-XL) 於統計、經濟學、商業及金融觀點:為 Microsoft Excel 使用者與學習者而設

N. Stephen

相關主題

商品描述

Applied Microsoft Excel (shortly called App-XL) is strictly an application of Spreadsheet tech book with problems applications in the field of Business, Finance, Economics, and Statistical works. The key topics are • Data Analysis and Management tools, • Financial and Investment Analyzes, • Basic Statistics in Economic and Business Application, • Advance Statistics for Data Analysis of Research works, • Resources Optimization with MS Excel, including others. The key FUNCTIONS and TOOLS are: • Pivot Table, and Chart for table data analysis and management, • Solver for Linear Programming, • Analysis Toolpak for advance statistical works, • Basic Statistics tools for Measure of Central Tendency and Dispersion, • Data Analysis with chart, Slope and Intercept for Market Equilibrium Analysis, Finance, and • Investment tools like DDB, SNL, SYD, FV, PMT, IPMT, PPMT, PV, RATE, IRR, and NPV. It is prepared for MS Excel Users (MEUs) and MS Excel Beginners (MEBs). The name "Applied" is associated with the book due to its attribute of personal practical and real world work Applications in Statistics, Economics, Business, and Finance. It is very friendly in use, consists community (i.e. forums) technical support, open to all MEUs and MEBs, and as well been accompanied with App-XL Solution Pack 1.0.0 downloadable zip file.

商品描述(中文翻譯)

《應用微軟 Excel》(簡稱 App-XL)是一部專注於電子表格技術的應用書籍,涵蓋商業、金融、經濟及統計工作的問題應用。主要主題包括:
• 數據分析與管理工具,
• 財務與投資分析,
• 經濟與商業應用中的基本統計,
• 研究工作的數據分析進階統計,
• 使用 MS Excel 進行資源優化,及其他。

主要功能和工具包括:
• 樞紐分析表和圖表,用於表格數據分析與管理,
• 用於線性規劃的求解器(Solver),
• 用於進階統計工作的分析工具包(Analysis Toolpak),
• 用於集中趨勢和離散度測量的基本統計工具,
• 使用圖表、斜率和截距進行市場均衡分析、財務分析的數據分析,
• 投資工具如 DDB、SNL、SYD、FV、PMT、IPMT、PPMT、PV、RATE、IRR 和 NPV。

本書為微軟 Excel 使用者(MEUs)和微軟 Excel 初學者(MEBs)所準備。書名「應用」與本書的特性有關,因其在統計、經濟、商業和金融領域的個人實踐及現實工作應用。該書使用友好,包含社群(即論壇)技術支援,對所有 MEUs 和 MEBs 開放,並附有可下載的 App-XL 解決方案包 1.0.0 壓縮檔。