Applied Microsoft Excel (App-XL) in Statistics, Economics, Business, and Finance Perspective For Microsoft Excel Users and Learners

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進行資源優化等。主要功能和工具包括:樞紐表和圖表用於表格數據分析和管理、線性規劃求解器、進階統計工具包、測量中心趨勢和離散度的基本統計工具、使用圖表、斜率和截距進行市場均衡分析、金融和投資工具(如DDB、SNL、SYD、FV、PMT、IPMT、PPMT、PV、RATE、IRR和NPV)。該書針對MS Excel用戶(MEUs)和MS Excel初學者(MEBs)編寫。書名中的「應用」一詞與該書在統計學、經濟學、商業學和金融學中的個人實際應用和現實世界工作相關。該書非常易於使用,提供社區(例如論壇)技術支援,開放給所有MEUs和MEBs使用,並且還附帶了可下載的App-XL解決方案包1.0.0壓縮文件。