Computer Training: Microsoft Office Pro Training: Excel Productivity Booster
Back to List of Computer Training Courses
Microsoft Excel 2003 - Productivity Booster
Course Length: 6 hours (9 a.m. - 4 p.m.)
Prerequisites: Using Microsoft Office Excel Level 2 or equivalent experience
Course Overview
The Using Microsoft Office Excel 2003 Productivity Boosters course covers a number of shortcuts, tips, and features that can help you work more efficiently with your worksheets. Topics include:
Keyboard shortcuts
Navigating documents
Quickly move to sheets
Using Names
Using Hyperlinks
Viewing documents
Freeze row headings
Split a window
Compare side by side
Save arranged workspaces
Using custom views
Entering Data
Automatic wrap to next line
Change Enter key direction
Data validation
Custom lists
Text to Columns command
Join values in a cell
Sort to reorder columns
Finding and Filtering Data
Go To Special command
Find matching data
Find matching formats
Find and replace data and formats
Using AutoFilter
Using Advanced Filters
Formatting Worksheets
Shortcut to apply borders
Create custom borders
Apply Autoformats
Clear formatting
Format Painter
Apply special number formats
Create and apply custom formats
Formulas and Functions
Quickly total rows and columns
Add Subtotals to lists
Show all formulas in cells
Hide formulas and prevent editing
Formula Auditing toolbar
Text functions
Other useful functions
Page Layout and Printing
Fit more data on a page Print row headings on each page
Print row and column indicators
Print cell errors as blanks
Insert/move/delete manual page breaks
Layout/Preview/Print multiple pages
Charts
Shortcut to create a column chart
Select different objects on a chart
Add more data to a chart
Change the series order
Change the gap width and overlap
Add and format a trendline
Using fill effects
Create a custom chart template
Macros
Record macros
Attach to a custom toolbar button
