logo

Advanced Techniques Webinar - Cleaning Data in Excel

Advanced Techniques Webinar

$30.00

Messy data slows decisions, creates reporting errors, and undermines credibility. In this 90-minute hands-on session, participants will learn structured, practical techniques for cleaning and standardizing data in Microsoft Excel so it becomes accurate, analysis-ready, and dependable. Moving beyond basic fixes, this program explores powerful tools such as Text to Columns, Flash Fill, Find & Replace with advanced options, TRIM and text functions, Remove Duplicates, Data Validation, conditional formatting for error detection, and more.

This session equips administrative professionals to confidently transform inconsistent, incomplete, or imported data into clean, structured datasets suitable for reporting, dashboards, and executive decision-making.

Participants will learn:

  • Identify common data quality problems such as inconsistent formatting, extra spaces, merged fields, and duplicate entries.

  • Apply Excel tools including Text to Columns, Flash Fill, TRIM, CLEAN, and Find & Replace to standardize data efficiently.

  • Use formulas to correct and restructure text and numeric data.

  • Detect and resolve duplicate or incomplete records using Remove Duplicates and filtering tools.

  • Implement Data Validation techniques to prevent future data-entry errors.

  • Use conditional formatting to surface inconsistencies and hidden issues.

  • Prepare cleaned data for accurate reporting, PivotTables, or dashboard creation.

  • and more!!!

    • Attendees will be provided access to the live webinar as well as access to the recording for 30 days. In addition, a letter can be provided for those on the live session that is suitable for submitting for 1.5 Certified Administrative Professional (CAP) recertification points.

    About the Instructor

    Marie Herman, CAP, OM, ACS, MOS-Expert

    When it comes to career and professional development to help administrative professionals advance, Marie Herman, CAP, OM, ACS, MOS-Expert knows how to take you from where you are, to where you want to be. She has made her career helping others to develop their skills through strategic planning and technology. With certifications as an Microsoft Office Specialist (Master Level) and a Certified Administrative Professional with an Organizational Management specialty, Marie has an expansive knowledge in many areas, and can help you become an expert as well. She is an author, mentor, and expert on a number of computer and professional development topics. Marie is the owner of MRH Enterprises LLC and teaches classes on Microsoft Office, Windows, and various other internet topics. She has been a member of the International Association of Administrative Professionals (IAAP) since 1997 and was a past Division President. She has more than two decades of experience as an administrative professional and efficiency consultant. Marie has helped thousands of students achieve their certification dreams. "

    Student Name
    Preferred Email Address
    "