Excel Basics - Data & Text Manipulation

• 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

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