How to clean messy data in Excel скачать в хорошем качестве

How to clean messy data in Excel

Cleaning messy data in Excel is both an art and a science. Often the same cells contain multiple types of information that need to be separated, you have garbage information to remove, or columns contain a mix of different things. Here I go through three examples of messy spreadsheets, showing some of the methods I use to fix them. If you have data you want me to clean in a future video, email steve [at] rockstarexcel.com. If you have spreadsheets you need cleaned that are confidential or more extensive than can be done in a video, Rockstar Excel offers our services at a reasonable rate. Resources: Learn more about filters:    • Filters - Excel's Easy button   How to standardize names:    • How to Standardize Names in Excel   Using & (ampersand) to join text strings:    • Never use Concatenate - Use an Ampersand i...   Rockstar Excel website: https://rockstarexcel.com/ Upcoming courses: https://rockstarexcel.com/courses-and... Book a free consultation to learn how we can save you time and money: https://rockstarexcel.com/book-a-free... Sign up for our newsletter for free Excel tips in your inbox: https://rockstarexcel.com/newsletter/ Ask a question to be answered in a future video: https://rockstarexcel.com/submit-your... External links: Table Capture Chrome plugin: https://chrome.google.com/webstore/de... Original data sources: Fantasy Pros: https://www.fantasypros.com/nfl/ranki... Yahoo Sports: https://football.fantasysports.yahoo.... ESPN: https://fantasy.espn.com/football/pla... Thumbnail art by Clker-Free-Vector-Images from Pixabay