Skip to main content
close
Font size options
Increase or decrease the font size for this website by clicking on the 'A's.
Contrast options
Choose a color combination to give the most comfortable contrast.
2019 Excel Icon

Excel III Advanced – Walk-In Access

2023-04-26 17:00:00 2023-04-26 19:00:00 America/New_York Excel III Advanced – Walk-In Access Martin Luther King Jr. Memorial Library - Central Library - 202-O Computer Lab (17 Person Capacity)

Wednesday, April 26
5:00pm - 7:00pm

Add to Calendar 2023-04-26 17:00:00 2023-04-26 19:00:00 America/New_York Excel III Advanced – Walk-In Access 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. Martin Luther King Jr. Memorial Library - Central Library - 202-O Computer Lab (17 Person Capacity)

Martin Luther King Jr. Memorial Library - Central Library

202-O Computer Lab (17 Person Capacity)

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.

Instructor: R. Arthur
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.

AGE GROUP: | Seniors | Adults |

EVENT TYPE: | Computer Class |

TAGS: | |

Martin Luther King Jr. Memorial Library - Central Library

Phone: (202) 727-0321

Hours
Mon, Jun 05 10:00AM to 9:00PM
Tue, Jun 06 10:00AM to 9:00PM
Wed, Jun 07 10:00AM to 9:00PM
Thu, Jun 08 1:00PM to 9:00PM
Fri, Jun 09 9:30AM to 5:30PM
Sat, Jun 10 9:30AM to 5:30PM
Sun, Jun 11 1:00PM to 5:00PM

About the library

Upcoming events

Tue, Jun 06, 10:00am - 1:00pm

Tue, Jun 06, 10:00am - 10:30am

Tue, Jun 06, 11:00am - 11:30am

Tue, Jun 06, 2:00pm - 4:00pm
205-J Computer Lab (21 Person Capacity)

Tue, Jun 06, 2:00pm - 3:30pm
202-O Computer Lab (17 Person Capacity)

Tue, Jun 06, 4:00pm - 5:00pm

Tue, Jun 06, 4:00pm - 5:00pm

Tue, Jun 06, 7:00pm - 9:00pm
East Storefront A & B

Wed, Jun 07, 10:00am - 12:00pm

Wed, Jun 07, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Wed, Jun 07, 10:00am - 10:30am
204-F Youth Program Room

Wed, Jun 07, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Wed, Jun 07, 11:00am - 12:00pm

Wed, Jun 07, 11:00am - 12:00pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 07, 12:15pm - 1:15pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 07, 1:30pm - 2:30pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 07, 3:00pm - 5:00pm

Wed, Jun 07, 4:00pm - 5:00pm
West Storefront

Wed, Jun 07, 4:30pm - 6:00pm
202-O Computer Lab (17 Person Capacity)

Wed, Jun 07, 5:00pm - 6:00pm
West Storefront

Wed, Jun 07, 6:00pm - 8:00pm

Wed, Jun 07, 7:00pm - 8:00pm

Wed, Jun 07, 7:00pm - 8:00pm
East Storefront A & B

Wed, Jun 07, 7:00pm - 8:00pm
204-F Youth Program Room

Thu, Jun 08, 11:45am - 1:00pm
205-B Accessibility Program Room

Thu, Jun 08, 1:00pm - 1:30pm

Thu, Jun 08, 1:00pm - 2:00pm

Thu, Jun 08, 1:30pm - 3:00pm
204-F Youth Program Room

Thu, Jun 08, 2:00pm - 4:30pm
205-J Computer Lab (21 Person Capacity)

Thu, Jun 08, 2:00pm - 3:30pm
202-O Computer Lab (17 Person Capacity)

Thu, Jun 08, 2:15pm - 3:15pm
205-B Accessibility Program Room

Thu, Jun 08, 3:00pm - 4:00pm

Thu, Jun 08, 3:30pm - 5:00pm
204-F Youth Program Room

Thu, Jun 08, 5:30pm - 6:30pm

Canceled
Thu, Jun 08, 6:00pm - 7:30pm

Thu, Jun 08, 6:00pm - 8:00pm
Event Space

Fri, Jun 09, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Fri, Jun 09, 10:30am - 12:00pm
205-B Accessibility Program Room

Fri, Jun 09, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Fri, Jun 09, 11:00am - 12:00pm
401-G Conference Room (6-46 Person Capacity_

Fri, Jun 09, 3:30pm - 4:30pm

Sat, Jun 10, 10:00am - 1:00pm

Sat, Jun 10, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Sat, Jun 10, 11:00am - 11:30am

Sat, Jun 10, 12:15pm - 2:15pm
205-B Accessibility Program Room

Sat, Jun 10, 1:00pm - 4:00pm
Event Space

Rescheduled
Sat, Jun 10, 2:00pm - 3:30pm
New date Saturday, July 08, 2:00pm - 3:30pm

Sat, Jun 10, 2:00pm - 4:00pm
401-G Conference Room (6-46 Person Capacity_

Sat, Jun 10, 2:00pm - 3:00pm

Sat, Jun 10, 3:00pm - 5:00pm

Sun, Jun 11, 2:00pm - 3:00pm

Mon, Jun 12, 10:00am - 12:00pm

Mon, Jun 12, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Mon, Jun 12, 2:00pm - 4:00pm
202-O Computer Lab (17 Person Capacity)

Mon, Jun 12, 3:30pm - 4:30pm
204-F Youth Program Room

Mon, Jun 12, 4:30pm - 5:30pm

Tue, Jun 13, 10:00am - 1:00pm

Tue, Jun 13, 10:00am - 10:30am

Tue, Jun 13, 11:00am - 2:00pm
202-K Consultation Room

Tue, Jun 13, 11:00am - 11:30am

Tue, Jun 13, 1:00pm - 2:00pm
401-F Conference Room (20-46 Person Capacity)

Tue, Jun 13, 1:30pm - 3:00pm
401-G Conference Room (6-46 Person Capacity_

Tue, Jun 13, 2:00pm - 4:00pm
205-J Computer Lab (21 Person Capacity)

Tue, Jun 13, 2:00pm - 3:30pm
202-O Computer Lab (17 Person Capacity)

Tue, Jun 13, 4:00pm - 5:00pm

Tue, Jun 13, 5:30pm - 9:00pm
Auditorium

Wed, Jun 14, 10:00am - 12:00pm

Wed, Jun 14, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Wed, Jun 14, 10:00am - 10:30am
204-F Youth Program Room

Wed, Jun 14, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Wed, Jun 14, 11:00am - 12:00pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 14, 12:15pm - 1:15pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 14, 1:30pm - 2:30pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 14, 3:00pm - 4:00pm

Wed, Jun 14, 7:00pm - 8:00pm
204-F Youth Program Room

Thu, Jun 15, 11:45am - 1:00pm
205-H Accessibility Program Room

Thu, Jun 15, 1:00pm - 1:30pm

Thu, Jun 15, 1:00pm - 2:00pm
205-H Accessibility Program Room

Thu, Jun 15, 1:30pm - 3:00pm
204-F Youth Program Room

Thu, Jun 15, 2:00pm - 4:30pm
205-J Computer Lab (21 Person Capacity)

Thu, Jun 15, 2:00pm - 3:30pm
202-O Computer Lab (17 Person Capacity)

Thu, Jun 15, 2:15pm - 3:15pm
205-H Accessibility Program Room

Thu, Jun 15, 3:00pm - 4:00pm

Thu, Jun 15, 5:30pm - 6:30pm

Thu, Jun 15, 6:00pm - 7:00pm

Thu, Jun 15, 6:00pm - 8:00pm
202-O Computer Lab (17 Person Capacity)

Thu, Jun 15, 6:30pm - 7:30pm
205-B Accessibility Program Room

Fri, Jun 16, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Fri, Jun 16, 10:00am - 11:30am
202-O Computer Lab (17 Person Capacity)

Fri, Jun 16, 10:30am - 12:00pm
205-B Accessibility Program Room

Fri, Jun 16, 11:00am - 12:00pm
401-G Conference Room (6-46 Person Capacity_

Fri, Jun 16, 3:30pm - 4:30pm

Sat, Jun 17, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Sat, Jun 17, 11:00am - 11:30am

Sat, Jun 17, 11:30am - 12:30pm
East Storefront B (inside corner)

Sat, Jun 17, 12:00pm - 1:00pm
West Storefront

Sat, Jun 17, 12:15pm - 2:15pm
205-B Accessibility Program Room

Sat, Jun 17, 1:00pm - 2:00pm
West Storefront

Sun, Jun 18, 2:00pm - 3:00pm

Sun, Jun 18, 2:00pm - 3:00pm

Tue, Jun 20, 10:00am - 1:00pm

Tue, Jun 20, 10:00am - 10:30am

Tue, Jun 20, 11:00am - 11:30am

Tue, Jun 20, 2:00pm - 4:00pm
205-J Computer Lab (21 Person Capacity)

Tue, Jun 20, 2:00pm - 3:30pm
202-O Computer Lab (17 Person Capacity)

Tue, Jun 20, 4:00pm - 5:00pm

Tue, Jun 20, 4:00pm - 5:00pm
204-F Youth Program Room

Tue, Jun 20, 7:00pm - 8:30pm
401-E Conference Room (20-46 Person Capacity)

Wed, Jun 21, 10:00am - 12:00pm

Wed, Jun 21, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Wed, Jun 21, 10:00am - 10:30am
204-F Youth Program Room

Wed, Jun 21, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Wed, Jun 21, 11:00am - 12:00pm

Wed, Jun 21, 11:00am - 12:00pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 21, 12:15pm - 1:15pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 21, 1:30pm - 2:30pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 21, 2:00pm - 3:30pm

Wed, Jun 21, 2:00pm - 4:00pm
202-O Computer Lab (17 Person Capacity)

Canceled
Wed, Jun 21, 5:30pm - 7:30pm

Wed, Jun 21, 7:00pm - 8:30pm
East Storefront A & B

Wed, Jun 21, 7:00pm - 8:00pm
204-F Youth Program Room

Thu, Jun 22, 11:45am - 1:00pm
205-B Accessibility Program Room

Thu, Jun 22, 1:00pm - 1:30pm

Thu, Jun 22, 1:00pm - 2:00pm

Thu, Jun 22, 1:30pm - 3:00pm
204-F Youth Program Room

Thu, Jun 22, 2:00pm - 3:30pm
202-O Computer Lab (17 Person Capacity)

Thu, Jun 22, 2:15pm - 3:15pm
205-B Accessibility Program Room

Thu, Jun 22, 5:30pm - 6:30pm

Thu, Jun 22, 6:00pm - 7:30pm

Fri, Jun 23, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Fri, Jun 23, 10:30am - 12:00pm
205-B Accessibility Program Room

Fri, Jun 23, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Fri, Jun 23, 11:00am - 12:00pm
401-G Conference Room (6-46 Person Capacity_

Fri, Jun 23, 3:30pm - 4:30pm

Sat, Jun 24, 10:00am - 4:00pm

Sat, Jun 24, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Sat, Jun 24, 11:00am - 11:30am

Sat, Jun 24, 11:00am - 12:00pm

Sat, Jun 24, 12:15pm - 2:15pm
205-B Accessibility Program Room

Sat, Jun 24, 1:00pm - 2:30pm
401-A Conference Room (20-50 Person Capacity)

Sat, Jun 24, 1:30pm - 3:30pm
202-O Computer Lab (17 Person Capacity)

Sat, Jun 24, 2:00pm - 3:00pm

Sat, Jun 24, 2:00pm - 3:00pm

Sat, Jun 24, 3:00pm - 5:00pm

Sun, Jun 25, 2:00pm - 3:00pm

Mon, Jun 26, 10:00am - 12:00pm

Mon, Jun 26, 2:00pm - 4:00pm
202-O Computer Lab (17 Person Capacity)

Mon, Jun 26, 3:30pm - 4:30pm
204-F Youth Program Room

Mon, Jun 26, 4:30pm - 5:30pm

Mon, Jun 26, 6:00pm - 7:00pm
401-G Conference Room (6-46 Person Capacity_

Tue, Jun 27, 10:00am - 1:00pm

Tue, Jun 27, 10:00am - 10:30am

Tue, Jun 27, 11:00am - 11:30am

Tue, Jun 27, 3:30pm - 4:30pm
204-F Youth Program Room

Tue, Jun 27, 4:00pm - 5:00pm

Tue, Jun 27, 5:30pm - 9:00pm
Auditorium

Wed, Jun 28, 10:00am - 12:00pm

Wed, Jun 28, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Wed, Jun 28, 10:00am - 10:30am
204-F Youth Program Room

Wed, Jun 28, 11:00am - 12:00pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 28, 12:15pm - 1:15pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 28, 1:30pm - 2:30pm
205-J Computer Lab (21 Person Capacity)

Wed, Jun 28, 3:00pm - 5:00pm

Wed, Jun 28, 5:00pm - 7:00pm
202-O Computer Lab (17 Person Capacity)

Wed, Jun 28, 6:30pm - 7:30pm

Wed, Jun 28, 7:00pm - 8:00pm
204-F Youth Program Room

Thu, Jun 29, 10:00am - 11:00am
204-F Youth Program Room

Thu, Jun 29, 11:45am - 1:00pm
205-B Accessibility Program Room

Thu, Jun 29, 1:00pm - 1:30pm

Thu, Jun 29, 1:00pm - 2:00pm

Thu, Jun 29, 1:30pm - 3:00pm
204-F Youth Program Room

Thu, Jun 29, 2:15pm - 3:15pm
205-B Accessibility Program Room

Thu, Jun 29, 3:30pm - 5:00pm
202-O Computer Lab (17 Person Capacity)

Thu, Jun 29, 5:30pm - 6:30pm

Thu, Jun 29, 7:00pm - 8:00pm
East Storefront A & B

Fri, Jun 30, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Fri, Jun 30, 10:30am - 12:00pm
205-B Accessibility Program Room

Fri, Jun 30, 10:30am - 12:30pm
202-O Computer Lab (17 Person Capacity)

Fri, Jun 30, 11:00am - 12:00pm
401-G Conference Room (6-46 Person Capacity_

Fri, Jun 30, 3:30pm - 4:30pm

Sat, Jul 01, 11:00am - 11:30am

Sat, Jul 01, 12:15pm - 2:15pm
205-B Accessibility Program Room

Sat, Jul 01, 2:00pm - 3:30pm
401-G Conference Room (6-46 Person Capacity_

Canceled
Sat, Jul 01, 2:00pm - 2:30pm

Mon, Jul 03, 10:00am - 12:00pm

Mon, Jul 03, 3:30pm - 4:30pm
204-F Youth Program Room

Wed, Jul 05, 10:00am - 12:00pm

Wed, Jul 05, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Wed, Jul 05, 10:00am - 10:30am
204-F Youth Program Room

Wed, Jul 05, 11:00am - 12:00pm

Wed, Jul 05, 11:00am - 12:00pm
205-J Computer Lab (21 Person Capacity)

Wed, Jul 05, 12:15pm - 1:15pm
205-J Computer Lab (21 Person Capacity)

Wed, Jul 05, 1:30pm - 2:30pm
205-J Computer Lab (21 Person Capacity)

Wed, Jul 05, 3:00pm - 5:00pm

Wed, Jul 05, 3:00pm - 5:00pm

Wed, Jul 05, 6:00pm - 8:00pm

Wed, Jul 05, 7:00pm - 8:00pm

Wed, Jul 05, 7:00pm - 8:00pm
204-F Youth Program Room

Thu, Jul 06, 10:00am - 11:00am
204-F Youth Program Room

Thu, Jul 06, 11:45am - 1:00pm
205-B Accessibility Program Room

Thu, Jul 06, 12:00pm - 1:30pm
205-J Computer Lab (21 Person Capacity)

Thu, Jul 06, 1:00pm - 3:00pm
202-J Consultation Room,202-K Consultation Room

Thu, Jul 06, 1:00pm - 1:30pm

Thu, Jul 06, 1:00pm - 2:00pm

Thu, Jul 06, 1:30pm - 3:00pm
204-F Youth Program Room

Thu, Jul 06, 2:15pm - 3:15pm
205-B Accessibility Program Room

Thu, Jul 06, 5:30pm - 6:30pm

Thu, Jul 06, 6:00pm - 7:00pm