Course curriculum

    1. Managing and analyzing data in Excel

    1. The importance of checking data quality

    2. Use the UNIQUE function to investigate data and data quality

    3. Check data quality with a PivotTable

    4. Check for duplicates with formulas

    5. Find duplicates and stray values with Conditional Formatting

    6. Deciding if your data is ready for use

    1. Splitting columns with Flash Fill

    2. Splitting columns with Dynamic Arrays

    3. Splitting columns with Power Query

    4. Splitting columns into rows

    1. Structure data for optimum usage in Excel

    2. The power and majesty of Excels Tables

    3. Using COUNTA to evaluate and monitor your data

    4. Power Query Unpivot

    5. Convert an array to a column with TOCOL

    6. Convert a report to raw useful data

    1. Find and retrieve data with VLOOKUP and XLOOKUP

    2. Import and combine data sets in Power Query

    3. Append data sets

    4. Overview of Power Query joins

    5. Using the Power Query joins feature

    6. Power Query vs XLOOKUP

    1. Sort with multiple criteria

    2. Sort by cell color, font color, or cell icon

    3. Sort by custom list

    4. Sort in Power Query

    5. Use Dynamic Arrays SORT SORTBY

    6. Use the FILTER dynamic array function

    7. Use text numeric and date filters

    8. Filter in Power Query

    9. Filter table data interactively with slicers

About this course

  • Free
  • 38 lessons
  • 3.5 hours of video content

Discover your potential, starting today

Enroll today