Excel Formulas - The Dirty Dozen

12 Awesome Formulas from MrExcel
Course Created by Bill Jelen
Host of MrExcel.com website. Microsoft MVP in Excel for 10 years. Author of 43 books about Microsoft Excel and a frequent speaker at accounting conferences.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

Learn twelve new Excel functions from Bill "MrExcel" Jelen. This is an intermediate-to-advanced class. Even if you already know IF, SUMIF, and VLOOKUP, this course will broaden your knowledge to some off-the-wall Excel functions that you can use every day to simplify tasks.

Course Objectives

  • Learn VLOOKUP, INDEX, INDIRECT, OFFSET
  • Become more efficient when entering formulas
  • Learn the fast way to filter and total only the visible rows

Who Is This For?

  • If you are comfortable entering basic Excel formulas, this course will power up your use of Excel.
  • Marketing analysts
  • Financial Analysts
  • Anyone working in sales administration or operations.

Course Outline

Chapter 1: Course Introduction

  • Lesson 1
    Welcome
    01:31
  • Lesson 2
    Power Point Deck
    26 slides

Chapter 2: Filter by Selection

  • Lesson 3
    Filter by Selection
    05:57

Chapter 3: Spearing Formulas

  • Lesson 4
    Spearing Formulas
    05:04

Chapter 4: What's the TRUE version of VLOOKUP Used For?

  • Lesson 5
    Using VLOOKUP with a Range
    03:26

Chapter 5: Embed Your Lookup Table in the VLOOKUP Formula

  • Lesson 6
    Embed Your Lookup Table
    04:23

Chapter 6: Sort With a Formula

  • Lesson 7
    Sort with a Formula
    06:54

Chapter 7: Calculate Workdays

  • Lesson 8
    Calculate Workdays
    04:15
  • Lesson 9
    Non-Standard Work Weeks
    03:13

Chapter 8: Use INDIRECT to Always Point to C5

  • Lesson 10
    Use INDIRECT
    01:50

Chapter 9: Create Business Diagrams Populated by Formulas

  • Lesson 11
    Create Business Diagrams
    06:14

Chapter 10: Find the Last Value in a Row or Column

  • Lesson 12
    Find the Last Entry in a Ro…
    03:53

Chapter 11: VLOOKUP between Worksheets

  • Lesson 13
    Lookup Table On Another Sheet
    03:20

Chapter 12: Point to a Variable Range Using INDEX, OFFSET, and INDIRECT

  • Lesson 14
    Variable Range
    06:12

Chapter 13: Master SUMPRODUCT in Excel

  • Lesson 15
    SUMPRODUCT
    05:39

Chapter 14: Course Wrap-Up

  • Lesson 16
    Conclusion
    02:31
  • Lesson 17
    Excel Formulas Tip Card

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)