AB Community Education







Acton-Boxborough Community Education
      home classes register directions

EXCEL - ADVANCED #EDEX3

 

Chad Wambolt

Maximize your investment in Microsoft Excel by learning advanced techniques that most users don't even know exist. In this practical, hands-on course, you'll learn how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover a variety of advanced pivot table techniques, like creating calculated fields and calculated items. You'll be able to use validation to protect the integrity of your worksheets from other, less experienced users. You'll become adept at consolidating and importing data, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to nest one function inside another to accomplish just about anything Excel has to offer. Requirements: Completion of Craig Power's online Intermediate Microsoft Excel 2003 course (or equivalent experience), Microsoft Windows Vista, XP or 2000, Microsoft Excel 2003 or Microsoft Office 2003 (Student and Teacher Edition, Standard Edition, Small Business Edition, or Professional Edition are all acceptable - please be sure to install this software on your computer before the course begins), Internet access, e-mail, and the Internet Explorer or Netscape or Firefox Web browser. This course is not suitable for Macintosh users. Microsoft Excel 2000 and 2002 users will be supported in the discussion area.

Cost: $95

Click here for more information on on-line classes and how to register

Return to Computer Classes