Skip Navigation
 

Microsoft Office Applications

Online Undergraduate Certificate in Microsoft Office Applications

Save @ APU

$0 Application Fee
$0 Transfer Credit Evaluation
$0 Textbooks & eBooks

About This Program

The undergraduate certificate in Microsoft Office applications from American Public University (APU) offers a basic foundation in the principles, practices, features, and functions of Microsoft Office word processing, spreadsheet, presentation, and communications applications. With this online certificate, you’ll enhance your understanding of internet concepts, technology trends, and emerging web 2.0 technologies.

This online certificate in Microsoft Office applications is applicable to a wide variety of different industry fields, including business, education, technology, medicine, science, and education. In addition, it is good preparation if you seek Microsoft Office Specialist (MOS) certification online in Word, Excel, PowerPoint, and Outlook.

NOTE: Completion of this program does not award any professional certifications, but may be helpful in preparing to earn such certifications.

What You Will Do

  1. Understand how Microsoft Office applications have impacted IT management and office productivity, collaboration, and security
  2. Use Microsoft Word to create lists, themes, mail merges, watermarks, templates, graphics, navigation tools, tables, charts, citations, and bibliographies
  3. Learn how to create and format spreadsheets, manipulate data, and use formulas, charts, conditional logic, graphics, and security features in Microsoft Excel
  4. Set up presentations, transitions, animations, and timing with Microsoft PowerPoint and enhance your knowledge of how Microsoft Outlook can be used to follow up, categorize, and set up rules and program alerts
  5. Demonstrate use of Microsoft Access Relational Database Management System (RDBMS to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation

Degree at a Glance

Number of Credits
18
Cost Per Credit
$285 | $250*
Courses Start Monthly
Online

Program Requirements Printable Catalog Version

Must take all courses for this section.

Course ID: 2618

|
This course focuses on the role, function, and operations of relational databases in the management of information. The course will be taught from a mixture of analytical and practical methods. This course introduces the student to the concepts of relational databases and to the principles of relational database design in the context of the Microsoft Access Relational Database Management System (RDBMS). Students will apply their knowledge of the principles of data design and database engineering to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation. They will examine the rudiments of referential integrity and normalization, and apply this knowledge to design the database tables that implement validation rules to ensure application integrity. They will also examine and develop advanced queries such as: top values, list of values, cross tab, find duplicates, and find unmatched. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. The book meets the topical requirements for the Microsoft Office Specialist (MOS). Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.
Registration Dates Course Dates Session Weeks
02/22/21 - 07/30/21 08/02/21 - 09/26/21 Summer 2021 Session I 8 Week session
03/29/21 - 09/03/21 09/06/21 - 10/31/21 Summer 2021 Session D 8 Week session
05/21/21 - 10/29/21 11/01/21 - 12/26/21 Fall 2021 Session I 8 Week session
07/27/21 - 12/31/21 01/03/22 - 02/27/22 Winter 2022 Session B 8 Week session

Course ID: 3830

|
This course is a study of the concepts and technology trends essential to office productivity applications. Students will explore the principles, practices, features, and functions of the word processing application in the Microsoft Office Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft Word to create and format documents; and use lists, themes, mail merge, watermarks, templates, graphics, navigation tools, tables, charts, citations and bibliographies. Students may access MS Office 365 Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty.
Registration Dates Course Dates Session Weeks
02/22/21 - 07/30/21 08/02/21 - 09/26/21 Summer 2021 Session I 8 Week session
03/29/21 - 09/03/21 09/06/21 - 10/31/21 Summer 2021 Session D 8 Week session
04/26/21 - 10/01/21 10/04/21 - 11/28/21 Fall 2021 Session B 8 Week session
05/21/21 - 10/29/21 11/01/21 - 12/26/21 Fall 2021 Session I 8 Week session
06/28/21 - 12/03/21 12/06/21 - 01/30/22 Fall 2021 Session D 8 Week session
07/27/21 - 12/31/21 01/03/22 - 02/27/22 Winter 2022 Session B 8 Week session

Course ID: 3831

|
This course is a study of the concepts and technology trends essential to office productivity applications. Students will explore the principles, practices, features, and functions of the electronic spreadsheet application in the Microsoft Office Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft Excel to create and format spreadsheets; they will also manipulate data and use formulas, charts, workbooks, styles, hyperlinks, themes, functions, conditional logic, graphics, comments, and security features. Students will participate in an engaging learning experience that aligns with Microsoft’s Exam. The course content maps to the Microsoft Office Specialist (MOS): to Microsoft Office Excel Certification. Students may access MS Office 365 Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty.
Registration Dates Course Dates Session Weeks
02/22/21 - 07/30/21 08/02/21 - 09/26/21 Summer 2021 Session I 8 Week session
03/29/21 - 09/03/21 09/06/21 - 10/31/21 Summer 2021 Session D 8 Week session
04/26/21 - 10/01/21 10/04/21 - 11/28/21 Fall 2021 Session B 8 Week session
05/21/21 - 10/29/21 11/01/21 - 12/26/21 Fall 2021 Session I 8 Week session
06/28/21 - 12/03/21 12/06/21 - 01/30/22 Fall 2021 Session D 8 Week session
07/27/21 - 12/31/21 01/03/22 - 02/27/22 Winter 2022 Session B 8 Week session

Course ID: 3832

|
This course is a study of the concepts and technology trends essential to office presentation, communication and productivity applications. Students will explore the principles, practices, features, and functions of PowerPoint, the presentation application in the Microsoft Office Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft PowerPoint to build and format presentations; and to use styles, templates, lists, tables, charts, hyperlinks, transitions, animations, graphics, multimedia, and digital signatures. They will also rehearse the timing of the presentation and prepare presentations for the Web. Students will participate in an engaging learning experience that aligns with Microsoft’s Exam. Students may access MS Office 365 Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty.
Registration Dates Course Dates Session Weeks
02/22/21 - 07/30/21 08/02/21 - 09/26/21 Summer 2021 Session I 8 Week session
03/29/21 - 09/03/21 09/06/21 - 10/31/21 Summer 2021 Session D 8 Week session
04/26/21 - 10/01/21 10/04/21 - 11/28/21 Fall 2021 Session B 8 Week session
05/21/21 - 10/29/21 11/01/21 - 12/26/21 Fall 2021 Session I 8 Week session
06/28/21 - 12/03/21 12/06/21 - 01/30/22 Fall 2021 Session D 8 Week session
07/27/21 - 12/31/21 01/03/22 - 02/27/22 Winter 2022 Session B 8 Week session

Course ID: 3833

|
This course is a study of the concepts and technology trends essential to office communication. Students will explore the principles, practices, features, and functions of Outlook, the electronic mail application in the Microsoft Office Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will customize the Outlook program; and use messages, signatures, advanced email tools, digital signatures, delivery options, voting capabilities, mail management, rules, contacts, calendar functions, meetings, and tasks. Students will participate in an engaging learning experience that aligns with Microsoft’s Exam. Students may access MS Office 365 Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty.
Registration Dates Course Dates Session Weeks
02/22/21 - 07/30/21 08/02/21 - 09/26/21 Summer 2021 Session I 8 Week session
04/26/21 - 10/01/21 10/04/21 - 11/28/21 Fall 2021 Session B 8 Week session

Course ID: 4537

|
This course is a study of the applicable skills and technology essential to application software integration. Students will explore the principles, practices, features, and functions of application software processing in the Microsoft Office Suite. The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft Word, Excel, PowerPoint, Outlook, and Access to create and format documents; build databases and spreadsheets; and design in Outlook and Access to create and format documents; build databases and spreadsheets; and design and publish advertising and marketing documents on customized Websites through the use of hypothetical and real-world scenarios and problems. The course will allow students to experience a more comprehensive understanding of commonly used applications software and how they integrate to provide solutions. Students may access MS Office 365 Suite via their MyCampus account for FREE in the classroom. Microsoft Office 365 is free to students and faculty. The Office 365 suite is available to students for FREE using Apple and Windows computers. However, the Access program in Microsoft Office 365 suite cannot be purchased or used on Macintosh computers—MS ACCESS is for the Windows operating system only.
Registration Dates Course Dates Session Weeks
02/22/21 - 07/30/21 08/02/21 - 09/26/21 Summer 2021 Session I 8 Week session
03/29/21 - 09/03/21 09/06/21 - 10/31/21 Summer 2021 Session D 8 Week session
04/26/21 - 10/01/21 10/04/21 - 11/28/21 Fall 2021 Session B 8 Week session
05/21/21 - 10/29/21 11/01/21 - 12/26/21 Fall 2021 Session I 8 Week session
06/28/21 - 12/03/21 12/06/21 - 01/30/22 Fall 2021 Session D 8 Week session
07/27/21 - 12/31/21 01/03/22 - 02/27/22 Winter 2022 Session B 8 Week session

Courses Start Monthly

Next Courses Start Aug 2
Register by Jul 30

Admission Requirements

  • All APU undergraduate programs require a minimum of a high school diploma or equivalent (i.e., GED).
  • Please read all undergraduate admission requirements before applying to this program and be prepared to submit the required documentation.
  • There is no fee to complete the APU admission application. View steps to apply.

Materials Cost

Technology fee: $65 per course | $0 for active-duty military, National Guard members, and Reservists.

Need Help?

Selecting the right program to meet your educational goals is a key step in ensuring a successful outcome. If you are unsure of which program to choose, or need more information, please contact an APU admissions representative at 877-755-2787 or info@apus.edu.

Quality Education Should Be Affordable

So you can focus on the opportunities ahead, without the financial burden of more expensive schools who are not as invested in your success. Learn more about paying for school.

Consumer Information

Department of Education and State Disclosures

For information on costs, median debt, state licensure requirements and more, view the gainful employment disclosures and the program disclosures for Maryland residents.

 

*Cost Per Credit Hour

To minimize out-of-pocket costs, U.S. active-duty servicemembers, their spouse/dependents, National Guard members, and Reservists receive a tuition grant that caps undergraduate, master's degree, and graduate certificate tuition at $250/credit hour. In addition, a university book grant provides no-cost textbooks and ebooks for all undergraduates and military-tuition-grant-eligible master’s-level students.
See all military student benefits.