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
