Description
In this course, you will learn :
- Text-to-Columns - for breaking data into multiple columns.
- Find-Replace - a simple way to get rid of unwanted repetitive data.
- Concatenation - this time we learn how to combine text from multiple columns into one.
- Subtotals - a great grouping and reporting tool.
- Filters - we revisit filters to learn more about how they can greatly improve your data handling and reporting capabilities.
Syllabus :
- A quick primer on the course content
- Text to Columns can be a great data creation tool
- Find_Replace is not just for word processing
- Concatenation is a lot easier to use than to say
- More with the powerful filtering tool
- Subtotals has many great uses