Formulas

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

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

Calculate Percentage Change with Negative Numbers

Formulas

Calculate Percentage Change for Negative Numbers in Excel

August 1, 2016

Percentage Change Formula Creator Macro for Excel

Formulas, Macros & VBA

How to Quickly Create Percentage Change Formulas with a Macro

July 12, 2016

How to add leading zeros padding to a list of uneven values in Excel

Formulas

How to Add Leading Zeros to Numbers or Text with Uneven Lengths

May 4, 2016

Get Name of Day from Date in Excel

Formulas

3 Ways to Get the Day Name for a Date

April 5, 2016

Overview of Dates in Excel 640x360 Youtube Video Thumb

Formulas

How Dates Work in Excel – The Calendar System Explained + Video

January 26, 2016

COUNTIF Function Explained - Counts the Number of Cells that Contain a Matching Value in a Range

Formulas

How to use the COUNTIF Function Instead of VLOOKUP + Video

January 12, 2016