Excel Basics - Data & Text Manipulation
Excel Basics - Data & Text Manipulation
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 678 MB
Genre: eLearning Video | Duration: 7 lectures (1 hour, 6 mins) | Language: English
Learn how to quickly & easily cleanse data
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 678 MB
Genre: eLearning Video | Duration: 7 lectures (1 hour, 6 mins) | Language: English
Learn how to quickly & easily cleanse data
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
Excel Basics - Data & Text Manipulation
