Excel: Introduction to Formulas and Functions (2023)

To unlock the power of Excel, you need to use formulas and functions. These calculation tools help you bring information to the surface and make better decisions. Excel: Introduction to Formulas and Functions shows beginner-level users how to summarize and analyze data with these powerful data analysis features. Instructor Curt Frye shows how to create formulas with mathematical operations such as addition, subtraction, multiplication, and division, and how to use cell references in your formulas. He explains how to summarize data with functions like SUM and AVERAGE, and work with data in named ranges and Excel tables. Curt also covers procedures to ensure data integrity, such as data validation, and demonstrates auditing techniques to ensure formulas are correct.

Note: This course was recorded on Excel for Microsoft 365. Most of the course contents will also be useful to those working with the most recent standalone versions of Office, including Office 2021.

Learning objectives
Define “formula.”
Identify three comparison operators.
Name two keys used to end editing mode in a cell.
Recall the key used to open the Help pane in Excel.
Recognize a valid time range in the Subtotal dialog box.
Determine which formula would calculate the sum of a Sales column in a Sales Data table.
Identify the file type that can be opened directly into Excel.
Explain how to enable Flash Fill.
Summarize the purpose of a precedent in a formula.