May 17-19, 2022 • Dana Point, CA


Spring Schedule Session

Excel Data Clean-up: Sidestep Data List Problems Before They Happen

May 18 2022

1:00 PM - 2:00 PM EDT


Preparing your spreadsheet data before you create charts and reports is an essential step in getting good analysis.  But, data exports from other programs and messy data downloads can be tricky to fix. Learn how to address data list dealbreakers: Dates, Errors, Text, and Duplicates. Real-world examples take you step-by-step through common data problems with solutions that get the job done. 

Learning Objectives

  • Date formats you can rely on
  • How to eliminate errors from function calculations and join or split text
  • Techniques to remove duplicates from your data set
  • Fabulous filters that will slice your tables
  • Validate for goodness sake: data validation that maintains clean data
© Diversified Communications. All rights reserved.