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

Find & Replace Excel Shortcuts

March 15, 2016 by terp Leave a Comment

What’s A Good Use For Find And Replace In Excel?

Find and Replace can be a great way to clean up data in Excel.  For example:

  • To remove all # signs, replace # with nothing
  • To remove all blanks, replace ” ” (a blank) with nothing
  • To remove all dashes and everything after them, replace “-*” with nothing (the * serves as a wildcard)
  • To remove all dashes and everything before them, replace “*-” with nothing

If you only want to clean up one column, just select that column first.  The same thing if you only want to clean up one block of cells (just select the block of cells first).

The “replace with nothing” technique, for some reason, isn’t widely written about.  I don’t recall reading about it anywhere, so may be I should patent it…  It can save you a ton of time.

What Are Some Good Find And Replace Excel Shortcuts?

Here are three good shortcuts.  The first two default to the Find tab.

Find & Replace Dialog Box – On “Find” Tab (keyboard #1): Ctrl+F

Find & Replace Dialog Box – On “Find” Tab (keyboard #2): Alt-E-E

[Read more…]

Filed Under: Alt Shortcuts, Excel Shortcuts, Find & Replace, Find And Replace, Keyboard Shortcuts Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts, Find & Replace

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