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.
Here’s my FREE one-hour course: Basic Excel Shortcuts For 11 Everyday Tasks: Get 65% Faster
I’ll teach you 16 basic Excel shortcuts to get 65% faster at 11 everyday tasks: Save, Copy, Paste, Cut, Undo, Redo, Bold, Italics, Underline, Find and Replace.
I’ll also show you how to memorize shortcuts — plus some neat tricks to make Excel remind you what the shortcuts are.
If you’re slow at Excel and want to become more productive, this course is custom made for you! It’s easy to follow, and you only need to be a beginner in Excel.
The course has 9 lectures.
Get 65% faster at basic Excel tasks — in less than an hour!
Sign up now — before it’s no longer free!
Find and Replace can be a great way to clean up data in Excel. For example:
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.
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