Get Digital Help

More than 1300 formula examples

Latest updated articles

Fri March 14, 2025

Customize the ribbon and how to add your macros

Fri March 14, 2025

Highlight unique values in a filtered Excel table

Thu March 13, 2025

Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

Thu March 13, 2025

Prevent duplicate records in a worksheet

Wed March 12, 2025

Working with LIST BOXES (Form Controls)

Wed March 12, 2025

Find numbers closest to sum

Wed March 12, 2025

Compare two columns and extract differences

Wed March 12, 2025

How to add chart elements

Tue March 11, 2025

Excel formula not working

Tue March 11, 2025

Copy data from workbooks in folder and subfolders

Tue March 11, 2025

Working with TEXT BOXES [Form Controls]

Tue March 11, 2025

How to add horizontal line to chart

Tue March 11, 2025

Compatibility Functions

Mon March 10, 2025

How to do tiered calculations in one formula

Mon March 10, 2025

Excel solver examples

Mon March 10, 2025

Calculate machine utilization

Mon March 10, 2025

How to save specific multiple worksheets to a pdf file programmatically

Fri March 07, 2025

How to use the asterisk character

Fri March 07, 2025

How to use the BIN2DEC function

Thu March 06, 2025

Complex Calculations: A Guide to Excel’s IM Functions

Thu March 06, 2025

Engineering functions – D to IMC

Wed March 05, 2025

How to use the SORTBY function

Fri February 28, 2025

How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges

Thu February 27, 2025

Dynamic scoreboard

Thu February 27, 2025

Time sheet for work

Thu February 27, 2025

Build a maze programmatically in Excel

Thu February 27, 2025

How to solve simultaneous linear equations in Excel

Mon February 24, 2025

Working with classic ciphers in Excel

Mon February 24, 2025

Add checkboxes and copy values – VBA

Mon February 24, 2025

Show / hide a picture using a button

Sat February 22, 2025

How to use the PI function

Fri February 21, 2025

How to use the LIKE OPERATOR

Fri February 21, 2025

Populate drop down list with unique distinct values sorted from A to Z

Thu February 20, 2025

Comparing Excel Sorting Techniques: Formulas, Tools, and VBA

Wed February 19, 2025

Auto resize columns as you type

Wed February 19, 2025

Lookup a date in date ranges and get the corresponding value

Tue February 18, 2025

Extract records between two dates

Tue February 18, 2025

How to animate an Excel chart

Tue February 18, 2025

Yet another Excel Calendar

Mon February 17, 2025

Run a macro every time a workbook opens or closes

Mon February 17, 2025

Filter unique distinct records case sensitive

Mon February 17, 2025

How to use the Scroll Bar

Fri February 14, 2025

How to use DIALOG BOXES

Fri February 14, 2025

How to track sector performance in the stock market – Excel template

Thu February 13, 2025

Filter duplicate values based on criteria

Thu February 13, 2025

Excel template: Getting Things Done [VBA]

Wed February 12, 2025

How to use the Subtotal tool

Wed February 12, 2025

How to use the FREQUENCY function

Wed February 05, 2025

How to improve your Excel Chart

Tue February 04, 2025

Excel chart components

Tue February 04, 2025

Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

Mon February 03, 2025

How to use the OFFSET function

Mon February 03, 2025

Filter unique distinct records

Mon February 03, 2025

Extract unique distinct values from a multi-column cell range

Mon February 03, 2025

Sort a column alphabetically

Mon February 03, 2025

5 easy ways to extract Unique Distinct Values

Mon February 03, 2025

Working with unique values

Mon February 03, 2025

Extract a unique distinct list sorted from A to Z

Mon February 03, 2025

Partial match for multiple strings – AND logic

Mon February 03, 2025

Advanced Date Highlighting Techniques in Excel

Mon February 03, 2025

How to highlight duplicate values

Excel categories

Conditonal Formatting

Pivot Tables

VBA

Macros

UDFs