How-to Excel

Functions Math

SUM Function

Learn how to use the SUM function in Excel with Inside Excel’s step-by-step guide, examples, and practice exercises.

Read More SUM Function
Functions Statistical

AVERAGE Function

Learn how to use the AVERAGE function in Excel with Inside Excel’s step-by-step guide, examples, and practice exercises.

Read More AVERAGE Function
Functions Lookup and Reference

VLOOKUP Function

Learn how to use the VLOOKUP function in Excel with Inside Excel’s step-by-step guide, examples, and practice exercises.

Read More VLOOKUP Function
Conditional Aggregation Functions

SUMIF Function

Learn how to use the SUMIF function in Excel with Inside Excel’s step-by-step guide, examples, and practice exercises.

Read More SUMIF Function