SEARCH

HOW-TO GEEK SCHOOL

How-To Geek

Microsoft Excel: Formulas and Functions

Geek School

This How-To Geek School class is intended for people who use Excel, or try to use Excel but are intimidated by the concept of formulas and functions. Its objective is to make you an Excel pro, or at least a competent amateur, in just a few lessons.

Lesson 1: Why Do You Need Formulas and Functions?

This How-To Geek School class is intended for people who use Excel, or try to use Excel, but are intimidated by the concept of formulas and functions. Its objective is to make you an Excel pro or at least a competent amateur in just a few lessons.

Lesson 2: Defining and Creating a Formula

In this lesson, we introduce you to basic rules for creating formulas and using functions. We feel one of the best ways to learn is through practice, so we provide several examples and explain them in detail. The topics we will cover include:

Lesson 3: Relative and Absolute Cell Reference, and Formatting

In this lesson we discuss cell references, how to copy or move a formula, and format cells. To begin, let’s clarify what we mean by cell references, which underpin much of the power and versatility of formulas and functions. A concrete grasp on how cell references work will allow you to get the most out of your Excel spreadsheets!

Lesson 4: Useful Functions You Should Get to Know

In this lesson we’ll discuss categories of functions – what they do and various examples – and to illustrate how they work, we’ll show you several example spreadsheets. We encourage you to follow along by creating your own spreadsheets.

Lesson 5: Lookups, Charts, Statistics, and Pivot Tables

Having reviewed basic functions, cell references, and date and time functions, we now dive into some of the more advanced features of Microsoft Excel. We present methods to solve classic problems in finance, sales reports, shipping costs, and statistics.

 

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 02/7/11

Enter Your Email Here to Get Access for Free:

Go check your email!