There are no dates currently on the public training schedule for this course. However, we can provide this training to your group of three or more people either remotely or at your business location. Please contact us for more information on our corporate training rates and availability by calling (562) 291-3291 or filling out this contact form.
Price per person: | $149 |
Length of class: | three hours |
Version covered: | for Office 365 |
Delivery format: | live over Zoom |
Excel is one of the most complex and powerful software programs ever created, and becoming skilled in Excel can take many years! In this lively three-hour training session for Windows and Mac users, you will learn many tips and tricks that will save you time every time you use Excel. We guarantee you will learn techniques worth remembering!
This class is ideally suited for people who have taken the Intermediate Excel classes or have at least two years of experience using Excel.
Formulas
- Display Formulas Instead of Results
- Display Cell Values When Creating or Editing Formulas
- Highlight All Cells Referenced by a Formula
- Highlight the Formulas that Reference the Current Cell
- Evaluate a Formula
- Using Wildcard Symbols in Formulas
- Performing a Two-Way Lookup Using Range Names
Multiple Worksheets and Workbooks
- Synchronize Scrolling Between Two Sheets
- Arrange Multiple Windows of the Same Workbook
Navigation and Selections
- Shortcuts to Select a Row, Column or Current Region
- Ctrl-key navigation and selection
- Complex Range Selection
- GoTo Special navigation and selection
- Jump to the Furthest Row or Column Using Mouse
Data Editing
- Swap the Position of Cell Ranges using Drag-Insert
- Deleting Values While Keeping Formulas
- Alter Values Arithmetically Without Formulas
Data Validation
- Validate Data
- Create In-Cell Drop-Down Lists
Miscellaneous
- Insert Static Date and Time
- Build Custom AutoFill Lists
- Access the High-Capacity Clipboard
- Create a Live Transposed Copy of Data
- Align Multiple Charts or Graphics