Excel II Pro
Scheduled Dates
Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
---|---|---|---|---|---|---|
Excel II Pro | 4/24/2021 (Sat) | 9AM - 12PM | 4 | 4 | $80.00 | Register |
Excel II Pro | 5/4/2021 (Tue) | 9AM - 12PM | 2 | 4 | $80.00 | Register |
Excel II Pro | 5/11/2021 (Tue) | 9AM - 12PM | 3 | 4 | $80.00 | Register |
Topics Include:
- Entering data fast
- Fastest methods for selecting data
- Quickly resize Columns and Row sizes
- Creating a Series
- Applying Cell Styles
- Copy data between Excel documents
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
- Best Practices for writing Formulas
- Edit formulas and fix common errors
- Filling formulas
- PEMDAS
Other Ways to Use Formulas
- Paste Special - Values Only
- Defining and creating names
- Display cells
- MIN
- MAX
- AVERAGE
- ROUND
- LOWER
- UPPER
- PROPER
- Using and formatting Comments
- Multiple Cells, Same Data
- Multi-line cell
- Cell Message
- One Click to Get More Status