Excel II Intermediate

Computer ClassesLibrary Express

Excel II Intermediate

Tuesday, Aug. 20, 2019, 11:30 a.m.

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: M. Rivera
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.