The iLearn program will end on 11/30/2009. If you are currently enrolled in a course, you can still access it by logging in and clicking on My courses until then. Thank you for your participation.

iLearn

Intermediate Microsoft® Excel 2007

Intermediate Microsoft® Excel 2007

Take your Microsoft® Excel skills to the next level! Packed with useful tips on Microsoft Excel for the intermediate user, this course explains how to get the results you want from Excel formulas and functions, how to find data more easily with sorts and filters, how to manage multi-sheet workbooks, how to apply page formatting such as headers and footers, and much more.

63 Ratings

There are currently no sessions for this course.

Notify me when a new session opens.

iLearn

iLearn courses are free, practical, led by expert instructors, and available around the clock to work with your schedule.

Take A Tour

Lessons

Lesson 1: Microsoft Excel Tutorial: Functions

Microsoft Excel offers hundreds of functions; in this lesson, you'll try the most useful ones and learn how to get help with others you might need. You'll also explore absolute cell referencing and its role in formula copying.

Lesson 2: Microsoft Excel Tutorial: Working with Multiple Worksheets

A Microsoft Excel workbook is more than just a single sheet. In this lesson, you'll go 3-D and learn how to use multiple sheets, name and format sheet tabs, and create formula and function references to cells on multiple sheets.

Lesson 3: Microsoft Excel Tutorial: Finding, Sorting, and Filtering Data

Long lists of data can be intimidating, but Microsoft Excel has excellent sorting and filtering capabilities to help bring that data under control. This Microsoft Excel tutorial shows you several strategies for finding and organizing data.

Lesson 4: Microsoft Excel Tutorial: Advanced Formatting

In this lesson, you'll learn powerful formatting skills, such as styles, custom headers and footers, and conditional formatting, for making your Microsoft Excel workbooks the best they can be.

What You'll Learn

  • Learn to select the appropriate formula or function for the task at hand
  • Create formulas that include absolute references and named ranges
  • Sort data by single or multiple columns
  • Filter data by single or multiple criteria via examples and forms
  • Manage a multisheet workbook and refer to 3D ranges in formulas
  • Create custom page headers and footers
  • Apply styles and conditional formatting

Other Courses

  • None

Take A Tour!

Learn how courses work in five quick and easy steps!

Give Us Feedback

Tell us what you think about iLearn courses.

Tell a Friend

Tell your friends about iLearn courses.

Find an Answer

Got a question about the site? Find out here.