Your cart is empty.
Keep shopping
Excel Basics - Data & Text Manipulation
4,426 students
Excel Basics - Data & Text Manipulation
Learn how to quickly & easily cleanse data
Created byLuis Juarez
Last updated 11/2019
English
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
Explore related topics
Course content
7 sections • 7 lectures • 1h 6m total length
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