European Investment Bank
Mark Woolhouse introduces you to some core Excel Skills. These are essential if you want to be able to produce your own models in an efficient way. Excel is very intuitive and easy to use – if you can do arithmetic you can write simple formulae in Excel. Many users however never get shown how to go beyond using Excel as a basic calculator and only “survive” in Excel rather than thrive. The techniques we demonstrate will help inexperienced users solve more complex modelling problems in Excel. We’ll show you how to plan and set up your workbook for ease of use; how to use shortcuts to speed you up; how to use $s and names to allow you to “bulk-code”, i.e. write one formula to use across a whole row, column or range; and how to solve logical problems in Excel. We hope to make you fast, efficient, and reliable as you work in Excel and so give you an “easy life” when using Excel.