No New Notifications

Excel Tips and Tricks: Essential Time-Saving Techniques

Accelerate Computer Training

Limited time remaining!
Select Option

Highlights

Excel is one of the most complex and powerful software programs ever created, and becoming skilled in Excel can take many years! In this liv

What You'll Get

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, 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!

Class 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
  • Neatly Arrange Multiple Windows of the Same Workbook
  • Save Multiple Workbooks as a Workspace

Navigation and Selections

  • Shortcuts to Select a Row, Column or Current Region
  • Why the Select All Keystroke Doesn't Always Work
  • Ctrl-key navigation and selection
  •  Complex Range Selection
  • GoTo Special navigation and selection
  • Jump to the Furthest Row or Column Using Your 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
  • Where’s the "No to All" Button When Closing Files

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.

The class identified is made available through CourseHorse, a 3rd party marketplace for Excel classes and more. Groupon is not affiliated with or sponsored by the merchant, Accelerate Computer Training, in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.

The Fine Print

Expiration varies.

  • ALL SALES FINAL.
  • Must be 16 or older to attend
  • Voucher valid only for date and time listed; may not be exchanged, altered, or redeemed for other dates, but may send a friend in place.
  • Must present CourseHorse confirmation email upon arrival.
  • Purchaser name must be provided at checkout; this information will be shared with CourseHorse and course provider for purposes of order fulfillment.
  • Groupon voucher Terms of Sale and Extraordinary Event Policy do not apply.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services.
  • Offer is not eligible for our promo codes or other discounts.
  • Note, additional equipment or materials may be required or included in purchase price, see course description for details.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services. Offer is not eligible for our promo codes or other discounts.

Accelerate Computer Training

Class, Academic Course
By purchasing this deal you'll unlock points which can be spent on discounts and rewards. Every 5,000 points can be redeemed for $5 Off your next purchase.