Overview
This class is geared toward the above average user who wants to increase their productivity and effectiveness with Excel.
Audience
It is a prerequisite that students enrolling in this class will understand how to create simple functions (sum, average) and formulas in Excel (=A2+B2) and that they are comfortable using the standard formatting features in Excel.
Length
4 hours
Outline
Entering Data
- Enter a line break within a cell
- Auto fill
- Copying cells and creating series
- Creating a custom autofill series
- Auto complete
Formatting
- Sizing rows, columns, wrapping text
- Dates, text and values
- Format painter
- Custom number formats
- Conditional formatting
- Text to columns
Using Keyboard Shortcuts
Paste Special
- Values and formulas
Absolute reference
Naming cells
Functions
- Using the Function Wizard
- PMT function
- Date formulas
Error Messages
- Identifying errors in formulas
- Troubleshooting problems with formulas
Organizing Lists of Data
- Sorting data
- Filtering data
- Subtotal
- Grouping
- Freezing rows and columns