Course curriculum

  • 1

    Excel Basics and Best Practices

    • Introduction and Course Overview

    • Navigating Excel with Keyboard Shortcuts

    • Mechanics of Formulas

    • Named Ranges

    • Workbook Organization

  • 2

    Merging Data and Analysis

    • Formatting "Text" Data for Analysis

    • Fun With Lookups and Unique Values

    • An Index+Match Made In Heaven

  • 3

    Conditional Formulas and Formatting

    • Iferror, Countif, and Sumif + Nested Formulas

    • Conditional Formatting

  • 4

    Working WIth Pivot Tables

    • Pivot Table Basics and a Little Something Extra

  • 5

    Wrap-up

    • Excel for Top Consultants_Lesson12vf

  • 6

    Bonus Lessons

    • Excel Payback Period

    • Len Formula

    • Excel Wildcard and SumIfs Video

    • Excel Waterfall

    • Or Function

    • excel-shortcuts-cheatsheet