Intermediate Excel
This class is a logical extension of the fundamentals class, particularly regarding the types of calculations you perform.
We’ll calculate between worksheets and workbooks. We’ll create and manipulate named ranges, use Paste Special, calculate with dates and build formulas that require absolute references. Statistical functions (AVERAGE, MIN, MAX, COUNT) and the IF function are used in calculations. We’ll create and modify a pie chart, learn about comments, protect worksheets and workbooks. Custom filtering of lists is also included.
Dates/Times:
- Wednesday, March 12, 2008, 8:30 a.m. - 4:30 p.m.
- Thursday, July 17, 2008, 8:30 a.m. - 4:30 p.m.
- Wednesday, November 12, 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/12/08
- 7/17/08
- 11/12/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.