Created by Luis Juarez | Last updated 11/2019
Duration: 1 h | Video: h264, 1280x720 | Audio: AAC, 44 KHz, 2 Ch | 678 MB
Genre: eLearning | Language: English + Sub | 7 lectures
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
Basic working knowledge of Excel
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
DOWNLOAD
uploadgig
rapidgator
nitroflare
Feel free to post your Excel Basics - Data & Text Manipulation Free Download, torrent, subtitles, free download, quality, NFO, Dangerous Excel Basics - Data & Text Manipulation Torrent Download, free premium downloads movie, game, mp3 download, crack, serial, keygen.