Excel Help

Practical articles about common Excel formulas, functions and spreadsheet tasks.

Browse by Topic

Lookup & Reference Logical Functions Math & Totals Dates & Time General Excel

Excel Articles

XLOOKUP

Find and return matching values from another row, column or table.

SUMIFS

Add values only when multiple conditions are met.

IF & IF OR

Return different results depending on whether a condition is true or false.

Percentage Calculations

Calculate percentage changes, increases, decreases and proportions.

INDEX & MATCH

Combine INDEX and MATCH for flexible spreadsheet lookups.

Date Calculations

Work with dates, differences between dates and Excel date functions.