Converting Data into Information Using Excel - Part 2 (Skillshare)

1. Text-to-Columns - for breaking data into multiple columns.

2. Find-Replace - a simple way to get rid of unwanted repetitive data.

3. Concatenation - this time we learn how to combine text from multiple columns into one.

4. Subtotals - a great grouping and reporting tool.

5. Filters - we revisit filters to learn more about how they can greatly improve your data handling and reporting capabilities.

The spreadsheet used in the class is attached in the project section so you can use it as a learning aid.

Project Description

Do your own data project using some of the skills you learned in this course and the first one and I'd be happy to answer any questions you have and make suggestions for improvement.

Alternatively, I invite you to use the attached workbook to do the exercises and return it to me with the word done and any comments or questions you may have.