Computers & Technology
|Microsoft Excel 2003, Advanced - Online
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.
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 Microsoft Internet Explorer or Mozilla Firefox Web browser. This course is not suitable for Macintosh users.
Microsoft Excel 2000 and 2002 users will be supported in the discussion area.
This class has already started for the quarter which means it is too late to register. Please check back soon to register for the next quarter.