Start learning with our library of video tutorials taught by experts. Get started

Excel 2007: Introduction to Formulas and Functions
Illustration by Richard Downs

Excel 2007: Introduction to Formulas and Functions

with Curt Frye

Video: Welcome

(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.
Expand all | Collapse all
  1. 1m 39s
    1. Welcome
      1m 6s
    2. Using the exercise files
      33s
  2. 30m 46s
    1. Familiarizing yourself with functions and formulas
      2m 51s
    2. Creating a formula
      5m 36s
    3. Introducing arithmetic operators
      5m 20s
    4. Using cell references in formulas
      5m 19s
    5. Copying and pasting formulas and values
      6m 59s
    6. Editing a formula
      2m 25s
    7. Getting help using Excel functions
      2m 16s
  3. 27m 40s
    1. Creating a SUM or AVERAGE formula
      3m 44s
    2. Creating an AutoSum formula
      2m 49s
    3. Creating MIN, MAX, MEDIAN, and MODE formulas
      2m 54s
    4. Creating formulas to count cells
      3m 19s
    5. Creating formulas to summarize cells conditionally
      9m 5s
    6. Summarizing data on the Status bar
      1m 38s
    7. Rounding cell values up and down
      4m 11s
  4. 39m 56s
    1. Summarizing data using named ranges
      5m 9s
    2. Creating a dynamic named range
      5m 10s
    3. Editing and deleting named ranges
      2m 2s
    4. Summarizing list data by creating subtotals
      5m 27s
    5. Grouping and outlining list data
      2m 14s
    6. Summarizing data using an Excel table
      6m 56s
    7. Referring to Excel table cells in formulas
      3m 54s
    8. Finding data using VLOOKUP and HLOOKUP formulas
      9m 4s
  5. 21m 32s
    1. Importing data into Excel
      2m 51s
    2. Connecting to an external data source
      4m 55s
    3. Cleaning up data imported into Excel
      5m 11s
    4. Creating data validation rules
      5m 55s
    5. Using lists to limit values entered into a cell
      2m 40s
  6. 12m 23s
    1. Managing Excel formula error indicators
      3m 7s
    2. Identifying and tracing errors
      2m 25s
    3. Tracing formula precedents and dependents
      3m 2s
    4. Evaluating Excel formulas step by step
      2m 9s
    5. Watching cell values
      1m 40s
  7. 12m 25s
    1. Creating scenarios and applying them to an Excel worksheet
      3m 5s
    2. Editing, deleting, and summarizing scenarios
      2m 50s
    3. Creating a single-input data table
      2m 0s
    4. Creating a double-input data table
      2m 9s
    5. Finding target values using Goal Seek
      2m 21s
  8. 15s
    1. Goodbye
      15s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Excel 2007: Introduction to Formulas and Functions
2h 26m Intermediate Nov 11, 2009

Viewers: in countries Watching now:

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
Subjects:
Business Spreadsheets
Software:
Excel
Author:
Curt Frye

Welcome

(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.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

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.


Mark all as unwatched Cancel

Congratulations

You have completed Excel 2007: Introduction to Formulas and Functions.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Notes cannot be added for locked videos.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.