Excel "Fast Track"
Content Overview

This seminar will show you how to:

• Save significant time on new projects
• Best handle creation of repetitive projects

• Insert, edit, delete and show/hide cell comments
Print worksheets with headers, footers and comments
• Easily manage worksheet positioning, replication and naming

• Speed up doing copy/cut and paste and examine Paste Special options
• Significantly speed up data entry with Custom Lists and various AutoFill options

• Quickly create or update a group of worksheets to maintain common formats or data
• Quickly jump to special locations in a current worksheet or within another worksheet

• Easily switch between multiple worksheet views for multiple audiences/info needs
• Easily find/replace data within a single worksheet or across multiple sheets

• Quickly generate a chart using a single keystroke and then easily format it

• Understand differences between Charting a table with single and multiple data series

• Do calculations on selected cells or columns without formulas

• Use Functions to save time and avoid worksheet calculation errors
• Locate and use a comprehensive help feature to assist with Function use
• Create formulas that “do not break” through appropriate addressing techniques
• Quickly show/hide all formulas, within a worksheet, to simplify troubleshooting
• Protect formulas from accidental change and limit cell access/tabbing to input cells

• Sort a worksheet on one or more columns, while maintaining database record integrity
• Automatically generate Subtotals for a sorted list, choosing desired calculation method
• Create a Filtered View of data for one or more table columns, using various filter criteria

• Create a Table of Contents worksheet enabling links to the sheets in a workbook
• Include worksheet links to open other files, web pages, or insert a link to send an email

• Use conditional cell formatting to formats cells based on their data values
• Use conditional cell formatting to highlight alternate rows within a data table
• Understand the differences between absolute and conditional cell formatting

• Always view worksheet data, on screen, within the context of row and column headers
• View multiple workbooks on screen, or multiple
worksheets on screen, simultaneously
• Summarize data in a single sheet by linking to details in other sheets or workbooks

• Use Excel's Macro Recorder to save time executing a repetitive task
• Understand the limits of Macro creation based on use of the Macro Recorder

• Save value time when making the move to Excel (and Office) 2007 or 2010

This training can be delivered either as a "Demonstration-based Seminar" or as a "Hands-on Workshop". Either way, a Student Workbook is included, which serves as a useful reference following the training day.

excelsmart.com