Prerequisites:
• Knowledge of the Windows Operating System.
• Entry and editing of data in Excel worksheets.
• Working knowledge of Excel's formatting menus.
• Knowledge of formula structure, editing and copying.
• Know how to print worksheets and workbooks.
Who should attend: This course is a follow-on to the Excel 2003: Basics (SC 531) and Excel 2003: Intermediate (SC 567) courses that expanding on the advanced capabilities of Excel. The course is designed to promote usage of Excel beyond the basic spreadsheet functions and calculations.
Expected outcomes: Participants will be able
to apply the following operations to their workbooks.
• Generate information based on the data entered in selected cell.
• Query and filter data to display specific information.
• Format reports using styles or auto formats.
• Use pivot tables and pivot charts for interactive display of information.
• Link to workbooks and/or worksheets for calculations.
• Work with macros for repetitive tasks, their creation and editing.
• Work with workbooks on the Web.
• Consolidate information in large worksheets.
• Work with text strings.
Schedule:
| Dates & Times | Cost | CEU | Course Number & Location |
| Thursday July 17, 2008 |
$129 | 0.7 | SC
541 Rice Campus - Wheaton, Room 244 |
Course Outline:
• Working with Advanced Formulas
• Lookup and Data Tables
• Advanced List Management
• Working with Pivot Tables
• Exporting and Importing
• Using Analytical Options
• Working with Macros
• Interactive Web Pages
• Text or String Functions
Registration:
Online - Visit www.cpd.iit.edu/shortcourse/register, complete the online form and submit.
Fax or Mail - Printable PDF - Complete the registration form and payment information.
When finished, fax or mail, along with payment to:
Nilda Cinco at 630.682.6029 or 201 East Loop Road, Wheaton, IL 60187.
Call or email - 630.682.6035 or reif@iit.edu
Presented by:
| Martin Kozi, Instructor |
| Center for Professional Development |
| Illinois Institute of Technology |