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
Created by Luis Juarez, offered on Udemy
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.
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.
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.
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 how to join data from multiple cells using
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
- Basic working knowledge of Excel