Formulas

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

5 Tips for Formulas in Excel YouTube Thumb 640-2

Formulas, Tips, Tips & Shortcuts

5 Formula Editing Tips for Excel

May 15, 2019

Text to Time Values - Solution 1 and 2 Formulas 640

Formulas

Convert Text to Time Values with Formulas

May 2, 2019

Formulas

How to Handle Vlookup Formula Errors

May 2, 2019

4 Ways to Automatically Sort Drop Down Lists Excel 640

Formulas, Macros & VBA, Power Pivot/Query/BI, Power Query, Tips, Tips & Shortcuts

How to Sort Drop Down Lists Automatically in Excel

February 6, 2019

Formulas

New Excel Features: Dynamic Array Formulas & Spill Ranges

October 3, 2018

3 Tips for Writing Formulas with Macros 640thumb

Formulas, Macros & VBA

3 Tips for Writing Formulas with VBA Macros in Excel

April 2, 2018

Formula Challenge - First Sale Lookup

Formulas, Tips, Tips & Shortcuts

Formula Challenge: Find the First Transaction for Each Month

March 14, 2018

3 Ways to Add Days to Dates Video Thumbnail 640

Formulas, Macros & VBA, Tips, Tips & Shortcuts

3 Ways to Add or Subtract Days to a Date

December 20, 2017

How to Delete Blank Rows 640 YouTube Video Thumb

Formulas, Macros & VBA, Tables & Data, Tips, Tips & Shortcuts

3 Ways to Delete Entire Blank Rows in Excel + Video Tutorial

October 5, 2017