Project 3: Data Cleaning for Collection Analysis
Let’s learn methods to clean up data so that it’s easier to combine with other data. For this project, we’ll focus on Excel functions for cleaning and re-structuring data. We will then combine data from more than one data source. We’ll continue building on our skills with functions so that they perform more of our work for us, more quickly. We may look at other tools that work well with Excel.
What we'll learn or review: import text file data; Text to Columns; functions: Left(), Right(), Concat(), Clean(), Trim(), If(); basic Power Query, Power Query M functions: Text.Start, Text.End.
