Faster At Excel

5 Quick Data Set Up Excel Shortcuts

by Leave a Comment

Excel Shortcuts For Data Set Up

Watch the 15-second video below to see if you can figure out the 5 shortcuts I used to set up the data for easier use  This is something you can do easily in 15 seconds any time you get a new data file that begins in A1 with a header row in row 1.  (Alternatively, you can also create a Table with Ctrl+T — which will do much of the same, but much more — and maybe some features and formatting you don’t want).

See if you can do it in under 15 seconds.

Scroll down for my solution.

Here are the tasks (starting point is cell D8):

  1. bold top row
  2. freeze top row
  3. add filters

CLICK ON THE GRAPHIC TO BEGIN THE 15-SECOND VIDEO CLIP

excel-shortcuts-data-set-up-gif

 

[Read more…]

12 Basic Excel Data Analysis Shortcuts

by Leave a Comment

Easy Shortcuts For Excel Data Analysis

Below are 17 steps I take with fresh data, along with the shortcuts I use.

12 deal directly with data analysis; the other 5 are generic.

If you do a lot of Excel data analysis, these shortcuts will help you fly through your work much faster.  Consider them arrows in your quiver.

 

excel-data-analysis-shortcuts

[Read more…]

Excel Sort Shortcuts With Alt Key & Menu Key

by 2 Comments

Fast Excel Shortcuts For Sorting — Using the Alt Key

In an earlier post I talked about some Excel Sort Shortcuts using the Right-Click or Context Menu.

Here I’ll talk about some really fast Sort shortcuts using the Alt key, or “keyboard accelerators” or “key tips.”  As a bonus, I’ll reveal some fast ones using the Menu Key as well.

Below is a brief video showing you how fast these shortcuts are:

[Read more…]

Excel Zoom Shortcuts

by Leave a Comment

 What Good Is Zooming In Excel?

(1) it helps confirm that you’ve selected everything you want to select (important with big selections where you’re using Ctrl+A or Ctrl+Shift+End).  Zooming out will show you clearly whether you’ve omitted anything.  In other words: it can save your @$$.

(2) it helps your eyes when you’re in the office until 11pm for the fourth straight night

(3) it helps you share your screen with someone standing behind you

(4) you tell me…

So here are some shortcuts so you can zoom faster in Excel.

 

Three Excel Zoom Shortcuts (Actually, Four)

Fastest: Ctrl+mouse-scroll — in other words, press the Ctrl key and (while it’s pressed) roll your mouse wheel forwards/backwards.  This will zoom you in and out, and you can see exactly how far (what %) you are zoomed in/out by looking at the Zoom Slider at the bottom right of Excel (see picture below).  It doesn’t get much easier than this.  You get to keep your hand on the mouse.  I call this a “hybrid shortcut” since you’re using both mouse and keyboard in one shortcut.

excel-zoom-slider [Read more…]

4 Shortcuts To Delete Excel Worksheets

by Leave a Comment

4 Easy Ways To Delete Excel Worksheets

Below are four different shortcuts to delete Excel worksheets.  The second one is the fastest, and hence my favorite.

(1) Right-clicking: RC-<Delete> while hovering over the tab.  You’ll see the following when right-clicking over the tab — just click on Delete:

excel-delete-worksheet

(2) Hybrid shortcut: RC-D (Right-Click, followed by typing ‘D’).  This does the same thing as RC-<Delete>, except you’re using the hot key instead of clicking.  The ‘D’ is underlined in Delete, which means you can just type ‘D’ instead of clicking on Delete.  I call this a “hybrid” shortcut since it combines mouse and keyboard into one shortcut.  This is the fastest (typing ‘D’ is faster than clicking on ‘Delete’). [Read more…]