View Text Only Version

CPE Course Catalog

Course Details

Contact CPE Course Catalog  

CPE Course Catalog

The Graduate Center
1160 McDermott Drive
West Chester PA, 19380

Phone: 610-425-7435

Microsoft Courses

Microsoft Courses


Let WCU know your desired IT topic for technical training and we will locate the Microsoft Subject Matter Expert to bring to your site or hold at our location for the best cost. Courses must have a minimum of 6-8 attendees. Call to discuss your organization's specific Microsoft topic for your IT staff. Below, are the more frequently requested one day MS courses. All topics may be tailored in both content and length. When inquiring, please specify MS Office version.

MS Access Level 1 is designed for students who wish to learn the basic operations of the Access database program to perform their responsibilities and understand the advantages a relational database can bring to their business processes. Attendees will learn how to manage data, create a new database, construct tables, design forms and reports, and create queries to join, filter, and sort data.

MS Access Level 2 expands knowledge of database design, writing advanced queries, structure existing data, share data across applications and customize reports. Expanding and applying your new skills will result in a more robust, functional database for your users. Recommended for students who may be pursuing the MS MOS Expert level of certification.

MS Access Level 3 teaches advanced Access features such as database management, advanced form design, packaging a database, encryption, preparing for multi-user access and more. Knowledge of these features separate database professionals from the casual database user and provide the attendee with marketable jobs skills as well as preparing the student to take the MOS Certification exam.

MS Excel Level 1 is designed for those who desire to gain the skills necessary to create, edit, format and print basic Excel worksheets. You will gain a foundational understanding of the basic functionality in Excel and begin navigating the environment. Attendees will use formulas and functions to perform calculations in worksheets and modify by manipulating cells and data, while searching for and replacing data. Begin to work with larger workbooks containing multiple worksheets and learn how to customize Excel to meet your needs.

MS Excel Level 2 is for students who desire the skills necessary to create templates, sort and filter data, import, export and analyze data plus work with Excel on the web. Learn how to create advanced formulas and organize data into tables. Discover the power of PivotTables and PivotCharts and how slicers can make data filtering easy while visualizing your data. Additionally, learn to analyze data with lookup functions and other enhancements.

MS Excel Advanced will extend participants' knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets and sharing data with other applications. This course, as well as Levels 1 & 2 can be used to prepare for the MS Specialist (MOS) Certification Exam.

MS Office Level 1 is designed for any person with a basic understanding of Microsoft Windows who needs to use Microsoft® Outlook® to compose and send email, schedule appointments and meetings, manage contact information and tasks and use notes.

MS Office Level 2 will explore how to customize the environment, schedule appointments & events, manage and organize activities, share and work with multiple calendars, schedule meetings and create tasks and manage the advanced settings when working with email messages.

MS Office 2016 Transition - This course builds upon the foundational Microsoft® Office 2007/2010 knowledge and skills you've already acquired. It focuses on the enhanced features to improve the way you manage, organize, present and distribute company data and information. Explore a variety of enhancements from Word's ability to edit PDF files to the new Flash Fill functionality in Excel that dramatically increases the speed when adding data to a spreadsheet. Discover how the Cloud has been deeply integrated into the Office experience and how collaborating with colleagues has never been easier.

MS Outlook Part 1 will help attendees become familiar with the Outlook interface, and then use Outlook to manage email communications, including composing, reading, and responding to emails; schedule appointments and meetings; manage contact information; schedule tasks and create notes; and customize the Outlook environment to suit personal preferences.

MS Outlook Part 2 will explore the advanced features provided with the Outlook interface, such as advanced message, calendar and contacts management. Use the Tasks and Journal workspaces provided in the application to manage task assignments to you and others, and to record interactions with colleagues. Learn to share workspaces with other users, and use Outlook data files to save and back up your important information.

MS PowerPoint Level 1 explores the PowerPoint environment and teaches attendees how to create a new presentation to convey the key points of a message through the use of text, graphics and animation. Learn how to format text on multiple slides to enhance clarity, enhance the visual appeal, add and modify graphical objects, add tables and charts to present data in a structured form and finalize the presentation for delivery.

MS PowerPoint Level 2 course is for students who desire the skill to work with design templates, various types of hierarchies, processes or other diagrams, special effects, web presentations and advanced presentation delivery. In addition, attendees will modify the PowerPoint environment, customize design templates, add SmartArt; work with media as well as collaborate on a presentation to distribute a secure presentation.

MS Project Part 1 - covers the critical knowledge and skills a project manager needs to create a project plan with Project during the planning phase. Attendees will start a project, work with calendars, to manage tasks and resources. Learn to customize Project interface, manage time frames, assign tasks and level work resources. In addition, they will add summary tasks and milestones to share and export their projects for delivery.

MS Project Part 2 - is built around executing, monitoring and controlling tasks accomplished using the advanced commands found on Project tabs. Learn to manage the Project environment with links, customized fields and options. Manage task structures and create network diagrams, custom views, critical paths and analyze earned value to share your timeline views.

MS Publisher Level 1 - Publisher is a desktop publishing software application capable of producing certificates, newsletters and other printed publications. Publisher offers a large selection of "building blocks" that can be dragged into your documents helping to create page elements such as calendars, newsletter sidebars and borders. Publisher integrates mail merge features which is handy when sending publications to customer lists. Learn to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.

MS SharePoint for Power End Users - This 4-day class combines topics from Site Member and Site Owner courses, to provide comprehensive training that will present students with a ground-up understanding for how to use, operate and build sites in a SharePoint Server environment. The course may be tailored with topics of your choosing; call for a detailed course outline. Choose from the following topics:

  • Structuring document & content management
  • Creating & managing workflows
  • Creating & managing content types
  • Finding content
  • Office integration features
  • Overview of new SharePoint features
  • List basics
  • Library basics
  • Create sites & webpages
  • Secure SharePoint sites
  • Site administration & settings
  • Site creation & deletion
  • Collaborative site templates
  • Using SharePoint publishing sites

MS Word Level 1 is designed to help us move smoothly through the task of creating professional looking documents. Students will learn how to use Word to create and edit simple documents, format, add tables and lists; add design elements and layout options; and proof documents.

MS Word Level 2 will help attendees work with tables and charts to organize and summarize data. Learn to use styles and themes to customize and add images and graphics to further display information. Discover how to add building blocks of information and updatable fields to the document to improve efficiency. Control how text flows around graphics, between paragraphs and pages while using section, page and column breaks to maintain consistency. Learn the mail merge feature to personalize content. Additionally, learn how to create and use macros to automate tasks.

Back to top of page.