Advanced Excel
This class explores topics that increase your sophistication with Excel. We’ll learn a variety of functions, including VLOOKUP, HLOOKUP, SUMIF, and ROUND. We’ll create formulas that use more than one function.
Text functions include those which parse, concatenate, and validate data, including insertion of drop-down lists. There are exercises to manage data including subtotals, advanced filtering and pivot tables/charts. We’ll also modify charts for secondary axis and trendlines, create custom lists and record simple macros.
Dates/Times:
- Wednesday, March 19, 2008, 8:30 a.m. - 4:30 p.m.
- Thursday, July 24, 2008, 8:30 a.m. - 4 ;30 p.m.
- Wednesday, Nov. 19, 2008, 8:30 a.m. - 4:30 p.m.
Location: MARC Computer Lab, Suite 170
Instructor: Mona French
Fee:
- GTI Members $172
- Non-members $198
- Non-profits $99
Registration:
- Register and pay online with a credit card:
- 3/19/08
- 7/24/08
- 11/19/08
- Register online and pay with an agency purchase order
*Special non-profit rates apply only to staff and clients of 501(c)(3) organizations.
Questions? Call 816/701-8234 or e-mail gti@marc.org.