Office of the Chief Technology Officer

DC Agency Top Menu

-A +A
Bookmark and Share

Excel III Advanced (Ward 2)

Last Date:

DC Public Library (Express) - 1990 K St NW, Washington, DC 20006

Description:In this two-hour class, you will learn to calculate, research and display table data using various Microsoft Excel 2016 formulas. Seats are limited to 12 participants and will be filled on a first-come, first-served basis. Please arrive a half-hour early to sign in for a seat at one of the 12 workstations. Instructor: R. Arthur Library Express 1990 K St. NW Computer Lab - Room 102 Required skills: The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics, Word II Intermediate, Excel I Basics and Excel II Intermediate. You will learn to: Calculate using the following formulas: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS Research table data using the VLOOKUP and HLOOKUP formulas Organize table data using PIVOTTABLES and PIVOTCHARTS Trace precedents, show formulas and apply the Watch Window feature Please bring your own flash drive to save class documents, or send them to your email account.

Ward 2