Principles of Financial Modelling

CHAPTER 27Selected Short-cuts and Other Features

INTRODUCTION

This chapter presents a list of the key short-cuts that the author has found to be the most useful. Most of these are self-evident once they have been practised several times, so that only a few screen-clips are shown to demonstrate specific examples. The mastering of short-cuts can improve efficiency and speed of working. Therefore, each modeller should develop a good familiarity with those short-cuts that will be most relevant to them, and have a general understanding of the wider set available should they be useful in specific circumstances. It is worth noting that some of the short-cuts become particularly relevant when recording VBA code, as they allow to capture the code for operations that would not otherwise be evident. There are of course short-cuts available in Excel that are not covered in this chapter, and the reader may conduct his or her own research in this regard, perhaps using the list in this chapter as an initial check-list. The chapter also briefly mentions some of the Excel KeyTips, as well as some other potentially useful tools, such as Sparklines and the Camera.

KEY SHORT-CUTS AND THEIR USES

The key short-cuts we cover are structured into their main categories of application:

• Entering and modifying data and formulae.
• Formatting.
• Auditing, navigation and other items.

Note that, on a UK keyboard, some of these short-cuts (such as Ctrl+&) would require one to use the Shift key to access the ...