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 Lowell Heddings
Lowell is the founder and CEO of How-To Geek. He’s been running the show since creating the site back in 2006. Over the last decade, Lowell has personally written more than 1000 articles which have been viewed by over 250 million people. Prior to starting How-To Geek, Lowell spent 15 years working in IT doing consulting, cybersecurity, database management, and programming work.
Read Full Bio »