Intermediate Microsoft Excel

Duration: 1 day (6 hours)

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

Environment: Microsoft Windows

Version(s): All through Excel 2003. Taught using Excel 2003.

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 is designed to enhance the students' knowledge of Microsoft's popular electronic spreadsheet. Among the topics covered will be proper spreadsheet design, menu options which enhance editing the spreadsheet and controlling the output, functions, subtotals, using multiple sheets, file manipulation, file linking, sorting, database features, enhanced file operations, and a brief introduction to macros. 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. Using Advanced Spreadsheet Concepts
1. Working with multiple sheets
2. Finding and replacing data
3. Using alternate methods for selecting, moving, and copying ranges
4. Applying styles
5. Using the subtotal and outline commands
6. Establishing default workbook settings for headers, footers, formats, etc.
7. Defining custom AutoFill lists
8. Customizing toolbars
2. 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
5. Managing files within the "Open" and "Save As" dialog boxes
3. Using Advanced Formulas
1. Creating formulas using functions
2. Using Statistical Functions: SUM, AVERAGE, MAX, MIN, SUBTOTAL
3. Using Special Functions: IF, VLOOKUP
4. Using the Database Functions to analyze data
5. Performing date calculations
6. Using text formulas
7. Writing formulas that span sheets
4. Creating And Using An Excel Database
1. Creating a database
2. Maintaining a database by using a data form
3. Sorting data using single and multiple sort keys
4. Using AutoFilter to locate information
5. Creating And Using Macros
1. Excel macros and Visual Basic for Applications
2. Recording, editing and running macros