What You'll Learn

In this course, Edrian Martin, CLDP - The Back Room's Job Coaching Supervisor, serves as your subject matter expert who will guide you on how to maximize Excel's features in cleaning large sets of data, covering the following topics:

  • Changing the case of a text & removing extra spaces

  • Finding the length of a text & converting numbers stored as text

  • Adding a chart inside a cell & keeping and adding missing zeros

  • Combining text using ampersand & using wildcard character

  • Replacing cell color format & text to columns

  • Incorrectly formatted dates & Left, Right and Mid

Course Content

    1. Introduction

    2. Learning Content

    1. Knowledge Check

    2. Feedback

    3. Before You Go

About this course

  • Free
  • 5 lessons
  • 2 hours of video content

What Our Students Say

Ready to unlock your next career opportunity?

Join the team that frees up accountants to do their best work, while you do yours. We're hiring!

Apply Now