|
via Udemy |
Go to Course: https://www.udemy.com/course/excel-basics-data-text-manipulation/
In this course you'll learn how to:Quickly identify and remove duplicate recordsBreak up data using the Text To Column FeatureLearn when to use the General & Text format Understand delimitersUnderstand how to join data from multiple cells usingConcatenationConcatTextjoinLearn Text manipulatorsLeft, Right, MidUpper, Lower, ProperGain a basic understanding of the Conditional Format feature to identify duplicate recordsGain a practical understanding of Pivot Table BasicsLearn Page Layout Best Practices