Excellence with Excel – Cleaning Up Data

This video will teach you how to clean up poorly formatted data in Excel – a very common scenario when you’re working with clients in finance.

We support video playback at different speeds in all the lessons on this site. However, your current web browser does not support the technology required for this feature so you can only view this video at normal 1x speed. To use this feature, please use the most recent version of Chrome, Safari, or Internet Explorer.

How to Download Files

  • 1

    Click on the links to
    Download the file

    Download Files and Resources Download this Video
  • 2

    Right click on the link and select 'Save Link As'

    Save link as...

Shortcuts Introduced:

  • Alt + D + E: Text to Columns
  • =TRIM: Remove Extra Spaces
  • =PROPER: Fix Capitalization
  • Alt + E + S + F: Paste Formulas
  • Alt + E + S + V: Paste Values

Note: If you are having trouble with getting the correct values to show up when pasting the =PROPER formula down, press F9 to refresh your worksheet. Also, go to Options (Alt + T + O) and then Formulas in Excel 2007 / 2010 / 2013 or Calculation in Excel 2003 and make sure calculations are set to “Automatic” rather than “Manual.”