Locked lesson.
About this lesson
A summary of Keyboard Shortcuts.
Quick reference
Keyboard Shortcuts
Understand the benefits of keyboard shortcuts.
When to use
Working in an Excel document.
Instructions
- The use of keyboard shortcuts can speed up working in Excel. The full list can be viewed in the exercise file.
- An Excel expert is someone who knows 20-30 keyboard shortcuts
- Some handy shortcuts:
- F7 – This will do a spell check on the document. Ensure all sheets are highlighted prior to using this shortcut
- F4 – This has two shortcuts:
- Redo and edit – which will redo the last action performed
- Toggle between the formula to insert a dollar sign for cell referencing – note that for this shortcut to work the formulae bar must be selected
- CTRL + S – This will save the document
- CTRL + C – This will copy the selected cells
- CTRL + V – This will paste the copied cells
- CTRL + Z – This will undo the previous action
- CTRL + F – This will bring up the ‘Find and Replace’ dialog box so that you can search inside the document
- ALT + = – This will sum a range of cells
Login to download
- 00:04 I'm about to talk about layout tips and how to set up a worksheet so
- 00:09 that it works well in a financial model.
- 00:13 Before I do that, I need to talk about one other thing.
- 00:17 The last session was all PowerPoint.
- 00:19 This one is pretty much all Excel.
- 00:22 I want to talk about keyboard shortcuts.
- 00:27 Other people, especially when they're first starting off in Excel,
- 00:30 use the mouse.
- 00:30 It's intuitive, it's useful for things like hyperlinks and placement,
- 00:34 positioning.
- 00:35 Which I think is the same thing as placement most of the time.
- 00:39 Whereas a keyboard can be a way of speeding up working in Excel
- 00:43 if you are that sort of person.
- 00:45 And there's lots of keyboard shortcuts.
- 00:48 The screenshot example here in this slide shows 546,
- 00:52 and that's because by my reckoning, they are presently 546 shortcuts.
- 00:59 Now, here's something you might like.
- 01:01 You may have seen something like this on websites elsewhere but this is, as far as
- 01:06 I can tell, the most comprehensive list of Excel shortcuts in existence.
- 01:11 546 of them to be exact.
- 01:14 Now, not all of these will work on every single machine.
- 01:17 It depends what type of chip you've got, whether you're working with
- 01:20 a personal computer, PC, or a Macbook and what version of Excel you're in.
- 01:25 But you can see here we have all the different keys you can use.
- 01:31 I'm going across.
- 01:32 It might be just pressing the key alone, or the Shift button, or the Ctrl button,
- 01:38 Alt Shift Ctrl, Shift Alt, Ctrl Alt, and Shift Ctrl Alt.
- 01:43 Now not all these combinations have actual assignments.
- 01:48 So, don't get too slighted, there's not trillions of these to actually learn.
- 01:52 But they say an Excel expert is somebody
- 01:54 that knows where an awful lot of these are.
- 01:58 So I've already been through some of these already, in this particular course.
- 02:03 You can see when we're talking about consistency, I used,
- 02:06 if I can find it in here, Ctrl \, this one here.
- 02:09 So Ctrl \ selects unequal cells in rows or columns of selection.
- 02:16 I've already talked about this.
- 02:17 You've got this as something you can refer to.
- 02:19 Treat this as a reference document.
- 02:20 Where you've actually set it up so
- 02:22 it should print out nicely on an A3 piece of paper.
- 02:25 Apologies if you are somewhere in the world where it's letter and not A3, A4.
- 02:30 You can resize it yourself.
- 02:33 Now an easy way to resize print out, we'll talk about printing and
- 02:36 viewing later, is to actually go into page layout, and when you go to page
- 02:41 setup here it's actually determined what paper size you want here.
- 02:45 And you can change your paper sizes in here before you decide to print.
- 02:52 The various ones on here, one your should know, one anyone should know before they
- 02:57 hit Save, this one for instance, Check Spelling.
- 03:00 When was the last time you actually reviewed your model
- 03:03 to see if it actually spell checked?
- 03:06 Well most people won't.
- 03:07 Highlight all the sheets, then hit F7 and away you go.
- 03:10 But there's loads of other ones in here.
- 03:13 F4 is used for function.
- 03:16 It will help you to toggle the dollar signs, as I've shown you previously.
- 03:21 If you're not in the formula bar when you do it though,
- 03:23 it repeats whatever it is you did last which can be a useful feature in itself.
- 03:27 The aim really is to get acquainted with this.
- 03:30 And I will be explaining a lot of these as we go through.
- 03:33 They say an Excel expert is someone who knowns 20 or
- 03:36 30 of these keyboard shortcuts.
- 03:38 So you might want to acquaint yourself as soon as you can.
- 03:41 This leads us nicely though.
- 03:43 That if we've got this to hand,
- 03:44 we can start considering how we're going to layout a model.
Lesson notes are only available for subscribers.