header containing attorney generals logo

Human Resources Division, Staff Development Section
Employee Development Announcements
January 21, 2018 to January 27, 2018

Class Schedule | Training Calendar | Course Descriptions

Excel Formulas and Functions
09:00 AM to 12:00 PM
 
Thursday, January 25th

In this intermediate-level class, attendees will work with many of Excel's powerful features. Hands-on instruction will be provided on how to use many of Excel's built-in functions involving Boolean logic and conditional comparisons ("IF," "AND," "OR") finding data you need ("VLOOKUP"), character manipulation ("CONCATENATE," "LEFT," "LEN") and math and statistics ("SUMIF," "MEDIAN," "AVERAGE"). We'll also look at how to use mathematical operators with dates, create nested formulas, apply formulas across multiple worksheets, and use named ranges in formulas.

Please note: this is an intermediate-level class. Attendees should be comfortable working with spreadsheets and/or have completed the Excel Essential Features class.

Prefix ExcFF13 , Course # 17-0008