Excel Basics – Data & Text Manipulation

Learn how to quickly & easily cleanse data

Created by: Luis Juarez
Excel Geek

What Will I 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

Target audience

• 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