You are now in the main content area

Excel Tips & Tricks

Date: Friday, October 18, 2019 at 9 a.m. to 12 p.m.
Location: KHW 177B
Registration: Registration is closed.
Cost: Free
No Show Fee: $50
Manager Approval: Required

This course is for intermediate/advanced level users that wants to increase their Excel productivity with the power user tips and tricks packed into this fast-paced course. Use just some of the tips & tricks learned in this course and they will save you hours every week.

  • Quick Start Shortcuts
  • Adjust the Quick Access Toolbar 
  • Enter data or formulas in non-adjacent cells simultaneously 
  • Convert formulas to values with a simple drag 
  • Copy data or formulas down a column instantly 
  • Adjust all or selected column widths in a flash 
  • Instantly display all worksheet formulas 
  • Instantly enter today's date or time 
  • Zoom in and out quickly
  • Display Shortcuts
  • Create split screens and frozen titles in a flash 
  • Restore missing labels and hide repeating labels 
  • Navigation Shortcuts
  • Navigate between & within workbooks & worksheets efficiently 
  • Selection Shortcuts
  • Select an entire row, column, or worksheet 
  • Select non-contiguous ranges and visible cells only 
  • Data Entry and Editing Shortcuts
  • Accelerate data entry 
  • Enter dates and date series efficiently 
  • Use Custom Lists for rapid data entry 
  • Formula Shortcuts
  • Create formulas rapidly 
  • Perform calculations without formulas 
  • Operational Shortcuts
  • Insert, delete, hide, and unhide columns and rows rapidly 
  • Select and manipulate blank cells 
  • Formatting Shortcuts
  • Add a color background to every fifth row in a range 
  • Use Conditional Formatting to show/hide data in sheet based on a content of a cell
  • Database Techniques
  • Sort data with single buttons 
  • Clean up spaces quickly 
  • Identify and eliminate duplicates 
  • Flash Fill to split column data or join data from multiple columns into one column
  • Display unique items from large lists