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.

Lessons

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.

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.

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.

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.