Welcome to our course on Excel shortcuts. You’ve made a great decision to learn more shortcuts. Excel shortcuts are extremely powerful and they can really upgrade your skills in Excel. In fact, I’ve got 6 good reasons that Excel shortcuts they’re totally worth your time:

  1. Shortcuts allow you to work faster and more accurately in Excel
  2. Shortcuts really save you sanity you have to do a lot of tedious, repetitive work
  3. Shortcuts allow you to focus on the work, and not on Excel’s complicated interface.
  4. Shortcuts give you excellent tools to work with Big Data.
  5. Shortcuts allow to really leverage Excel and use the program more intelligently
  6. Probably the most important reason of all, Excel shortcuts make Excel a lot more fun.. Trust me, if you use Excel a lot, learning shortcuts will make the experience much more enjoyable. In fact, I really believe that there is nothing you can do that will save you more time and aggravation in Excel, both today and in the long run, than learning shortcuts. So let’s get started.  First, Excel has hundreds of dedicated shortcuts, that you can use for an amazingly wide range of actions. You can use shortcuts do things like select and delete rows and columns, apply number formatting, Autosum, fill in data, toggle references, reveal formulas, and many, many other actions. Dedicated shortcuts in Excel are organized around the function keys at the keyboard, and around the shift, control, and alt keys. On Windows, the ribbon provides another huge layer of shortcuts. By using  “accelerator keys”, you can drive the ribbon using only your keyboard to perform almost any command in Excel. You might wonder if you should focus first on dedicated shortcuts or ribbon shortcuts? In general, I recommend you start with dedicated shortcuts. Then, once you feel comfortable with shortcuts in Excel, you add in ribbon shortcuts to handle tasks that don’t have their own dedicated shortcut. For more information about the ribbon, see the Ribbon Shortcuts video in this course. Finally, let me give you a quick overview on how this course is structured, and what references we make available to help you learn Excel shortcuts. The videos in this course are organized in sections, and each video covers shortcuts related to a specific area or topic. For easy reference, each video begins and ends with the shortcuts covered in the video. Whenever we use a shortcut, we’ll show both the Windows and Mac shortcut. The Windows shortcut in green, and Mac shortcut in blue. Like any other skill, shortcuts require practice. Each video contains a link to a practice worksheet. Make sure you download this worksheet, and practice the shortcuts you want to learn. If you really want to master shortcuts in Excel, this is the most important thing you need to do. Finally, if you use Excel on a Mac, make sure watch the “Excel shortcuts on the Mac” video for a quick orientation.  

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.