Lunch & Learn

Excel 2003 Tips to Supercharge Your Productivity

Course Length

One hour

Course Description

This demonstration includes more than 40 time-saving 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 multiple lines within a cell
• Use a Screen Tip to display cell contents
• Format headings to ensure proper sorting
• Use the pick list to enter text in a cell
• Add an AutoCorrect entry
• Fill nonadjacent cells with the same entry all at once
• Use AutoFill
• Use the AutoFill shortcut menu
• Reverse the AutoFill action
• Automatically fill down a column
• Select a large range
• Insert a worksheet using a keyboard shortcut
• Move to a different sheet
• Select all sheets
• Select adjacent and nonadjacent sheets
• Select the same range on several sheets
• Work with multiple sheets at the same time
• Display formulas in cells
• Insert cut or copied cells
• Move data without replacing
• Transpose rows and columns
• AutoFit multiple columns or rows
• AutoFit all columns or rows
• Copy formats multiple times
• Add a double underline
• Rotate cell contents
• Name cell(s)
• Move to named cell(s)
• Create names using existing titles
• Insert a range name and paste all range names in a workbook
• Calculate a grand total using the AutoSum button
• Insert a total using a keyboard shortcut
• Use AutoCalculate
• Change the AutoCalculate function
• Enter a natural language formula
• View the range finder
• Jump to or select to the last filled cell
• Create a quick chart on a separate sheet
• Add a picture to the bars of a column chart
• Protect part of a worksheet
• Unprotect an entire worksheet
• Close all open workbooks without exiting Excel
• Open multiple workbooks simultaneously
• Compare workbooks side by side
• Copy sheets between workbooks
• Remove a button from a toolbar

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