# 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.

•   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

• Lesson 6
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

• Lesson 10
Use INDIRECT
01:50

• Lesson 11
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

• Lesson 15
SUMPRODUCT
05:39

#### Chapter 14: Course Wrap-Up

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