0.c Core Excel Operations

OBJECTIVES

  • Learn the importance of sensitivity analysis and how to implement it.
  • Master the core features, operations and short-cuts of Excel required to build common types of simple models.
  • Gain practical experience in building and using models.

DESCRIPTION

  • Overview. This course covers the main functionalities and short-cuts in Excel that are necessary to build models and conduct basic data analysis. These including the cretionand copying of formulas, various short-cuts, the use of named ranges, formatting, and graphics, amongst other topics.
  • Practical work and exercises. Students are required to conduct numerous hands-on modelling exercises and can also follow along by replicating other examples that are shown in the text.
  • Assessment tests. There are several assessment tests which test the key concepts and may require one to do practical exercises in Excel.

KEY TOPICS

  • Excel functionality and core operations. Copy, paste, insert, delete, undo. Using Find/Replace in modelling and data analysis. Wildcard characters. GoTo and GoTo Special. Efficient selection of ranges. Navigation around a model. Short-cuts and KeyTips.
  • Named ranges. Use in formulas and model navigation. Advantages and disadvantages.
  • Formatting and graphics. General formatting. Conditional formatting. Custom formatting. Principles of effective visual communication. Using graphs and charts in Excel.

Scroll to Top