Fall Schedule Session

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

Nov 09 2022

1:00 PM - 2:00 PM

Grand Ballroom DEF

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

lightbulb and gear technology icon


Microsoft Office Specialist Master, Instructor, Consultant at Dawn Monroe Consulting

© Diversified Communications. All rights reserved.