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.