Intermediate Microsoft Excel 2007

Duration: 1 day (6 hours)

Prerequisite(s): Introduction to Microsoft Excel 2007 or equivalent experience

Environment: Microsoft Windows

Version(s): Excel 2007. Does not apply to earlier versions.

Support: Upon completion of this seminar, the student will be entitled to unlimited, free telephone support in Microsoft Excel.

Who Should Take This Seminar: Intermediate Microsoft Excel 2007 is designed to enhance the students' knowledge of Microsoft's popular electronic spreadsheet. Students using an earlier version of Microsoft Excel should not enroll in this seminar. Among the topics covered will be proper spreadsheet design, commands which enhance editing the spreadsheet and controlling the output, formula functions, subtotals, using multiple sheets, file linking, sorting, tables, and filters. The student should have taken Systemetrics' Introduction to Microsoft Excel seminar or have equivalent experience, which includes being able to create basic worksheets including text, numbers, and simple formulas, copy and move information, and print a worksheet. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275-2200.

1. Expanding Knowledge of Excel Concepts
1. Finding and replacing data
2. Using alternate methods for selecting, moving, and copying ranges
3. Using Conditional Formatting
4. Using the Subtotal and Outline commands
5. Defining custom AutoFill lists
6. Customizing the Quick Access toolbar
7. using shortcut menus and shortcut keys
2. Using Multiple Worksheets
1. Adding sheets
2. Adding sheets
3. Renaming sheets
4. Moving and copying sheets
5. Moving and copying data between sheets
6. Deleting sheets
7. Hiding and unhiding sheets
8. Changing sheet tab color
9. Writing formulas that refer to cells on other sheets
10. Working with groups of sheets
3. Using File Manipulation
1. Copying/moving information between files
2. Creating and using templates
3. Working with multiple files in memory
4. Establishing links between files
4. Using Advanced Formulas
1. Creating formulas using Functions
2. Using Statistical Functions: SUM, SUMIF, AVERAGE, AVERAGEIF, COUNT, COUNTIF, MAX, MIN, SUBTOTAL
3. Using Special Functions: IF, VLOOKUP
4. Performing date calculations
5. Using text formulas
5. Organizing and Filtering Data
1. Using Excel Tables
2. Sorting data, using single and multiple sort keys
3. Using Filter to locate and retrieve information