|
Course Description: Say hello to being an Excel power user by
working with advanced formulas, as well
as lookup functions such as VLOOKUP,
MATCH and INDEX. In addition,
utilize data validation and database
functions such as DSUM. Furthermore,
you will learn how to work with
PivotTables and Pivot Charts, import and
export data, and query external databases.
Finally, discover the analytical features
of Excel such as Goal Seek and Solver,
running and recording macros and
sharing Excel data via the Web.
This course will help you prepare for the Microsoft
Certified Application Specialist Excel
2007 exam. For comprehensive certification
training, you need to complete Excel 2007:
Basic, Intermediate, and Advanced. View course content here.
Meeting Place and Times: December 1 - 3, 2009 from 1 - 4 pm., EPS 127; MSU Campus.
Instructor(s): Tyler Powell.
Cost: $98.00
A 25% discount is available for Bozeman Chamber of Commerce and Prospera Business Network members.
Required Books/Materials: - Computer courses require the purchase of a textbook, available through the MSU Bookstore General Books Department (located in the middle of the bookstore) in the Strand Union Building. Students need to have their textbooks before the first day of class. Most textbooks are under $20. Click here for the MSU Bookstore homepage: www.msubookstore.org.
- Excel 2007: Advanced; ISBN-10: 1-4239-1816-9
Receive up to 80% off computer software: Once you are enrolled in an EU course, bring a copy of your course receipt to the MSU Bookstore and receive up to 50% off QuickBooks Software, up to 50% off Microsoft Office Software and up to 80% off Adobe software.
MSU Parking: Parking is free for 30 min. in the pay lot across from the Strand Union Building. Parking is also free in most parking spaces after 6:00 pm and on the weekends.
For More Information: Course Information: Contact Lesa Pribyl at 406-994-7441 or lesa.pribyl@montana.edu Registration Questions: Contact Extended University, Office of Continuing Education, 406-994-6683, toll free 1-866-540-5660, or ContinuingEd@montana.edu.
How to Register: Register Online
|