Training and Development

Excel 2007 Level 2: Formulas, Filters and Functions

class code - HRTD_TT003

duration - 2.5 hours

Prerequisite skills: Completion of Excel 2007 Level 1: Introduction class or equivalent knowledge.

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
Date(s) & Time(s)
Friday, Dec 11, 2009
9:00 a.m. - 11:30 a.m.
Instructor: Chih Ian Lee
Location: 106 McVey Hall
Status: Open
 
Tuesday, Jan 12, 2010
1:30 p.m. - 4:00 p.m.
Instructor: Jerone Farley
Location: 106 McVey Hall
Status: Open
 
Wednesday, Feb 17, 2010
9:00 a.m. - 11:30 a.m.
Instructor: Kim Heersche
Location: 106 McVey Hall
Status: Open
 
Login and Register at myUK
Disclaimer : Class availability, dates, and times are subject to change. Please verify availability, dates, and times in the Training Management Center at http://myuk.uky.edu.
University of Kentucky - An Equal Opportunity University
Training & Development:  3 Units = 1 Great Department | Our Mission
Questions/Feedback: Training/Development Related | Web Site Related
Last Modified: November 17, 2009 | Off-site Link Disclaimer
Professional Development
123 Scovell Hall
Lexington, KY 40506-0064
Phone: (859) 257-9623
Fax: (859) 323-4815
Technology Training
207 McVey Hall
Lexington, KY 40506-0045
Phone: (859) 257-3856
Fax: (859) 257-4031
Employee Learning Services
203 Breckinridge Hall
Lexington, KY 40506-0056
Phone: (859) 257-7911
Fax: (859) 323-1866