microsoft partner logo color
8736  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

Course Description

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.

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.

Read Less

Course Details

Course Details

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

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

I registered a day before class and am happy that I received all the materials and links in time for the class. Thanks.

It was very informative and covered all the required materials along with handson labs for practice.

Very good couse and again we would like to see more videos on removing FRUs

Exit certified was great as it is very in depth and hands on learning which made it very easy to learn this type of work.

Great training it covered the most importan topics if GitHub copilot with good explanation and good labs.