Microsoft Office Excel Intermediate, SC 567
About this Course:
This course expands on the basic aspects of Microsoft Excel and spreadsheet programs.
This course may be taken in MS Office 2003 or MS Office 2007. Course schedule will indicate which version is included in each offering.
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 : Basics (SC 531) course and is for anyone knowing basics 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.
Course Outline:
Large Worksheets
Working with Multiple Worksheets and Workbooks
Customizing Excel
Advanced Formatting
List Management
Advanced Charting
Documenting and Auditing
Using Templates
CEU:
0.7
Presented By:
Professional Learning Programs
As an International Association for Continuing Education and Training (IACET) Authorized Provider, the Professional Learning Programs department of the IIT School of Applied Technology (SAT) offers CEUs for its programs that qualify under the ANSI/IACET Standard.