Webinar

Excel 2003 Tips to Supercharge Your Productivity

Course Length

One hour

Course Description

This webinar includes 35 timesaving Excel tips. No matter how long you have used Excel, you will discover shortcuts sure to supercharge your productivity.

Course Topics

• Add color to worksheet tabs

• Create a quick chart
• Jump to or select to the last filled cell
• Transpose rows and columns
• AutoFit multiple columns or rows
• Fill across worksheets
• Sort columns from left to right
• Use the AutoSum button to calculate multiple columns or rows
• Create multiple lines within a cell
• Use a ScreenTip to display cell contents
• Fill nonadjacent cells with the same entry
• Add and remove an AutoCorrect entry
• Move to a different sheet
• Use AutoFill
• Use the AutoFill options button
• Use the fill handle to insert or delete rows or columns
• Automatically fill down a column
• Filter records for unique values
• Select cells with special criteria
• Display or hide formulas in cells
• Insert cut or copied cells
• Move data without replacing
• Add a double underline
• Copy formatting multiple times
• Change the orientation and rotation of cell contents
• Name cell(s)
• Create names using existing titles
• Insert a range name from a list into a formula
• Paste all range names in a workbook
• Search for a function
• Protect part of a worksheet
• Unprotect a worksheet
• Copy page setup
• Paste using Enter
• Print worksheets with consecutive page numbering

[Home   |     Services   |   Courses   |   Instructors  |  References  |  Contact Us]