Microsoft® Excel 2007: intermediate

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

Prerequisites

• An understanding of Excel's basic features including: entering and editing data, using formulas and functions and formatting.

Lessons

1. Microsoft Excel tutorial: functions
2. Microsoft Excel tutorial: working with multiple worksheets
3. Microsoft Excel tutorial: finding, sorting and filtering data
4. Microsoft Excel tutorial: advanced formatting