Skip to content
Excel Learning Hub
  • Courses
  • Lessons
  • Formulas
  • Shortcuts
  • Templates
  • Projects
  • Quizzes
Start Learning
Start Learning
  1. Home
  2. Excel Formulas

Excel Formula Library

Look up any Excel function — syntax, a real example, and when to use it.

All Date & Time Information Logical Lookup & Reference Math Statistical Text

AVERAGE

Calculates the arithmetic mean of a range of numbers.

Beginner Math
View formula →

MEDIAN

Returns the middle value in a set of numbers — half the values are above it, half below.

Beginner Math
View formula →

ROUND

Rounds a number to a specified number of digits.

Beginner Math
View formula →

ROUNDDOWN

Rounds a number down, toward zero, to a specified number of digits.

Beginner Math
View formula →

ROUNDUP

Rounds a number up, away from zero, to a specified number of digits.

Beginner Math
View formula →

SEQUENCE

Generates a list of sequential numbers, spilling automatically into a range of the size you specify.

Advanced Math
View formula →

SUM

Adds all the numbers in a range of cells.

Beginner Math
View formula →

SUMPRODUCT

Multiplies corresponding elements across one or more ranges, then adds up the results.

Advanced Math
View formula →

Excel Learning Hub

Learn Microsoft Excel step by step — lessons, formulas, shortcuts, and real-world projects.

Learn

  • Beginner Excel
  • Intermediate Excel
  • Advanced Excel
  • Excel Lessons

Resources

  • Excel Formulas
  • Excel Shortcuts
  • Excel Templates
  • Excel Projects
  • Excel Quizzes

Website

  • About
  • Contact
  • Privacy Policy
  • Terms

© 2026 Excel Learning Hub. All rights reserved.