4.4  29 reviews on Udemy

Excel Basics - Data & Text Manipulation

Learn how to quickly & easily cleanse data
Course from Udemy
 2709 students enrolled
 en
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

Excel Basics - Data & Text Manipulation
$ 19.99
per course
Also check at

FAQs About "Excel Basics - Data & Text Manipulation"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK