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.
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
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.
Working with Multiple Worksheets and Workbooks
Documenting and Auditing
Professional Learning Programs