Jump to content

Teacher Experience Exchange

United States - English

Learn and share – exchange lesson plans, tips and questions with other teachers.

null

Microsoft® Excel 2007: intermediate (course)

Microsoft® Excel 2007: intermediate (course)

Take your Microsoft Excel® skills to the next level! Packed with useful tips for the intermediate Excel 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.

2 Ratings

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 3-D ranges in formulas
  • Create custom page headers and footers
  • Apply styles and conditional formatting

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.

Reviews

May 5, 2009

Microsoft Office Excel: advanced; formulas/functions

Great lesson. Learned something new! Thank you!

Sep 3, 2008

Excel Intermediate 2007

Easy to follow and very informative