Excel II Pro
Scheduled Dates
| Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
|---|---|---|---|---|---|---|
| Excel II Pro | 8/10/2021 (Tue) | 9AM - 12PM | 4 | 3 | $80.00 | Register |
| Excel II Pro | 8/14/2021 (Sat) | 1PM - 4PM | 5 | 3 | $80.00 | Register |
Topics Include:
Entering Data
- Multiple Cells, Same Data
- Multi-line cell
- Cell Message
- Entering data fast
- Copy data between Excel documents
- Create, edit and delete a Custom Lists
- Text to Columns
- Flash Fill
- Combine Text (Fill Justify)
- Shrink to Fit for Headers
Printing Worksheets
- Change viewing options
- Locking Headings for Data Entry
- Creating and Printing LARGE sheets
- Custom headers and footers
- Page breaks
- Print headings
- Change Print Order
Using Formulas
- Edit formulas and fix common errors
- Absolute Cell References
- Filling formulas
- PEMDAS
Paste Special-Values Only
- LOWER
- UPPER
- PROPER