microsoft partner logo color
8545  Reviews star_rate star_rate star_rate star_rate star_half

Data Cleanup with Excel

This Microsoft Excel Data Cleanup training course teaches attendees how to clean data in Excel using Text to Columns, text case formatting, Flash Fill, and more. Participants also learn how to...

Read More
By Request
Contact Us For Pricing
Duration 4 hours
Course Code OFC-117
Available Formats Classroom

Overview

This Microsoft Excel Data Cleanup training course teaches attendees how to clean data in Excel using Text to Columns, text case formatting, Flash Fill, and more. Participants also learn how to automate data cleanup using Power Query.

Skills Gained

  • Use techniques for data transformation
  • Master Excel's Text to Columns feature
  • Use Flash Fill effectively
  • Create macros to automate data cleanup tasks
  • Learn the basics of Power Query

Prerequisites

All students must have some familiarity with Excel.

Course Details

Training Materials

All Excel training attendees receive a short reference handout covering the topics in the class.

Software Requirements

All attendees need a full installation of Office 365, including Excel.

Outline

  • Introduction
    • The importance of efficient data cleanup
  • Text to Columns
    • Understanding and using the Text to Columns feature
    • Splitting and organizing data effectively
  • Flash Fill
    • Introducing and utilizing Flash Fill
    • Automatic pattern recognition for data entry
  • Macro Recording
    • Basics of macro recording in Excel
    • Automating repetitive data cleanup tasks
  • Power Query Introduction
    • Overview of Power Query functionality
    • Importing, cleaning, and transforming data using Power Query
  • Conclusion
    • Recap of key points
    • Q&A and troubleshooting
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information
Ascendient Learning would like to occasionally share news about our services and career opportunities via e-mail when we believe it would be relevant to you. Would you like to opt-in to these communications? You may withdraw your consent at any time using the opt-out/preferences link in the emails sent.

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

Good training material and good instruction. More time needs to be provided for the lab work.

This was a good program to get prepared for the solutions architect associate exam.

Course was great and the instructor had an answer for anything that was asked during the course.

This course gave me a clearer understanding of the AWS cloud architecture.

Great class I learned a great deal from the material. There would seem to a large amount that I need to learn about.