Master advanced features of MS Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity. In this practical hands-on course, you will learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007’s filtering techniques. So get ready for six action-packed weeks that will take your Excel skills to the next level! Course Learning Outcomes: This hands-on class will provide the opportunity to: • manage cell and range names • calculate data across worksheets • use specialized functions • analyze data with logical and lookup functions • create , modify and format tables • sort or filter worksheet or table data • calculate data in a table or worksheet • create, modify and format charts • create a PivotTable report • analyze data using PivotTables • insert and modify pictures, clipart and shapes • illustrate workflow using SmartArt graphics • layer and group graphic objects • automate workbook creation by using templates • customize the Excel environment, customize workbooks and manage themes • additional topics as determined by instructor / group Learning outcomes measurement: Ages: 18 years and older Course Length: 5 weeks Course Materials: provided Course Enrollment: Minimum enrollment: 4 Maximum enrollment: 15 Course Location: Corbly Hall Room 437 Course Dates: November 5, 2009 – December 10, 2009 Course Times: Thursdays, 6:30pm – 8:30pm Course Instructor: Kae Namsupak Course Cost: $150.00