bestcourses is supported by learners. When you buy through links on our website, we may earn an affiliate commission. Learn more

Excel Basics - Data & Text Manipulation

Learn how to quickly & easily cleanse data

4.47 / 5.0
2814 students1 hours 6 minutes

Created by Luis Juarez, offered on Udemy

bestcourses score™

Student feedback

5.2/10

To make sure that we score courses properly, we pay a lot of attention to the reviews students leave on courses and how many students are taking a course in the first place. This course has a total of 2814 students which left 50 reviews at an average rating of 4.47, which is average.

Course length

8.6/10

We analyze course length to see if courses cover all important aspects of a topic, taking into account how long the course is compared to the category average. This course has a length of 1 hours 6 minutes, which is pretty short. This might not be a bad thing, but we've found that longer courses are often more detailed & comprehensive. The average course length for this entire category is 5 hours 20 minutes.

Overall score

5.5/10

This course currently has a bestcourses score of 5.5/10, which makes it an average course. Overall, there are probably better courses available for this topic on our platform.

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

What you will 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
Udemy logo
Available on

Udemy

With almost 200,000 courses and close to 50 million students, Udemy is one of the most visited online learning platforms. Popular topics include software development, the digital economy, but also more traditional topics like cooking and music.

Frequently asked questions

  • Price: $19.99
  • Platform: Udemy
  • Language: English
  • 1 hours 6 minutes
Excel Basics - Data & Text Manipulation thumbnail

bestcourses score: 5.5/10

There might be better courses available for this topic.