8781  Reviews star_rate star_rate star_rate star_rate star_half
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.

  • 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

Instructor knew her stuff. Long time in the industry. Course was easy to follow and very informative.

I was very pleased with the course setup by ExitCertified and the instructor.

I was very satisfied about how the course was organized. Sean Did a very good work

ExitCertified provided a very organized way to learn and provided materials to follow along.

Easy to work with. Learning material pdfs were able to be printed out in color which was very nice to write on.