Home > Excel Topics > Formulas

Excel Formula & Function Topics

Debra Dalgleish - Contextures

Use Excel formulas and functions to summarize data, return values from a lookup table, do mathmatical calculations, and much more!

compare FILTER and INDEX/MATCH

✅ Note: To see full list of Excel functions, visit the Excel Functions List page.

Video: Split Date and Time

In the short video below, I shows the steps to split date and time, and a problem that you might run into. There are written steps on the Split Date and Time page.

Excel Function Examples

These sample file examples show how to use some of the most popular Excel functions.

FN0075

PIVOTBY Function Examples -- See how the new Excel PIVOTBY function works, and test the settings for optional arguments, such as how to sort the data, and where to show totals.
Excel File: excelpivotbyfunction.zip
Tutorial: PIVOTBY Function Examples page
FN0067

Spill Formula Examples -- Examples show how to use Excel's spill functions (Microsoft 365), on the worksheet, and in VBA. Thanks to Dermot Balson
Excel File: spillformulaexample_db.zip
Tutorial: Excel Spill Function Examples
FN0068

Bingo Card 1 to 100 -- The RAND function creates sets of 3 unique Bingo cards in this Excel template
Excel File: bingocards100.zip
Instructions: Create Bingo Cards in Excel

Explore Formula & Function Topics

Lookup Functions
Text Functions
Date Functions
Statistical Functions
Math Trig Functions
Logical Functions
Information Functions
Engineering Functions

Get Monthly Excel Tips!

Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.

Next, when you get my reply, please click the Confirm button. I add this step to protect you from spam!

Explore Excel Topics

Data
Pivot Tables
Data Validation
Formulas and Functions
Macros
Charts
Formatting
Filters

 

 

Excel Functions List

 

Last updated: June 10, 2026 4:18 PM