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.
PMT Function

Financial Excel: Formulas for Calculating Car Payments

2022-12-19 17:30:00 2022-12-19 19:30:00 America/New_York Financial Excel: Formulas for Calculating Car Payments Martin Luther King Jr. Memorial Library - Central Library - 202-O Computer Lab (17 Person Capacity)

Monday, December 19
5:30pm - 7:30pm

Add to Calendar 2022-12-19 17:30:00 2022-12-19 19:30:00 America/New_York Financial Excel: Formulas for Calculating Car Payments 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 the projected monthly payments on different models of vehicles at different prices and interest rates, using the Payment (PMT) Formula in Microsoft Excel 2019. 

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: M. Rivera
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, Excel II Intermediate and Excel III Advanced.

You will learn to:

  • Calculate the payments on several different car models by using the PAYMENT (PMT) formula
  • Engage the Function Arguments dialog box to enter and process the elements of the formula
  • Learn to navigate the Formulas Command Tab for related formulas 

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, Jan 30 9:30AM to 9:00PM
Tue, Jan 31 9:30AM to 9:00PM
Wed, Feb 01 9:30AM to 9:00PM
Thu, Feb 02 9:30AM to 9:00PM
Fri, Feb 03 9:30AM to 5:30PM
Sat, Feb 04 9:30AM to 5:30PM
Sun, Feb 05 1:00PM to 5:00PM

About the library

Upcoming events

Tue, Jan 31, All day

Tue, Jan 31, All day

Tue, Jan 31, 10:00am - 2:00pm
202-J Consultation Room

Tue, Jan 31, 10:30am - 11:00am

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

Tue, Jan 31, 4:00pm - 5:00pm
204-F Youth Program Room

Tue, Jan 31, 5:00pm - 9:00pm
East Storefront A & B

Tue, Jan 31, 5:30pm - 9:00pm
Auditorium

Wed, Feb 01, All day

Wed, Feb 01, 10:00am - 12:00pm

Wed, Feb 01, 10:00am - 4:00pm

Wed, Feb 01, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

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

Wed, Feb 01, 11:00am - 12:00pm

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

Wed, Feb 01, 6:00pm - 8:00pm

Wed, Feb 01, 7:00pm - 8:00pm

Wed, Feb 01, 7:00pm - 8:00pm
East Storefront A & B

Thu, Feb 02, All day

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

Thu, Feb 02, 1:00pm - 1:30pm

Thu, Feb 02, 1:00pm - 3:00pm
202-J Consultation Room,202-K Consultation Room

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

Thu, Feb 02, 5:00pm - 6:00pm

Thu, Feb 02, 6:00pm - 7:00pm

Fri, Feb 03, All day

Fri, Feb 03, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

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

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

Fri, Feb 03, 2:00pm - 4:00pm
202-O Computer Lab (17 Person Capacity)

Sat, Feb 04, All day

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

Sun, Feb 05, All day

Mon, Feb 06, All day

Mon, Feb 06, 10:00am - 12:00pm

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

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

Mon, Feb 06, 5:00pm - 7:00pm
202-O Computer Lab (17 Person Capacity)

Mon, Feb 06, 6:00pm - 8:00pm

Tue, Feb 07, All day

Tue, Feb 07, 10:00am - 2:00pm
202-J Consultation Room

Tue, Feb 07, 10:30am - 11:00am

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

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

Tue, Feb 07, 3:00pm - 9:00pm
Auditorium

Tue, Feb 07, 4:00pm - 5:00pm
204-F Youth Program Room

Tue, Feb 07, 4:30pm - 5:30pm

Wed, Feb 08, All day

Wed, Feb 08, 10:00am - 12:00pm

Wed, Feb 08, 10:00am - 4:00pm

Wed, Feb 08, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

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

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

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

Wed, Feb 08, 5:00pm - 7:00pm
302-F Meeting Room (2-6 Person Capacity)

Wed, Feb 08, 6:00pm - 8:00pm

Wed, Feb 08, 6:00pm - 8:00pm

Thu, Feb 09, All day

Thu, Feb 09, 1:00pm - 1:30pm

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

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

Thu, Feb 09, 5:00pm - 6:00pm

Thu, Feb 09, 6:00pm - 7:30pm
MLK Dance Studio (A Level)

Fri, Feb 10, All day

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

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

Sat, Feb 11, All day

Sat, Feb 11, 10:00am - 12:00pm

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

Sat, Feb 11, 1:00pm - 4:00pm
Auditorium

Sat, Feb 11, 1:30pm - 4:00pm
202-O Computer Lab (17 Person Capacity)

Sat, Feb 11, 2:00pm - 3:30pm
401-E Conference Room (20-46 Person Capacity)

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

Sun, Feb 12, All day

Mon, Feb 13, All day

Mon, Feb 13, 10:00am - 12:00pm

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

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

Mon, Feb 13, 5:00pm - 7:00pm
202-O Computer Lab (17 Person Capacity)

Mon, Feb 13, 6:00pm - 8:00pm

Tue, Feb 14, All day

Tue, Feb 14, 10:00am - 2:00pm
202-J Consultation Room

Tue, Feb 14, 10:00am - 11:00am
Great Hall

Tue, Feb 14, 10:30am - 11:00am

Tue, Feb 14, 11:00am - 2:00pm
202-K Consultation Room

Tue, Feb 14, 1:00pm - 3:00pm
401-G Conference Room (6-46 Person Capacity_

Canceled
Tue, Feb 14, 1:30pm - 3:00pm

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

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

Tue, Feb 14, 3:00pm - 9:00pm
Auditorium

Tue, Feb 14, 4:00pm - 5:00pm
204-F Youth Program Room

Tue, Feb 14, 4:30pm - 5:30pm

Wed, Feb 15, All day

Wed, Feb 15, 10:00am - 12:00pm

Wed, Feb 15, 10:00am - 4:00pm

Wed, Feb 15, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Wed, Feb 15, 11:00am - 12:00pm

Wed, Feb 15, 3:00pm - 5:00pm
204-F Youth Program Room

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

Wed, Feb 15, 5:30pm - 7:30pm

Wed, Feb 15, 6:00pm - 8:00pm

Thu, Feb 16, All day

Thu, Feb 16, 1:00pm - 1:30pm

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

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

Thu, Feb 16, 5:00pm - 6:00pm

Thu, Feb 16, 6:00pm - 7:00pm

Thu, Feb 16, 6:30pm - 7:30pm
205-J Computer Lab (21 Person Capacity)

Thu, Feb 16, 7:00pm - 8:00pm

Fri, Feb 17, All day

Fri, Feb 17, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Fri, Feb 17, 10:30am - 12:30pm

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

Fri, Feb 17, 2:00pm - 4:00pm
202-O Computer Lab (17 Person Capacity)

Sat, Feb 18, All day

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

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

Sun, Feb 19, All day

Sun, Feb 19, 4:00pm - 5:00pm
Auditorium

Mon, Feb 20, All day

Tue, Feb 21, All day

Tue, Feb 21, 10:00am - 2:00pm
202-J Consultation Room

Tue, Feb 21, 10:30am - 11:00am

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

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

Tue, Feb 21, 3:00pm - 9:00pm
Auditorium

Tue, Feb 21, 4:00pm - 5:00pm
204-F Youth Program Room

Tue, Feb 21, 4:30pm - 5:30pm

Wed, Feb 22, All day

Wed, Feb 22, 10:00am - 12:00pm

Wed, Feb 22, 10:00am - 4:00pm

Wed, Feb 22, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

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

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

Wed, Feb 22, 5:00pm - 7:00pm
302-F Meeting Room (2-6 Person Capacity)

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

Wed, Feb 22, 6:00pm - 8:00pm

Thu, Feb 23, All day

Thu, Feb 23, 1:00pm - 1:30pm

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

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

Thu, Feb 23, 5:00pm - 6:00pm

Thu, Feb 23, 6:00pm - 7:30pm

Fri, Feb 24, All day

Fri, Feb 24, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Fri, Feb 24, 10:30am - 12:00pm
401-F Conference Room (20-46 Person Capacity)

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

Sat, Feb 25, All day

Sat, Feb 25, 11:00am - 12:00pm
Great Hall

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

Sat, Feb 25, 1:00pm - 2:00pm
East Storefront A & B

Sun, Feb 26, All day

Mon, Feb 27, All day

Mon, Feb 27, 10:00am - 12:00pm

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

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

Mon, Feb 27, 6:00pm - 8:00pm

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

Tue, Feb 28, All day

Tue, Feb 28, 10:00am - 2:00pm
202-J Consultation Room

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

Tue, Feb 28, 3:00pm - 9:00pm
Auditorium

Tue, Feb 28, 4:00pm - 5:00pm
204-F Youth Program Room

Wed, Mar 01, All day

Wed, Mar 01, 10:00am - 12:00pm

Wed, Mar 01, 10:00am - 4:00pm

Wed, Mar 01, 10:00am - 4:00pm
202-H Consultation Room,202-I Consultation Room

Wed, Mar 01, 11:00am - 12:00pm

Wed, Mar 01, 6:00pm - 8:00pm

Wed, Mar 01, 7:00pm - 8:00pm

Thu, Mar 02, All day

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

Thu, Mar 02, 1:00pm - 3:00pm
202-J Consultation Room,202-K Consultation Room

Thu, Mar 02, 5:00pm - 6:00pm

Thu, Mar 02, 6:00pm - 7:00pm