Excel Basics Data & Text Manipulation
Sale Page: Click here >>
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 how to join data from multiple cells using
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
Click here for more Trading & Investment Course.