Excel Data Cleansing Tip Card

SKU: 316

Qty: - +
   - OR -   

This tip card is used by MCT Anne Walsh in her data cleansing seminar. Topics include:

  • How to remove extra spaces
  • Replace dirty data
  • Get only first N characters from a cell
  • Get just some bits from the middle of a cell
  • Get only the last 4 characters from a cell
  • Convert UPPER or lower case to Proper case
  • These look like dates, but Excel is not seeing them as dates
  • Show which quarter each date is in
  • Someone put all the data together in a cell. How can I break it out?
  • I see numbers. Excel only sees text. How do I make these real numbers?
  • I don't want to see the ugly DIV/0 or #N/A in my formula results
  • My data is in PDF. How do I get it into Excel?
  • Pivoting when months go across
Currently there are no reviews for this product. Share your opinion with others, be the first to write a review.

Add Your Review

Your Name:
Email Address:
Note: HTML is not translated! Your email address will not be shared with anyone.
Your Rating: 5
Your Name:
Your Email:
Friends Name:
Friends Email:
Related Products
SKU: 314
2-Page Lamindated Tip Card for Excel Conditional Formatting. From Anne Walsh and Bill Jelen.
SKU: 315
2-sided laminated tip card explaining Data Validation in Excel.