论Excel的财务分析功能

A Study on Performing Financial Analysis and Prediction with “Excel”

本文结合实例分析与比较了Excel中的财务函数、单变量求解、模拟运算表、方案分析、规划求解等数据分析工具,提出几种用Excel帮助进行财务分析与经济预测的不同方法。

This article proposed several kinds of methods to use Excel to help carries on financial analysis and forecast through the example about financial functions, goal seek, simulated operation table, scenarios analysis, solver and so on.