Excel III Advanced

Computer ClassesLibrary Express

Excel III Advanced

Saturday, Nov. 18, 2017, 3 p.m.

In this 2-hour  class, you will learn to calculate, research and display table data using various Excel 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: D. P. Grogan
Library Express
1990 K Street, 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.