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

Freeze Panes For Fearless Scrolling

June 2, 2016 by terp Leave a Comment

Freeze Panes Eliminates Fear

When you scroll up and down on your worksheet, do you lose sight of your headers?  Do you fear drawing false conclusions because you looked at your data wrong?

Eliminate that fear with Excel’s Freeze Panes.

excel-freeze-panes-video

[Read more…]

Filed Under: Alt Shortcuts, Excel Shortcuts Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts, freeze panes

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