Microsoft Excel – Cleaning up Excel Data

Product(s): Microsoft Office Excel (all versions).
Audience(s): Business Professional.
Date(s): Friday, December 18, 2009, 1:00PM (EDT) U.S.
Duration: 60 Minutes

Event Overview:

These days, Excel users are doing less data entry and a lot more downloading data from other sources. Whether that data is coming from Access, some other data base software, or a poorly designed Excel worksheet, it isn’t always in the best of shape.
Excel has a variety of functions, commands, and techniques that let you quickly re-structure data, remove unwanted characters, get rid of empty cells, rows, and columns, and prepare data for efficient analysis. This webinar will use Excel 2007, but will demonstrate techniques in Excel 2003 for those features that have been altered.

What you will learn:

The Text to Columns command
* A powerful, yet simple command sequence that lets you quickly split data (improperly grouped into one column) into multiple columns; includes techniques for handling Julian dates another unusual groupings.

How to transpose data
* a simple copy technique to convert data from a row/column into a column/row layout.
How to remove duplicate data
* Use either Excel’s new 2007 command (Remove Duplicates) or the Advanced Filter in Excel 2003 to eliminate duplicate records.

The Find/Replace command sequence, including using special wild cards.

Critical Text functions
* (LEFT, RIGHT, and MID) for character extraction; REPLACE and SUBSTITUTE for character swapping; CLEAN and TRIM functions to remove unwanted characters; PROPER and UPPER for quick uppercase/lowercase conversion.

Concatenation techniques for pulling together data from different locations

Sorting techniques to eliminate blank rows or columns from data

Techniques for learning how to:
* Convert text data to values
* Remove trailing minus signs while converting data into negative values
* Fill in missing title data from columns containing first entries only
* Alter any kind of date data into a more useful computational form

To Register: Click Here.  Fee: $99.00