Contact Us Location and Maps Penn State Harrisburg Home Penn State Continuing Educ. Certification Courses and Testing for Office 2000 Many jobs today require individuals to demonstrate an ability to use common Microsoft desktop applications like Word and PowerPoint. Penn State Harrisburg has contracted to be an Authorized Testing Center and to offer training classes as part of this program. A key feature of the program at Penn State Harrisburg is that students taking one of our Office 2000 classes may take the corresponding examination for free.
Discounts are available for organizations wishing to send three or more individuals for training.
This training session provides an introduction to the Microsoft Excel Environment. Topics include basic worksheets, ranges of data, built-in formulas, copying and moving data, changing the appearance of a worksheet, printing, charting capabilities, and using Excel as a Web tool. The skills and concepts necessary to begin using the charting and list management capabilities of Excel 2000 will be covered in the workshop. Topics include creating charts, advanced charting features, modifying existing charts, sorting information, using the AutoFilter feature to find specified information, customizing charts, using the Auto-Format feature to enhance charts, managing lists, and graphic capabilities within worksheets. This class will demonstrate how you can customize toolbars, create styles and templates, create nested and decision-making functions, analyze worksheet data by creating pivot tables, compare and contrast workbook files and file links, outline and consolidate worksheets, protect data by locking cells, start to use macros, and work with interactive Excel Web documents.