Skip to Main Content

Excel Tutorial

A helpful guide for students and patrons who are new to Microsoft Excel

How to Enter a Formula in a Cell

In order to start a formula in Excel, you must start by entering "=", and then either select the cell you want to enter into the formula (ex. = A1 + B1) or simply type the numbers.

Common Functions

An image of an Excel worksheet showing different Excel functions

SUM - Adds a range of numbers together and returns the total sum.

AVERAGE - Calculates the mean of a set of numbers.

MAX - Finds the maximum value in a series of numbers

MIN - Find the minimum value in a series of numbers.

COUNT - Counts the number of cells in a range that contains only numerical value.

Vogel Library, Wartburg College   |   100 Wartburg Blvd, Waverly, IA, 50677 |   Phone: 319-352-8500   | Email: asklibrarian@wartburg.edu