Excel III Advanced

Seats are limited to 16 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 16 workstations.

In this two-hour class, you will learn to calculate, research and display table data using various Microsoft Excel 2019 formulas. 

Seats are limited to 16 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 16 workstations. No entry 20 minutes after class starts.

For reasonable accommodation requests, please contact the Center for Accessibility at DCPLaccess@dc.gov or 202-727-2142.

Instructor: A. Peek
MLK Jr. Memorial Library
Adult Learning Department
901 G Street, NW
Computer Lab - Room 202-O

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.

Upcoming events