Excel III Advanced

About this event

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.

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

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.