Excel Basics - Data & Text Manipulation
Learn how to quickly & easily cleanse data
Excel Basics - Data & Text Manipulation free download
Learn how to quickly & easily cleanse data
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
