Office Administration Specialist - American Tech Institute

Office Administration Specialist

Course Description:

This program consists of five courses. Each course leads to eligibility for an industry certification. Students will gain basic hands-on experience using the integrated programs of Version 1.3 September 2020 33 Microsoft Office 2016. All these five programs are designed to use the basic 2016 features of Word, Excel, Outlook, Access and PowerPoint, and to integrate data between the applications. Students will be able to do such tasks as create spreadsheets; compose correspondence; and create presentations, reports, and documents using these applications. This program gives the students the education and tools needed to enter or enhance administrative careers by giving them the necessary training to earn their Microsoft Office Specialist (MOS) Certification exams and The American Technical Institute (TATI) Administrative specialist Certificate. TATI does not guarantee a student a passing score on the industry Certification exams.

Learning Objectives

Upon successfully completing the Office Administration program, the student will be able to:

  • Use the 2016 Microsoft Office applications, namely Word, Excel, OutLook, Access and PowerPoint
  • Apply the integrated data between Microsoft Office, namely Word, Excel, OutLook, Access and PowerPoint
  • Create spreadsheets and presentations
  • Compose correspondence reports and documents using these applications.

Admission Requirements

The applicants must have High school diploma or GED


325 Clock Hours

Core Programs include:
Why Office Administration?

In a business world dominated by evolving technologies and rapidly changing strategies, business owners large and small depend on office administrators. An administrative professional’s daily activities may include database utilization, company correspondence, mail distribution, presentation preparation, accounts payable/receivable, and much more. At The American Technical Institute, The Office Administration curriculum prepares individuals for positions in administrative support careers. It equips office professionals to respond to the demands of a dynamic computerized workplace.

Students will complete courses designed to develop proficiency in the use of integrated software, oral and written communication, analysis and coordination of office duties and systems, and other support topics. Emphasis is placed on non-technical as well as technical skills.

Graduates should qualify for employment in a variety of positions in business, government, and industry. Job classifications range from entry-level to supervisor to middle management.

Microsoft Excel

Microsoft Excel is a spreadsheet application, typically used to display and manipulate numerical data. Microsoft Excel provides data organization and analysis tools that enables you to sort, extract and generate charts from spreadsheet data.

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

Microsoft Word

Microsoft Word is the de facto standard in business for creating documents such as letters, invitations, term papers, flyers, resumes, novels and other documents.

Microsoft Word training at The American Technical Institute will help you develop or improve your Microsoft Word skills so that you are able to make the most of this industry standard application.

Microsoft Access

Microsoft Access is a database tool for gathering and understanding all of your information such as phone numbers, inventory and even guest lists, providing a convenient way to enter, navigate and report your data.

Microsoft Powerpoint

Microsoft PowerPoint enables you to create dynamic presentations through the use of text, graphics and animation. Slide presentations created with the software are often displayed on projection screens for business, training or educational presentations.

Microsoft Outlook

Microsoft Outlook is the world’s most popular application for email, calendars, and contacts. The Outlook desktop application works with both your personal and work email.

Office Administration Courses

65 Clock Hours
This course covers these topics: creating and managing documents, formatting texts, paragraphs, creating and managing tables, lists, and references, inserting and formatting graphic elements.

65 Clock Hours
This course covers these topics: creating and managing worksheets and workbooks, managing data cells and ranges, creating tables, performing operations with formulas and functions, and creating charts and objects.

65 Clock Hours
This course covers these topics: creating and managing presentations, inserting and formatting text, shapes, and images, inserting tables, charts, SmartArt, and media, and applying transitions and animations.

65 Clock Hours
This course covers these topics: creating and managing a database, building tables, creating queries, creating forms and reports. Upon completing this course, the student will be able to

  • Create and manage a database
  • Build tables
  • Create queries
  • Create forms
  • Create reports

65 Clock Hours
This course covers these topics: Managing the Outlook environment for productivity, messages, schedules, contacts and groups