Course Length
Three hours
Prerequisites
Excel 2007 Introduction or equivalent experience
Course Description
This course highlights more than 75 features for editing, formatting, printing, & customizing Excel. The tips & shortcuts included will give a “back door” approach to accomplishing tasks quickly & efficiently.
Course Topics
- Add color to worksheet tabs
- Create multiple lines within a cell
- Resize the formula bar
- Format cell content as text
- Enter telephone numbers, social security numbers, zip codes, and dates
- Use a custom format to enter dates
- Use a ScreenTip to display cell contents
- Fill cell(s) the width of a column
- Fill nonadjacent cells with the same entry
- Use the pick list to enter text in a cell
- Add an AutoCorrect entry
- Use AutoFill & AutoFill options button
- Reverse the AutoFill action
- Automatically fill down a column
- Create a linear series & remove duplicates
- Filter records for unique values
- Remove duplicates
- Add a picture as a sheet background
- Insert a picture to appear as a watermark
- AutoSum multiple rows and columns
- View the range finder
- Paste link a picture of cell(s)
- Select a large range
- Specify where to move the cell pointer
- Insert a worksheet using a shortcut
- Insert and delete using a keystroke
- Move to a different sheet & select all sheets
- Select adjacent and nonadjacent sheets
- Customize the Quick Access toolbar
- Print multiple worksheets with consecutive page numbers
- Select the same range on several sheets
- Work with multiple sheets
- Select cells with special criteria
- Fill across worksheets
- Create a hyperlink to another workbook
- Display/hide formulas in cells
- Insert cut or copied cells
- Delete and clear cells
- Move data without replacing
- Transpose rows and columns
- Autofit multiple columns or rows
- Autofit all columns or rows
- Color cells with a custom pattern
- Copy formats multiple times
- Add a double underline
- Rotate cell contents
- Jump to or select to the last filled cell
- Name cells and move to named cells
- Create names using existing titles
- Insert a range name from a list
- Paste all range names in a workbook
- Filter by selection
- Insert the path, filename, & sheet name
- Customize the Status Bar
- Search for a function
- Select cells with a quick keystroke
- Specify entry of numbers only
- Select cells where data validation is used
- Create a quick chart on a separate sheet
- Drag and drop cells between sheets
- Protect & unprotect all or part of a worksheet
- Open multiple workbooks simultaneously
- Compare two workbooks side by side
- Copy sheets between workbooks
- Pin a file to the recently used file list
- Save multiple files in a workspace
- Hide and unhide a workbook
- Use page break preview
- Show/hide screen elements
What Participants Receive
Users receive a guide with step-by-step instructions and a laminated reference card.
