Excel Basics - Data & Text Manipulation
4.3 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,703 students enrolled

Excel Basics - Data & Text Manipulation

Learn how to quickly & easily cleanse data
4.3 (19 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,703 students enrolled
Created by Luis Juarez
Last updated 11/2019
English
English [Auto-generated]
Current price: $20.99 Original price: $29.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Data manipulation techniques.
  • Formulas to manipulate text such as Upper, Lower, Proper, Left, Right, Mid, Contatenation, Concat, TextJoin
  • Small intro to the use of Pivot Tables
  • How to use the Text To Column feature
  • Delimiters 101 - General versus Text
Requirements
  • Basic working knowledge of Excel
Description

In this course you'll learn how to:

  • Quickly identify and remove duplicate records

  • Break up data using the Text To Column Feature

    • Learn when to use the General & Text format

    • Understand delimiters

  • Understand how to join data from multiple cells using

    • Concatenation

    • Concat

    • Textjoin

  • Learn Text manipulators

    • Left, Right, Mid

    • Upper, Lower, Proper

  • Gain a basic understanding of the Conditional Format feature to identify duplicate records

  • Gain a practical understanding of Pivot Table Basics

  • Learn Page Layout Best Practices

Who this course is for:
  • Beginner level through advance students.
  • Anyone that works with Excel.
  • Anyone in a Business Analyist, Project Manager, Data Entry, Customer Service role, or in Accounting & Finance