Course curriculum

  • 1

    Chap 1: Introduction

    • Introduction

    • 01_Foundations of Data Management - Standard practices and considerations for Excel

    • 02_Managing Data Using Tables

    • 03_Adding a Data Form

    • 04_Data Validation

    • 05_Using Dynamic Drop-Down lists

    • 06_Sorting Data in Tables

    • 07_Using Advance Data Filter
  • 2

    Chap 2: Data Cleaning & Maintenance

    • Introduction

    • 01-What is Bad Data?

    • 02-Getting Rid of Extra Spaces

    • 03-Blank Cells - How to Find, Select, and Treat Them

    • 04-Convert Numbers Stored as Text into Numbers

    • 05-Remove Duplicates

    • 06-Highlight Errors

    • 07-Change Text to Lower/Upper/Proper Case

    • 08-Parse Data Using Text to Column

    • 09-Spell Check

    • 10-Delete All Formatting

    • Practice Challenge Chap1 & 2
  • 3

    Chap 3: Working with Structured Tables

    • Introduction

    • 01-Data Tools: VLOOKUP/HLOOKUP

    • 02-Data Tools INDEX and MATCH

    • 03-Data Tools: IF and nested IF Functions

    • 04-Data Tools: Concatenating Functions

    • 05-Data Tools: SUMPRODUCT
  • 4

    Chap 4: Organizing your Data with Pivot Tables

    • Introduction

    • 1-Sorting Data in a Pivot Table

    • 2-Filters and Advanced Filter

    • 3-Filters and Advanced Filter

    • 4-Creating Pivot Chart

    • 5-Pivot Table Slicer

    • Practice challenge Chap 3 & 4
  • 5

    Chap 5: Working with External Data

    • Introduction

    • 1-Understanding Power Query

    • 2-How To Import Data from Other Workbooks

    • 3-How To Import Data from text or CSV files

    • 4-How To Import Data from PDF Files

    • 5-How To Import Data from the Web/Websites
  • 6

    Chap 6: Building Data Modelling in Excel

    • Introduction

    • 1-Introduction to Data Modelling in Excel

    • 2-Power Pivot's Diagram View

    • 3-Use a Data Model to Create a PivotTable or PivotChart