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

First I save the file with a name (instead of just Book1 or whatever useless name it has):

1. Save As: Alt-F-A

 

Read more about Alt shortcuts.

Read about Excel shortcuts to select ranges of data.

 

Then I prep it so it’s easier to work with.

2. Freeze Top Row: Alt-W-F-R

3. Bold: Ctrl+B (I do this on the top row)

4. Add Filters: Alt-A-T

—- or —-

5. Create Table: Ctrl+T (or Ctrl+L)

 

Now, once I start working with the data, here are some other shortcuts I use:

6. Clear Filter: Alt-A-C

7. Sort A-Z: Alt-A-S-A (“A” is for Ascending)

8. Sort Z-A: Alt-A-S-D (“D” is for Descending)

9. Sort Alt-A-S-S: (“S” is for Sort)

10. Remove Duplicates: Alt-A-M

11.Text-To-Columns: Alt-A-E

12. Delete Columns/Rows: RC-D (after selecting column/row) (RC = Right-Click)

 

If I need to strip out some recurring strings of data, I do a Find and Replace.  I find “string” and replace with “” (nothing).

13. Find/Replace: Ctrl+F, enter Find string, then Alt-P, enter Replace value, then Alt-A to replace all

 

If I’m charting:

14. Add Chart To Same Tab: Alt-F1

15. Add Chart To New Tab: F11

 

When I’m done:

16. Save: Ctrl+S

17. Close Workbook: Ctrl+W

 

 

Speak up if I’m missing any other great Excel data analysis shortcuts!

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

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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