Excel III Advanced

Martin Luther King Jr. Memorial Library - Central Library

Excel III Advanced

Last date: Wednesday, Aug. 27, 2014, 6:15 p.m. (see all dates)

Learn to calculate, research and display table data using Excel formulas. Seats will be filled on a first-come, space-available basis.

Instructor: D. P. Grogan
Computer Lab, Room 311

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.