Introduction

Excel has many powerful features for Business Analysts. This section contains many practical exercises and examples concerning Excel.

One of the common Excel applications is keeping track of requirements, either lists of requirements or information concerning requirements, or other tabular information.

Tools for managing requirements in order of increasing sophistication:

• Word processor (e.g. Word)

  • (tables with lists of requirements and/or hyperlinked documents)

• Spreadsheet (e.g. Excel)

  • (worksheets with lists of requirements and/or hyperlinked documents)

• Requirements management application (e.g. Requisite Pro, Blueprint)

Other common uses of Excel include structuring all sorts of information in tabular format.

Therefore, it is very useful to be proficient in using Excel (and other spreadsheet / tabulation tool).

All this may be surprising if you consider Excel to be mainly a tool for complex numerical computation such as financial planning, analysis, charting, and statistical work.