Excel Basics – Data & Text Manipulation

FREE
Udemy

Note: Udemy FREE coupon codes are valid for maximum 1000 redemption only and might get redeemed in few hours. Look for "GET THIS DEAL" green button at the end of Description.
This post may have affiliate link & we may get small commission if you make a purchase.

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


  • Register New Account
    Reset Password