What you'll 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

Description

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

Who this course is for:

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

Homepage: https://www.udemy.com/course/excel-basics-data-text-manipulation/