Excel Basics - Data & Text Manipulation

Excel Basics - Data & Text Manipulation

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

Learn how to quickly & easily cleanse data

Url: View Details

What you will 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

Rating: 4.65625

Level: All Levels

Duration: 1 hour

Instructor: Luis Juarez