Excel 2007: Introduction to Formulas and 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.
- 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
(Music playing.) 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 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 formal 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.
There are currently no FAQs about Excel 2007: Introduction to Formulas and Functions.
Illustrator CC 2013 One-on-One: Fundamentals1,633,291 Views
Illustrator CC 2013 One-on-One: Mastery286,020 Views
Excel 2013 Essential Training5,659,883 Views
Excel 2007 Essential Training2,801,428 Views
Illustrator CC 2013 One-on-One: Advanced376,037 Views
iOS 8 App Development with Swift 1 Essential Training999,394 Views
Edge Animate Essential Training590,974 Views
Pages 5 Essential Training158,731 Views
Excel 2010 Essential Training5,756,965 Views
Numbers 3 Essential Training137,387 Views