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