Free Excel Webinar Recording – Mouse Shortcuts

Feedback score 93%

When I ran some face to face training sessions recently I was reminded how much people LOVE shortcuts. I did a keyboard shortcut webinar session in October 2018.

In November 2018 I shared lots of mouse shortcuts. Download the materials using the button below and watch the video.

Webinar Materials

Some of the topics and techniques you will learn include:

  • the various cursor shapes and how to use them correctly
  • right clicking options you may not know exist
  • copying anything quickly with the mouse, even sheets
  • drawing perfect circles and squares
  • lining up charts and other shapes perfectly
  • cool techniques with the Fill Handle
  • something you may never have tried with the right mouse button
  • using the the Office clipboard
  • a trick to use the Series dialog

This session will demonstrate lots of techniques using the mouse and also using the mouse with the keyboard.

Even if you prefer using the keyboard you might learn a few useful new techniques.

Free Excel Webinar Recording – Keyboard Shortcuts

Feedback score 93%

When I ran some face to face training sessions recently I was reminded how much people LOVE keyboard shortcuts. So I decided to update my keyboard shortcut webinar.

In October 2018 I shared lots of keyboard shortcuts. Download the materials using the button below and watch the video.

Webinar Materials

Using the mouse isn’t always the quickest way to perform tasks in Excel. Keyboard shortcuts can speed up your work and save you hunting through screens and dialogs. Some of the keyboard shortcuts you will learn in this session are:

  • wrap text and other useful formats
  • applying row and column grouping
  • selecting a table quickly
  • copying visible cells only
  • apply and remove Freeze Panes
  • returning after following a hyperlink
  • how to avoid an annoying feature of formula and reference dialogs when you press an arrow key to move around
  • get the most out of the Tab key

There will be lots of other shortcuts as well. Even if you prefer using the mouse you might learn a few useful new techniques.

Techniques to Paste Values in Excel

Lose the formulas and keep the values

Sometimes in Excel you need to paste just the values from copied cells. You don’t want the formulas. You may have created temporary formulas that you need to replace with their values. You may need to capture the current values, make some changes and then compare the new values with their old values to see the difference.

Excel Data and Formula Entry Tips

Speeding up data entry

There are number of shortcuts you can use to speed up your data and formula entry in Excel.

Number keypad

Use the number keypad on the right of the keyboard. This has all the numbers, as well as most of the formula operators (+  * –  /), you need to create formulas. It also has a large Enter key. The numbers are laid out like a calculator and so are easy to use.

Excel Alt key shortcuts

Keyboard shortcuts rule

The ALT key (there’s one on either side of your Spacebar) has some really useful shortcuts. See if they can save you some time and effort. These can be handy if, like me, you sometimes struggle with your laptop’s built-in mouse controller and you don’t have your external mouse handy. And remember most keyboard shortcuts work in all versions of Excel.