01 - Introduction
02 - 1. Checking Data Quality
-
02 - Use the UNIQUE function to investigate data and data quality (5:54)
-
02 - Use the UNIQUE function to investigate data and data quality (5:54)
-
02 - Use the UNIQUE function to investigate data and data quality (5:54)
-
01 - The importance of checking data quality (5:22)
-
01 - The importance of checking data quality (5:22)
-
01 - The importance of checking data quality (5:22)
-
03 - Check data quality with a PivotTable (4:45)
-
03 - Check data quality with a PivotTable (4:45)
-
03 - Check data quality with a PivotTable (4:45)
-
04 - Check for duplicates with formulas (4:49)
-
04 - Check for duplicates with formulas
-
04 - Check for duplicates with formulas (4:49)
-
05 - Find duplicates and stray values with Conditional Formatting (6:57)
-
05 - Find duplicates and stray values with Conditional Formatting (6:57)
-
05 - Find duplicates and stray values with Conditional Formatting (6:57)
-
06 - Deciding if your data is ready for use (1:53)
-
06 - Deciding if your data is ready for use (1:53)
03 - 2. Splitting Columns for Data Clean-Up
04 - 3. Data Preparation
05 - 4. Working with Multiple Data Sets
06 - 5. Sorting and Filtering Data
-
01 - Sort with multiple criteria (2:40)
-
02 - Sort by cell color, font color, or cell icon (6:42)
-
03 - Sort by custom list (1:36)
-
04 - Sort in Power Query (3:02)
-
05 - Use Dynamic Arrays SORT, SORTBY (5:40)
-
06 - Use the FILTER dynamic array function (4:20)
-
07 - Use text, numeric, and date filters (8:27)
-
08 - Filter in Power Query (5:56)
-
09 - Filter table data interactively with slicers (6:35)
07 - 6. Other Data Analysis Tools and Methods
08 - Conclusion
Ex_Files_Excel_Managing_and_Analyzing_Data
