Excel Tips and Tricks: Essential Time-Saving Techniques
Class Details
Length of class: three hours
Price per person: $149
Version covered: for Office 365
Description
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!
Prerequisites
This class is ideally suited for people who have taken the Intermediate Excel classes or have at least two years of experience using Excel.
Outline
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
Upcoming Dates
There are no dates for this course currently on the schedule.