Formulas

Learn how to use functions to write formulas for common tasks like looking up values (VLOOKUP) and summarizing data (SUMIFS).

Formulas

How to Use VLOOKUP to Find the Closest Match – Last Argument is TRUE

April 4, 2015

Answers, Formulas, Modeling, Pivot Tables, Tables & Data

How to Create Dependent Cascading Drop-down Lists

November 18, 2014

Create Concatenate Formula for Range of Cells with Concatenate Macro in Excel

Formulas, Keyboard Shortcuts, Macros & VBA, Tips & Shortcuts, Tools

How To CONCATENATE a Range of Cells + VBA Macro

October 24, 2014

Create Copy of Pivot Table and Convert to SUMIFS Formulas

Formulas, Macros & VBA, Pivot Tables, Tables & Data

Convert Pivot Table to SUMIFS Formulas – Free VBA Macro

October 14, 2014

PowerPivot Instead of VLOOKUP Excel Showdown

Formulas, Pivot Tables, Power Pivot, Power Pivot/Query/BI

How To Use Power Pivot Instead of VLOOKUP

October 6, 2014

Sum Each Column of the Total Row in Excel Table

Answers, Formulas, Tables & Data, Tips, Tips & Shortcuts

How To Sum All Columns in the Total Row of an Excel Table

September 30, 2014

INDEX Function Explained Step Result

Formulas

The INDEX Function – A Road Map For Your Spreadsheet

June 12, 2014

Match Explained Step 3 - Match Type

Formulas

VLOOKUP & MATCH – A Dynamic Duo

May 29, 2014

Excel VLOOKUP Explained at Starbucks 1-2-3

Formulas

VLOOKUP Example Explained at Starbucks

May 13, 2014