Excel for Analytics - Portfolio Project Series Video 2 - Data Cleaning in Excel скачать в хорошем качестве

Excel for Analytics - Portfolio Project Series Video 2 - Data Cleaning in Excel

This is the Excel for Analytics - Portfolio Project Series Video 2 - Data Cleaning in Excel where I'll walk through the data cleaning, or data cleansing process using Excel including a bunch of shortcuts to help make the process easier. If you skipped the first video you can go ahead and download the source file using either of the below two options: 1) Recommended - Head over to https://www.tmbanalytics.com/excel-fo... and drop your name and email in the form and the email will show up right to your inbox in case you need to download again. Going this route will give you exclusive access to TMB Analytics insider discounts on future courses. 2) Head over to Github and download the file from https://github.com/mattbrattin/Excel-... Either way works, it is entirely up to you. 📢 NEW Want my FREE Excel Daily Most Ultimate Guide? Grab it here: https://www.tmbanalytics.com/excel-da... 🫵 Are you ready to take on the 7 Days to Excel Challenge and join the #nomouseclub❓ 👉 Click here if you dare: https://www.tmbanalytics.com/7-days-t... If you're interested in checking out my Free Analytics Career Foundations course you can sign up at www.tmbanalytics.com/freetraining In this second video of the Excel for Analytics - Portfolio Project Series we will cover: 0:00 - Intro + Definition of Data Cleaning and Data Wrangling 2:56 - Creating a new file for iterating 4:45 - Getting familiar with the data file 8:55 - Saving source data for reference and renaming tabs 12:45 - Reviewing the request 17:17 - Quick formatting enhancements 18:03 - Creating data tables 18:41 - Fill down blank rows 21:25 - Reformatting dates and values from text 27:01 - Check for duplicates 29:09 - REMEMBER TO SAVE!!! 31:30 - String lengths and matching using RIGHT, MID, and LEN functions 36:48 - Lookups using XLOOKUP, INDEX/MATCH, and VLOOKUP 38:45 - SUMIFS to summarize values 45:00 - Extracting quarters from dates using two methods 47:15 - VLOOKUP using approximate match for ranges 51:10 - Recap