Microsoft Office Applications

Related Programs

Are you looking for career advancement?

Advance your career by passing the Microsoft Office Specialist Exams. Students are free to take these exams at any Certiport testing center (see www.certiport.com). The college is a private Certiport testing center which means that we only test PGCC students, faculty and staff. Contact Barbara McCreary at bmccreary@pgcc.edu for information about location and hours.

Comp and Info Tech 1

Prince George's Community College uses the Microsoft Office Suite programs to prepare students for entry level jobs that require them to quickly produce reports, memos, presentations, databases, and spreadsheets. Microsoft Office is a set of interrelated desktop applications that is used by most businesses. Microsoft Word, Excel, Access, Outlook, and PowerPoint are the most commonly used software programs.

Students must bring a Universal Serial Bus (USB) flash drive or portable drive to each class to store lessons and personal files.

Computer Skills for Business Applications Certificate Program
This 6-course program is designed to recognize a student's achievement in the use of a personal computer for general business applications using the Microsoft Office Suite, including applications for word processing, spreadsheet, and data management. The following courses are required to earn the certificate:

  • Introduction to Personal Computers 
  • MS-Word 
  • MS-Excel 
  • MS-Access 
  • MS-PowerPoint 
  • MS-Advanced PowerPoint

Entry-Level Administrative Assistant Certificate Program
This 5-course program is designed to recognize a student's achievement in the area of Microsoft office, office procedures and practices. You will learn how to provide support by conducting research, handling information requests, performing clerical functions, receiving visitors, arranging conference calls, and scheduling meetings. The following courses are required to earn the certificate:

  • Applied Office Skills
  • MS-Word
  • MS-Excel
  • MS-PowerPoint
  • MS Access

Classes

DPR 714 Introduction to Personal Computers     0.6 CEUs
This course is essential for those without any computer experience. Class includes hands-on computer operation and is a must for all beginning users. Textbook: ISBN:978-1-4246-1389-2.
4 sessions, $195.00* (includes a $95 lab fee)

24626 Tu/Th 11/7 - 11/16 6:30 PM - 9:30 PM CE 113

DPR 841 Introduction to Personal Computers with Windows 10     **New course**     1.2 CEUs
Topics include mouse and keyboarding techniques, navigating around the desktop and within programs, demonstrating the different types of programs most commonly used in a work setting, basic techniques for opening, creating, editing and saving documents. Textbook: ISBN 978-1-4246-25787-1
4 sessions, $195 (includes a $95 lab fee)

26041 M/W 9/11 - 9/20 6:30 PM - 9:30 PM CAT 135

DPR 778 Applied Office Skills     0.9 CEUs
This course is essential for administrative assistants and secretaries, who are some of the most in-demand workers in the business world today. Learn how to provide support by conducting research, handling information requests, and performing clerical functions such as receiving visitors, arranging conference calls, and scheduling meetings.
3 sessions, $140* (includes a $20 lab fee)

19588 Tu/Th 8/1-8/8 6:30 PM - 9:30 PM CE 113
24627 Tu/Th 10/10 - 10/17 6:30 PM - 9:30 PM CE 113
24628 Tu/Th 11/28 - 12/5 6:30 PM - 9:30 PM CE 113

DPR 753 Introduction to Windows 7     0.9 CEUs
This hand-on class introduces students to the Windows 7 features that let them personalize their screens. Students will also be taught how they can use their computer's desktop to type and edit text to easily create e-mails or documents, save and organize their work. Textbook: ISBN: 978-1-4246-1283-3
3 sessions, $165* (includes a $55 lab fee)

24625 M/W 10/2 - 10/9 6:30 PM - 9:30 PM CE 113

DPR 825 Introduction to Windows 10.0     *NEW COURSE*     0.9 CEUs
Windows 10 introduces what Microsoft described as a "universal" application architecture; expanding on Metro-style apps, these apps can be designed to run across multiple Microsoft product families with nearly identical code—including PCs, tablets, smartphones, embedded systems, Xbox One, Surface Hub and HoloLens. Textbook: ISBN: 978-1-4246-2558-1

24324 M/W/F 10/23 - 10/27 6:30 PM - 9:30 PM CAT 135


**New Microsoft Office Suite 2016 Classes**

DPR 850 Introduction to Microsoft Office 2016     3.6 CEUs
This course is designed to provide students with the fundamentals of the new office interface and functionality of Microsoft Office 2016. Topics include using the navigation tools in Word, PowerPoint, and Excel; creating and sharing documents; creating presentations; and preparing charts.
6 sessions, $450* (includes a $150 lab fee)

20267 Sat 8/26 - 9/30 9:30 AM - 4:00 PM CE 113

DPR 833 Introduction to Microsoft Word 2016     1.8 CEUs
Topics will include how to create and modify documents; how to add, move through, change the size or appearance of text, and print your documents.
6 sessions, $270* (includes a $95 lab fee)

20909 Tu/Th 9/5 - 9/21 6:30 PM - 9:30 PM CAT 135

DPR 830 Introduction to Microsoft Excel 2016     1.8 CEUs
Topics include the Excel interface, exploring shortcuts for efficiency, creating worksheets, charts and graphs, utilizing functions to determine formulas and statistics, and using macros.
6 sessions, $270* (includes a $95 lab fee)

19923 Tu/Th 7/25 - 8/10 6:30 PM - 9:30 PM CAT 215
20908 Tu/Th 10/3 - 10/19 6:30 PM - 9:30 PM CAT 105

DPR 851 Intermediate Excel 2016, Level 2     1.8 CEUs
This is the second in the series of courses designed to provide instruction on using the more advanced features of Microsoft Excel 2016. Topics include how to calculate data with advanced formulas, organizing worksheet and table data, presenting data using charts, analyzing data using pivot tables, slicers, and pivot charts, and more. Students should bring a USB-compatible flash drive to each class.
6 sessions, $270* (includes a $95 lab fee)

20268 Tu/Th 11/28 - 12/14 6:30 PM - 9:30 PM CAT 105

DPR 831 Introduction to Power Point 2016     0.6 CEUs
Topics include creating presentations, formatting slides, using drawing objects, working with graphics, using tables and charts modifying presentations and proofing and delivering presentations.
2 sessions, $110* (includes a $50 lab fee)

19921 M 7/24 - 7/31 6:30 PM - 9:30 PM CAT 215
20906 Sat 9/9 - 9/16 9:30 AM - 12:30 PM CAT 105

DPR 832 Advanced Power Point 2016     0.6 CEUs
Topics include customizing PowerPoint, using graphics and multimedia, customizing SmartArt graphics, tables and charts, distributing presentations and integrating Microsoft Office files.
2 sessions, $110* (includes a $50 lab fee)

19922 Tu/Th 8/7 - 8/14 6:30 PM - 9:30 PM CAT 135
20906 Sat 10/7 - 10/14 9:30 AM - 12:30 PM CAT 105

DPR 852 Introduction to MS Access 2016     1.8 CEUs
This course introduces the Microsoft Access 2016 database program. The program enables one to design and create databases that allow for presentation, analysis, and sharing of data. Students should bring a USB-compatible flash drive to each class. Prerequisite: students should be familiar with using personal computers and have used a mouse and keyboard.
6 sessions, $270* (includes a $95 lab fee)

20269 Tu/Th 10/31 - 11/16 6:30 PM - 9:30 PM CAT 105

DPR 857 Introduction to Microsoft Project 2016     1.8 CEUs
This course, designed for project managers, will focus on using Microsoft Project 2016. Topics include plan, implement and control projects; sequencing tasks; producing a baseline, and assigning resources and costs; tracking progress; analyzing variances and revising project plan.
6 sessions, $270* (includes a $95 lab fee)

20986 Tu/Th 10/31 - 11/16 6:30 PM - 9:30 PM CAT 135

DPR 858 Advanced Microsoft Project 2016     1.2 CEUs
Students will be taught how to use the more advanced features of Microsoft Project 2016 to manage and customize project plans during the implementation stage of a project. Topics include tracking a project from start to finish, evaluating individual tasks and assigned schedules, analyzing project progress and overall project success.
6 sessions, $265* (includes a $95 lab fee)

20987 M/W 11/20 - 12/11 6:30 PM - 9:30 PM Largo

DPR 856 Introduction to Microsoft Outlook 2016     1.2 CEUs
This course is designed to provide training to use the 2016 version of Microsoft Outlook. Topics include customizing command sets, setting global options, performing advanced searches,applying filters to intercept mail and control spam, creating rules to automate many management tasks, working with calendars and contacts, managing tasks, protecting data with archiving and data files.
4 sessions, $195* (includes a $95 lab fee)

20985 F 10/6 - 10/27 6:30 PM - 9:30 PM CAT 105

DPR 790 Introduction to Microsoft Word 2013: Level 1     1.8 CEUs
Topics include how to create, edit, format, and print a document using the basic features of Word.
6 sessions, $270* (includes a $9 lab fee)

21629 Sat 10/14 - 10/28 9:00 AM - 3:30 PM UTC

DPR 782 Introduction to Microsoft Excel 2013: Level 1     1.8 CEUs
Understand basic formatting techniques and functions. Learn how to use the help system and navigate worksheets and workbooks.
6 sessions, $270* (includes a $95 lab fee)

21628 Sat 11/11 - 12/2 9:00 AM - 3:30 PM UTC

DPR 783 Intermediate Microsoft Excel 2013: Level 2     1.8 CEUs
Topics include how to calculate date with advanced formulas, organizing worksheet and table date, presenting data using charts, analyzing data using pivot tables, slicers, and pivot charts.
6 sessions, $270* (includes a $95 lab fee)

19745 Tu/Th 8/1 - 8/17 6:30 PM - 9:30 PM CAT 105

DPR 787 Introduction to PowerPoint 2013     0.6 CEUs
This class covers the introductory functions of the presentation software, MS PowerPoint.
2 sessions, $110* (includes a $50 lab fee)

21630 M 9/18 - 9/25 6:30 PM - 9:30 PM UTC

DPR 784 Advanced PowerPoint 2013     0.6 CEUs
Continue your study of the presentation software, Microsoft PowerPoint.
2 sessions, $110* (includes a $50 lab fee)

21627 M 10/2 - 10/9 6:30 PM - 9:30 PM UTC