This class covers several essential Excel shortcuts and customization techniques, then dives into the substantive topics of named ranges and tables.
Topics include:
1. Customizing Excel
- Setting Excel options
- Using the Quick Access toolbar
2. Excel shortcuts
- Top 10 shortcuts
3. Introduction to named ranges
- Creating names
- Using names in formulas
- Changing and deleting names
4. Introduction to tables
- Understanding what Excel tables are
- Using table structured references in formulas
- Sorting and filtering tables
- Resizing tables
- Using and customizing table styles
Prerequisites
Participants should have already taken and put to work the skills covered in Excel Basics Parts 1 and 2. Ideally, participants will already be active Excel users.
To get the most out of this class, participants should be proficient in and comfortable with at least seven out of the following 10 Excel skills:
1. Save an open Excel workbook to your computer desktop
2. Use the selection border fill handle to fill a column of cells with the seven days of the week
3. Create a formula using an absolute cell reference (for example: =$A$2 * C5)
4. Create an Excel column chart
5. Set a worksheet print area and create a PDF file from the print area
6. Move, copy and rename worksheets in an Excel workbook
7. Create formulas to sum or count numbers in a column of cells
8. Create formulas to divide the number in one cell by the number in another cell
9. Create a formula to calculate a percentage and format the result as a percent with 1 decimal
10. Copy worksheet cells from one location to another
