Author
Released
11/11/2009- 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
Skill Level Intermediate
Duration
Views
(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.
Related Courses
-
Outlook 2003 Essential Training
with David Rivers5h 45m Beginner -
Access 2003 Essential Training
with Mark Swift4h 55m Beginner -
Excel 2007 Essential Training
with Lorna Daly5h 13m Beginner -
PowerPoint 2007 Essential Training
with David Rivers6h 29m Beginner -
Publisher 2007 Essential Training
with David Rivers5h 47m Beginner -
Visio 2007 Essential Training
with David Rivers8h 55m Intermediate -
Outlook 2007 Essential Training
with Sean Conrad2h 37m Beginner -
Project 2007 Essential Training
with Lorna Daly3h 59m Beginner -
Access 2007 Essential Training
with David Rivers5h 27m Beginner -
SharePoint 2007 Essential Training
with David Rivers7h 48m Beginner -
Getting Started with Apple Color
with Robbie Carman1h 10m Beginner -
Acrobat 9 Pro: Creating Forms
with Brian Wood8h 37m Intermediate -
Acrobat 9 Pro Essential Training
with Brian Wood9h 34m Beginner -
Artist Series with Hillman Curtis
with Hillman Curtis51m 13s Intermediate -
Creative Inspirations: Margo Chase, Graphic Designer
with Margo Chase1h 18m Intermediate -
Margo Chase's Hand-Lettered Poster: Start to Finish
with Margo Chase14m 21s Intermediate -
Creative Inspirations: Ron Crabb, Digital Illustrator
with Ron Crabb1h 25m Intermediate -
Troika's ABC Brand Campaign: Start to Finish
with Troika Design Group21m 32s Intermediate -
CSS Positioning Best Practices
with Bill Weinman2h 32m Intermediate -
Creative Inspirations: Rick Smolan, Photographer
with Rick Smolan1h 19m Intermediate -
Learning GREP with InDesign
with Michael Murphy3h 45m Intermediate -
Mixing and Mastering with Pro Tools
with Brian Lee White9h 18m Intermediate -
Video Journalism: Shooting Techniques
with Jeff Sengstack2h 4m Intermediate -
Premiere Pro: Color Correction and Enhancement
with Jeff Sengstack5h 6m Intermediate -
Excel 2007: Financial Analysis
with Curt Frye2h 18m Intermediate -
Designing a Book Cover
with Nigel French2h 46m Intermediate -
Screencasting with the Mac
with Christopher Breen1h 51m Beginner -
Creative Inspirations: Ze Frank, Comedic Digital Savant
with Ze Frank56m 1s Intermediate -
Excel 2007: Pivot Tables for Data Analysis
with Curt Frye2h 45m Intermediate -
Excel 2007: Introduction to Formulas and Functions
with Curt Frye2h 26m Intermediate -
Windows 7 Essential Training
with David Rivers6h 31m Beginner -
Excel 2007 Power Shortcuts
with Michael Ninness2h 4m Intermediate -
Photo Assignment: Group Shots
with Derrick Story36m 11s Beginner
-
Introduction
-
Welcome1m 6s
-
-
1. Introducing Excel 2007 Functions and Formulas
-
Creating a formula5m 36s
-
Editing a formula2m 25s
-
2. Creating Basic Summary Formulas
-
Creating an AutoSum formula2m 49s
-
3. Sorting and Filtering PivotTable Data
-
4. Preparing Data for Analysis in Excel
-
Importing data into Excel2m 51s
-
-
5. Auditing Worksheet Formulas
-
Watching cell values1m 40s
-
6. Performing What-If Analysis
-
Conclusion
-
Goodbye15s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome