FREE Workshop | Clean and Prepare Your Data

Pop quiz: How useful is dirty data?

If you answered, "Not at all," you got it right. Now that you’ve got the data basics down, it’s time to clean your data and prepare it for analysis.

This free, 2-hour workshop will teach you best practices for handling null values and cleaning your data, then we’ll dive into basic formulas and functions like Trim, Text, AVERAGE, and COUNT to take your data cleaning skills up a notch.

Make sure to join us for next week where we’ll cover Excel Analytics Basics. You’ll take your freshly cleaned dataset and start to analyze it using popular methods like Pivot Tables and VLOOKUP to find answers to your hypothesis. We’ll see you there.

You’ll leave this workshop knowing:

• Common data cleaning actions like reformatting dates, removing duplicates, and combining data sources
• How to use basic Excel functions and formulas like Trim, Text, AVERAGE, COUNT, and more to get your data ready for analysis

• This is an entry level workshop, so no prior knowledge is necessary.
• You’ll need an Excel account if you are planning to follow-along live. If you don’t have one already, you can sign-up for a Free 1-Month Trial of Microsoft 365
• If anything prevents you from following-along live, the recording will be shared after the series so you can review the content anytime.
• Your mic and camera will be off for the duration of the workshop.
• Interact with your instructor and fellow classmates through the Chat and Q&A.

Candace P. Roberts is the Director of Business Intelligence Vanco Payments in Atlanta, GA. She has spent most of her career in data-related development services including data warehousing, business intelligence, data analysis, database modeling, and data architecture. She has worked in a variety of industries from wholesale/retail, public health, and financial services. Candace has a passion to share her knowledge with others in data analytics arena.

What her students say

Candace Roberts was an excellent instructor. Her enthusiasm was only exceeded by her knowledge of the curriculum. I highly recommend her and would love to take more classes from her. - Student from December 2019

• Candace is the best instructor I have had for a very long time. Engaging, fun, organized, dedicated, approachable. Loved her!* -Student from August 2023