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.