Course curriculum

  • 1

    Introduction

    • Course Introduction - Data Analysis in Excel

    • Learning Objectives

    • Downloadable Files
  • 2

    Analyze Data

    • Chapter Introduction - Analyze Data in Excel

    • Sorting & Filtering

    • Conditional Formatting

    • Conditional Logic - IF() & SWITCH()

    • Conditional Logic - IF() & IFS()

    • SUMPRODUCT() Function

    • Defining Variables - LET()

    • Defining Functions - LAMBDA()

    • Chapter Review - Analyze Data in Excel
  • 3

    Transform Data

    • Chapter Introduction - Transform Data in Excel

    • Text to Columns

    • Removing Duplicate Values

    • String Functions for Text Values

    • Working with Date Values

    • Looking Up Data - VLOOKUP()

    • Using HLOOKUP() with VLOOKUP()

    • Looking Up Data - INDEX() & MATCH()

    • Dealing with Errors - IFNA() & IFERROR()

    • Chapter Review - Transform Data in Excel
  • 4

    Excel Tables

    • Chapter Introduction - Excel Tables

    • Excel Tables

    • Calculated Columns in Excel Tables

    • Special Item Specifiers in Excel Tables

    • Power Query - Introduction

    • Power Query - Filtered Table

    • Power Query - Group & Aggregate Data

    • Linked Data Types

    • Expand Power Query Data with Linked Data Types

    • Linked Data Types as a Power Query Source

    • Chapter Review - Excel Tables
  • 5

    Dynamic Arrays

    • Chapter Introduction - Dynamic Arrays

    • Dynamic Array Formulas

    • Dynamic Array Functions

    • Combining Dynamic Arrays & Excel Functions

    • Looking Up Data - XLOOKUP()

    • Chapter Review - Dynamic Arrays
  • 6

    Pivot Tables

    • Chapter Introduction - Pivot Tables

    • Summarize Data with a PivotTable

    • Update & Sort a PivotTable

    • PivotTable Analyze Options

    • PivotTable Design Options

    • Filtering with Slicers & Timelines

    • Pivot Charts

    • Analyze Data - Ideas in Excel

    • Power Pivot

    • Chapter Review - Pivot Tables
  • 7

    Visualize Data

    • Excel_C6L01_Chapter Introduction - Visualize Data in Excel

    • Excel_C6L02_Excel Visuals

    • Excel_C6L05_Net Earnings Waterfall

    • Excel_C6L04_Dashboard Preview

    • Excel_C6L03_Excel Visuals Continued

    • Excel_C6L06_Combo Chart - Cash Flow & Cash Balance

    • Excel_C6L07_Bullet Chart - Introduction

    • Excel_C6L08_Creating Bullet Chart

    • Excel_C6L09_Formatting Bullet Chart

    • Excel_C6L10_Setting up Data Table for Bullet Chart

    • Excel_C6L11_Excel vs Dashboard Tools

    • Excel_C6L12_Chapter Review - Visualize Data in Excel
  • 8

    Course Summary

    • Excel_C7L01_Course Summary - Data Analysis in Excel
  • 9

    New Chapter

    • Qualified Assessment

    • Share Your Feedback

    • Course Completion