This course expands on the basic aspects of Microsoft Excel and spreadsheet
programs. Topics covered in this course include:
• Handling and printing of large spreadsheets.
• Navigation of large spreadsheets using the ZOOM and frozen pane features.
• Navigation, management and printing of multiple worksheets.
• Linking data and functions between worksheets and workbooks.
• Customizing Excel’s setting and toolbars.
• Advanced formatting features including shading, borders and styles.
• Formatting charts and graphs.
• Sorting lists by columns and using filters to manipulate complex data.
• Addition of comments, restrictions and textboxes to assure proper data
entry.
• Using Excel’s templates and creating new templates for frequent
reports or operations.
Prerequisites:
• Basic knowledge of the Windows Operating System.
• Basic knowledge of Excel or other spreadsheet programs.
• Basic data entry in spreadsheets.
• Opening and saving files.
• Printing of documents.
Who should attend: This course is a follow-on to the Excel 2003: Basics (SC 531) course and is for anyone knowing a “little-bit” about spreadsheets and wants to hone their skills. The course introduces participants to some of the advanced features of Excel. Many of the formatting features and workbook sharing options are explored in the session.
Expected outcomes: Participants will be able
to:
• Link information on different worksheets and in different workbooks.
• Restrict the data entered in the spreadsheet to a specific format
and to include notes on the spreadsheet regarding the structure and content
of the information entered in a data-cell.
• Use templates to generate often repeated reports or forms and to
create and edit your own templates.
Schedule:
| Dates & Times | Cost | CEU | Course Number & Location |
| Thursday June 26, 2008 8:30am - 5:00pm |
$129 | 0.7 | SC
567 Rice Campus - Wheaton, Room 244 |
| Tue Apr 29, 2008 9:00 a.m. - 5:00 p.m. |
IIT employees only | 0.7 | SC 567 Main Campus |
Course Outline:
• Large Worksheets
• Working with Multiple Worksheets and Workbooks
• Customizing Excel
• Advanced Formatting
• List Management
• Advanced Charting
• Documenting and Auditing
• Using Templates
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.eduPresented by:
Martin Kozi, Instructor Center for Professional Development Illinois Institute of Technology