Skip to main

After completing this class, you should be able to:


  • Use relative and absolute references
  • Apply sorting and filtering tools
  • Use conditional formulas and other functions
  • Apply defined names and formula auditing tools
  • Apply hyperlinks
  • Apply conditional formatting and cell styles


This course will be instructed using Office 2010 at our McVey location, but the content is compatible with Office 2007. This course is instructed using Office 2007 at all UK HealthCare training locations.

Request this session for your group

In addition to any upcoming scheduled times noted under "Upcoming sessions," this session is also available by request for groups.

Use this form to request this session. You’ll receive a response by email as soon as possible, typically within one week, to discuss scheduling and more details. We appreciate requests made at least one month in advance.

Upcoming sessions