Excel 2007: Introduction to Formulas and Functions

Demonstrates how to build various arithmetic and statistical analysis formulas and use Excel's built-in functions.Excel 2007: Introduction to Formulas and Functions shows how to build impressive spreadsheets with the application's built-in capabilities. Excel expert and Microsoft Most Valuable Professional Curt Frye shares his vast knowledge of Excel, demonstrating how to build various arithmetic and statistical analysis formulas. Curt explains how to summarize values in sets of cells, create conditional formulas using IF and other related functions, and use validation rules to make data entry more accurate. He even teaches how to search for data within a list or table using the VLOOKUP and HLOOKUP functions. Exercise files accompany this course. Topics include: Copying and pasting the value results of a formula Creating formulas to count cells that meet certain conditions Connecting Excel to an external data source Building a two-input data table Summarizing data using an Excel table