Computer Courses – Microsoft Office 2010

Technological literacy is critical to the success of any organization. Empower employees by providing them with fundamental computer competencies needed to work faster and more efficiently.

 

Fee is $225 per course, including materials. Minimum 12 students per course.

 

Penn State Abington can offer courses at your location. On your time. Call an Employee Engagement Specialist today at 215-881-7400.

Word 2010 Basic

Who should take this course?

Anyone who wants to learn how to use the basic features of Word 2010.


•    Introduction to the new Word interface
•    Enter, select, edit and format text
•    Use tables, headers and footers

Word 2010 Intermediate

Who should take this course?

People who have been using Word and want to learn how to use more advanced features.  The topics in this course are particularly useful for managing large documents.


•    Styles and Sections
•    Manage revisions by tracking changes and adding comments
•    Templates and Building Blocks

Excel 2010 Basic

Who should take this course?

Anyone who does not have much experience with Excel and needs to be able to create basic worksheets and charts.


•    Introduction to the Excel interface and spreadsheet terminology.
•    Enter, edit and format data
•    Use formulas, functions and charts
•    Print and manage large workbooks

Excel 2010 Intermediate

Who should take this course?

People who have some experience with Excel and need to summarize data, apply advanced charting and formatting features and use Excel workbooks in collaborative groups.


•    Tables, sorting and filtering, outlining, subtotals and pivot tables.
•    Linking worksheets and workbooks using formulas and functions
•    Formula auditing, workbook protection, change tracking, sharing and comparing workbooks
•    Custom formats and styles, advanced charting techniques

Excel 2010 Advanced

Who should take this course?

People who have experience with Excel and need to use advanced functions, work with data tables, perform what-if analysis and create macros.


•    Financial, logical, date, statistical, lookup and database functions
•    Goal Seek, Solver and Scenarios
•    Running and recording macros

Access 2010 Basics

Who should take this course?

Anyone who needs to learn to use Access to build or manage databases, or who has been using Excel to record data in tables but now needs more sophisticated methods for entering, editing and displaying data.


•    Database concepts, planning and table design
•    Create queries to select, sort, filter and calculate data
•    Design forms to use for viewing, entering and editing data
•    Make and modify reports to print data

PowerPoint 2010 Basics

Who should take this course?

Anyone who has little or no experience with PowerPoint and wants to learn to create slides for effective presentations.


•    Format slides and use drawing tools, pictures, clip art and WordArt
•    Use tables and charts
•    Add transitions, timings and speaker notes
•    Set up, run and print slide shows

Microsoft Project 2010 Fast Track

Who should take this course?

This accelerated course is designed for anyone with little or no experience with MS Project who needs to learn how to create accurate and dynamic project plans, or people finding it difficult to transition from previous versions of Project.


•    Create and schedule tasks
•    Create resources, manage resource allocation conflicts and track costs
•    Manage project and resource calendars
•    Work with tables, views, grouping and sorting

Contact
Joy Fraunfelter
Joy Fraunfelter
215-881-7487
Randy Ingbritsen
Randy Ingbritsen
215-881-7405
Kena Sears
Kena Sears
215-881-7388