Essentials of Excel: Structure, Formulas and Functions

This Chapter provides some practical aspects of Excel, especially for any readers who may be new to modelling in Excel. It covers:

  • The basic structure of Excel.
  • How to enter text and data.
  • How to create formulas using arithmetic.
  • How to create calculations using functions.
  • How to translate relationships between items into formulas in Excel.
  • How to audit formulas, and trace logical dependencies and precedents.
  • Simple ways to detect and correct errors.

Scroll to Top