Formulas

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

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

Use AutoSum to Create SUBTOTAL Formulas in Excel

Formulas, Keyboard Shortcuts, Tips & Shortcuts

Create SUBTOTAL Formulas with the AutoSum Button or Keyboard Shortcut

August 16, 2017

How to Create a Random List of Numbers Without Duplicates in Excel

Formulas, Tips, Tips & Shortcuts

How to Create a List of Random Numbers with No Duplicates or Repeats

April 12, 2017

3 Tips for Calculating Week Numbers in Excel - Excel Campus - 640x360

Formulas, Tips, Tips & Shortcuts

3 Tips for Calculating Week Numbers from Dates in Excel

March 14, 2017

Excel SUBTOTAL Function Calculations on Visible Cells of Filtered Range

Formulas

The Excel SUBTOTAL Function – Calculations on Filtered & Visible Cells Only

February 9, 2017