Excel 2007: Introduction to Formulas and Functions

(upbeat piano music) - Hi, I'm Curt Frye, welcome to Excel 2007, Introduction to Formulas and Functions. In this course, I'll show you how to use formulas and built-in functions to summarize your data effectively. I'll begin by explaining the difference between formulas and functions. Then, using that knowledge as a base, I'll demonstrate how to create formulas that find the sum or average of groups of numbers. I'll also show you how to discover more information by using the Excel help system. We'll enhance your ability to analyze your data by showing you how to summarize cell data that meets conditions you define, round cell values up and down, and summarize your data using named ranges, data lists, and Excel tables.

I'll show you how to find data in your worksheets using lookup functions, create data validation rules to make data entry more accurate, find and fix formula errors, and perform what-if analysis by creating alternative data scenarios that don't disturb your original workbook. In short, I'll show you how to summarize and analyze data using Excel's powerful array of formulas, functions, and other analytical capabilities. Let's get started with Excel 2007, Introduction to Formulas and Functions.