Lunch & Learn

Excel 2007 Tips to Supercharge Your Productivity

 

Course Length

One hour

 

Course Description

This demonstration includes more than 50 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
  • Resize the formula bar
  • Use a Screen Tip to display cell contents
  • Fill nonadjacent cells with the same entry
  • Add and remove an AutoCorrect entry
  • Use AutoFill
  • Reverse the AutoFill action
  • Use the fill handle to insert or delete rows or columns
  • Automatically fill down a column
  • AutoSum multiple columns or rows
  • Select a large range
  • Filter records for unique values
  • Remove duplicates
  • Insert a picture to appear as a watermark in the worksheet
  • Move to a different sheet
  • Sort columns from left to right
  • Select all sheets
  • Select adjacent and nonadjacent sheets
  • Customize the Quick Access toolbar
  • Copy page setup
  • Fill across worksheets
  • Print multiple worksheets with consecutive page numbers
  • Select the same range on several sheets
  • Work with multiple sheets at the same time
  • Select cells with special criteria
  • Display/hide formulas in cells
  • View formulas and values side by side
  • Drag and drop cells between sheets in the same workbook
  • Insert cut or copied cells
  • Paste from clipboard using Enter
  • 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
  • Jump to or select to the last filled cell
  • Name cell(s)
  • Move to named cell(s)
  • Create names using existing titles
  • Insert a range name from a list into a formula
  • Paste all range names in a workbook
  • Filter by selection
  • Customize the Status Bar
  • Search for a function
  • Create a quick chart on a separate sheet
  • Protect part of a worksheet
  • Unprotect entire worksheet
  • Open multiple workbooks simultaneously
  • Compare two workbooks side by side
  • Copy sheets between workbooks
  • Pin a file to the recently used file list

   
 

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