Webinar

Excel 2007 Tips to Supercharge Your Productivity

Course Length

One hour

Course Description

This webinar includes more than 40 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
• Filter by selection
• Jump to or select to the last filled cell
• Transpose rows and columns
• AutoFit multiple columns or rows
• Fill across worksheets
• Customize the Quick Access toolbar
• Sort columns from left to right
• Use the AutoSum button to calculate multiple columns or rows
• Create multiple lines within a cell
• Resize the Formula Bar
• 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
• Remove duplicates
• Insert a picture as a watermark
• 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
• Customize the Status Bar
• Search for a function
• Protect part of a worksheet
• Unprotect a worksheet
• Pin a file to the Recent Documents list
• Copy page setup
• Paste using Enter
• Print worksheets with consecutive page numbering

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