Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

12 Basic Excel Data Analysis Shortcuts

September 14, 2016 by terp 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…]

Filed Under: Alt Shortcuts, Charts, Find & Replace, Keyboard Shortcuts, Save, Sort Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts, Filter, Find & Replace, freeze panes

Excel Shortcuts To Send As Attachment: Excel 2013 vs. Excel 2010

May 24, 2016 by terp Leave a Comment

Excel 2010 Was Easier To Send As Attachment

Excel 2010 had a fast way to save and send a file as an email attachment: Alt-F-D-A.  It was quick and easy, using only the left hand.

excel-2010-save-and-send-as-attachment-alt-f-d-a

But The 2013 File Tab Reorganization Killed It

In Excel 2013, this great send-as-attachment shortcut has unfortunately morphed into a more difficult one — Alt-F-H-E-A — as shown below.  It’s more letters, plus you need your right hand to type “H” (or you can drift your left hand over).  If your hands are always on the keyboard, this won’t matter as much.  But I prefer keeping my right hand on the mouse (not the keyboard).

excel-2013-save-and-send-attachment-alt-f-h-e-a

Conclusion

The the Send As Attachment shortcut is about 1-2 seconds slower in Excel 2013 than Excel 2010.

Here are the shortcuts:

Send As Attachment (Excel 2010): Alt-F-D-A

Send As Attachment (Excel 2013): Alt-F-H-E-A

Keep learning shortcuts — you’ll get faster at Excel!

 

***Learn how to discover thousands of Alt shortcuts like the ones above.

Filed Under: Email, Save, Uncategorized Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts

Excel Shortcuts To Open, Close & Save Workbooks

February 29, 2016 by terp Leave a Comment

Here’s a quick look at three sets of Excel shortcuts for (1) opening, (2) closing and (3) saving workbooks.

Excel Shortcuts For Opening Workbooks

Open Workbook (keyboard): Ctrl+O (this requires the right hand but I’m unaware of any left-hand only shortcut)

Ctrl+O works fine, but there’s a faster way if you’re opening a file that you recently had open (which, for me, is 95% of the time).  Using this method, you can avoid wading through directories, thus saving some time.  What is this method?  Simple: go to the list of Recent Workbooks on the File tab, as shown below:

excel-open-recent-files

Luckily, the shortcut to get there is a quick left-hander (after you type it in, you can either just click on the file name as it appears in the list, or type in the keyboard accelerator — e.g., “Y1” or “Y2”):

Open Recent Files (keyboard): Alt-F-R

[Read more…]

Filed Under: Alt Shortcuts, Excel Shortcuts, Save Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts

4 Excel Shortcut Myths Debunked

January 5, 2016 by terp Leave a Comment

Why are Excel shortcut myths dangerous?

Why, you ask?  Because Excel is the most popular business software ever in the world (hundreds of millions of users), and probably the most important.  If you are in the business world, you need to know Excel, and the faster you can be at Excel (e.g., with shortcuts), the faster your business (or your part of it) will run.  The faster you and your business can run, the more successful you will be.  This means: promotions, pay increases and greater job satisfaction.  Being fast at Excel makes you more valuable as employee, which increases your upward mobility on the pay scale.  All kinds of new possibilities are opened up for such magnificent people.

If you decide to put off learning shortcuts, then you are putting off advancing your career.  Therefore, any myths and misconceptions that keep you from learning shortcuts are dangerous to your career.  Multiply this by several hundred million people and you’re hindering the global economy!!!  You are in fact decreasing the total amount of cosmic happiness!!!  These myths are dangerous indeed!  They are nearly as dangerous and misguided as the ancient practice of bloodletting (see below).  Bloodletting is as smart as avoiding Excel shortcuts.  See, these evil men below are simultaneously bleeding the naked guy in the chair and telling him Excel shortcuts are bad for his health.

L0003183 Bloodletting, 16th Century Credit: Wellcome Library, London. Wellcome Images images@wellcome.ac.uk http://wellcomeimages.org Patient sitting in a chair with an attendant holding a bowl between his legs to catch blood from the open wound in his stomach. Two others in attendance. 16th Century Feldbuch der Wundartzney Gersdorf, Hans von Published: 1540 Copyrighted work available under Creative Commons Attribution only licence CC BY 4.0 http://creativecommons.org/licenses/by/4.0/
L0003183 Bloodletting, 16th Century
Credit: Wellcome Library, London. Wellcome Images
images@wellcome.ac.uk
http://wellcomeimages.org
Patient sitting in a chair with an attendant holding a bowl between his legs to catch blood from the open wound in his stomach. Two others in attendance.
16th Century Feldbuch der Wundartzney
Gersdorf, Hans von
Published: 1540
Copyrighted work available under Creative Commons Attribution only licence CC BY 4.0 http://creativecommons.org/licenses/by/4.0/

[Read more…]

Filed Under: Excel Shortcuts, Paste Special, Save Tagged With: Excel Keyboard Shortcuts, Excel Shortcuts, Hybrid Shortcuts, Paste Special, Quick Access Toolbar - QAT

Top 12 High Frequency Excel Shortcuts Using The Ctrl Key

December 16, 2015 by terp Leave a Comment

The 12 Excel Ctrl Shortcuts I Use Most

Here are my favorite Excel Ctrl shortcuts — those I use most frequently, but in no particular order.  They’re my fave’s because they’re so easy on the hands.  Nine of the 12 can be executed with the left hand.  For these nine, your right hand can remain comfortably on the mouse, relaxing in a hot tub.  I’ll explain why I include the other three at the end of the post.

Cut, Copy & Paste

Ctrl+C: Copy (see more on Excel shortcuts for Save, Cut, Copy, Paste and Bold here)

Ctrl+V: Paste (see more on Excel shortcuts for Save, Cut, Copy, Paste and Bold here)

Ctrl+X: Cut (see more on Excel shortcuts for Save, Cut, Copy, Paste and Bold here)

Undo & Redo

Ctrl+Z: Undo

Ctrl+Y: Redo [Read more…]

Filed Under: Cut Copy Paste, Excel Shortcuts, Format Cells, Navigation Shortcuts, Save Tagged With: cut copy paste, Excel Keyboard Shortcuts, Excel Shortcuts, Format Cells, Formatting, save, Selection and Navigation

  • 1
  • 2
  • Next Page »

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel