Administrative Office Assistant Master

Hours: 620 / Access Length: 12 Months / Delivery: Online, Self-Paced
Online Hours: 620
Retail Price: $3,775.00

Course Overview:

In this course, we will discuss and become proficient in the skills necessary to succeed as an administrative office assistant, including office etiquette, reception skills, technology, correspondence, calender management, bookkeeping, travel planning, and other duties performed by an assistant.

This course will provide an introduction to the concepts and uses of accounting in a business environment. The primary areas of study in this course include analysis of business transactions, recording procedures and the use of ledgers and journals, accounting for sales and purchases, managing cash, payroll, accruals and deferrals, and preparation and analysis of basic financial statements. After completing this course, students will have solid understanding of business and financial accounting and its role in bookkeeping administration.

In this course, you will learn how to use QuickBooks Online plus by completing two monthly accounting cycles. In the first lessons, accounting for selling service items will be covered. In later lessons, both service items and inventory items that are sold will be covered. Preparing payroll and creating a new company will also be included. Prior to taking this course, you should be familiar with the accounting cycle and how it is related to a business. While no prior knowledge of QuickBooks Online is required, it will be beneficial to have an understanding of accounting principles.

The majority of this course will be conducted through drill exercises and related practice activities and quizzes based on the knowledge you have gained through completing each chapter. Be prepared for a thorough, and extensive hands-on experience throughout the journey of completing this QuickBooks course. While the reading requirements are light, each chapter contains a number of drills that you must complete, as well as the practice activities assigned and lesson quiz.

This Microsoft Office Suite 2021 bundle includes: Microsoft Word 2021, Microsoft Excel 2021, Microsoft Outlook 2021, and Microsoft PowerPoint 2021.  

Students are eligible for a free 365 day copy of Intuit QuickBooks Online Plus from the
Intuit Education Program in order to follow along with the course content.

The Microsoft Office 365 - Suite 2021 course covers Word 2021, Excel 2021, PowerPoint 2021, and Outlook 2021.   Students will receive a free one year license from the date of their enrollment to use to complete these courses. ($69.99 value)

This course prepares students to take the Intuit QuickBooks Certified User Online and Microsoft Office Suite (MOS) Specialist certification exams.

Course Outline:

Administrative Office Assistant Career Prep Curriculum:

Lesson 1: The Office Environment

Lesson 2: Communication Skills

Lesson 3: Processing and Understanding Financial Information

Lesson 4: Personal and Professional Time Management

Lesson 5: Document and Records Management

Lesson 6: Career Management

Fundamentals of Accounting Curriculum:

Lesson 1: Introduction to Accounting

Lesson 2: Analyzing Business Transactions

Lesson 3: Recording Transactions

Lesson 4: Accounting for Sales and Purchases

Lesson 5: Payroll

Lesson 6: Accruals, Deferrals and the Worksheet

Lesson 7: Financial Statements and Closing Procedures

Intuit QuickBooks Online Plus Curriculum:

Lesson 1: Introduction to QuickBooks Online Plus

Lesson 2: Create a Company

Lesson 3: Sales and Receivables: Service Items

Lesson 4: Payables and Purchases

Lesson 5: General Accounting and End-of-Period Procedures

Lesson 6: Sales and Receivables: Product and Service Items

Lesson 7: Payables, Purchases and Inventory

Lesson 8: General Accounting, End-of-Period Procedures, and Budgets

Lesson 9: Payroll

Lesson 10: Quickbooks Desktop, Mobile and Additional Features

Microsoft Office 365 - Word 2021 Curriculum:

Lesson 1: Creating and Modifying a Flyer

In this lesson, we will start by opening a Microsoft Word document, entering text, and inserting images into Word. This lesson culminates in the creation of a business flyer.

Lesson 2: Creating a Research Paper and a Multi-Page Document

In this lesson, we will learn the skills needed to successfully create a research paper in Microsoft Word. Changing line spacing, using shortcuts, creating a bibliography, and working with comments in a document will all be covered. We will also learn to work with multi-page documents, including creating a cover page and editing lists and tables.

Lesson 3: Creating a Business Letter and Using Mail Merge

In this lesson, we will learn how to create a business letter, including creating a letterhead and printing envelopes. We will learn the mail merge function to customize form letters and address envelopes.

Lesson 4: Creating a Resume and a Newsletter

In this lesson, we will work with a template to create a resume and create and format a newsletter.

Lesson 5: Using Collaboration and Creating a Reference Document

In this lesson, we will explore how to create charts in Microsoft Word. We will explore collaboration techniques, including blogging, and how to link a Microsoft Excel spreadsheet to a Word document. We will also work on creating a reference document, with proper navigation.

Lesson 6: Creating an Online Form and Using Macros

In this lesson, we will learn how to create a template and create an online form for electronic distribution. We will then learn more advanced features of online forms, using Macros.

Microsoft Office 365 - Excel 2021 Curriculum:

Lesson 1: Creating a Worksheet

In this lesson, we will start by opening a Microsoft Excel spreadsheet and learn how to navigate the document. We will enter text, format the cells, and save a project.

Lesson 2: Working with Formulas and Large Worksheets

In this lesson, we will learn how to enter formulas in the spreadsheet and verify the formulas using Range Finder. We will also use the IF function to perform a logical test and freeze and unfreeze rows and columns.

Lesson 3: Financial Functions and Working in Multiple Spreadsheets

In this lesson, we will learn how to use the financial functions of Microsoft Excel, such as Amortization schedules and the mortgage payment calculator. We will also create a consolidated worksheet and learn to work across several spreadsheets.

Lesson 4: Creating Tables and Templates

In this lesson, we will learn how to create, format, and sort tables. We will also work with templates, import data, and work with SmartArt.

Lesson 5: Using PivotTables and Complex Problem Solving

In this lesson, we will learn some more advanced features, such as PivotTables and other Excel charts. We will also learn how to perform complex problem-solving and customize Excel add-ins.

Lesson 6: Data Analysis and User Interfaces

In this lesson, we will learn how to use Macros in Microsoft Excel and perform other data analysis. We will also learn how to collaborate in Microsoft Excel and create a custom theme.

Microsoft Office 365 - PowerPoint 2021 Curriculum:

Lesson 1: Creating and Editing Presentations with Pictures

In this lesson, we will start by opening Microsoft PowerPoint, creating a title slide, and adding additional slides. We will also start working with images by inserting them, and resizing pictures. This lesson concludes with learning how to save and print a PowerPoint file.

Lesson 2: Enhancing Presentations with Shapes, SmartArt, WordArt, Charts, and Tables

In this lesson, we will learn how to build onto and enhance presentations with a variety of tools in Microsoft PowerPoint. We will learn about themes in PowerPoint, as well as adding elements such as SmartArt, WordArt, charts, and tables.

Lesson 3: Customizing Slide Masters and Collaborating

In this lesson, we will learn how to create a master slide and presentation and customize slide elements. We will also learn how to collaborate in Microsoft PowerPoint and animate content on the slides. 

Lesson 4: Tables and Charts

In this lesson, we will work on inserting graphics from a file, and drawing and formatting tables. We will also insert a linked spreadsheet from Excel, and learn to modify and format a linked Excel chart.

Lesson 5: Adding Media to a Presentation

In this lesson, we will explore how to enhance presentations by adding a variety of media. We will also learn how to create graphics and add action buttons to make a professional presentation.

Lesson 6: Delivering the Presentation

In this lesson, we will learn best practices in delivering the presentation. Topics will include printing and saving the presentation and creating a customized slide show.

Microsoft Office 365 - Outlook 2021 Curriculum:

Lesson 1: Managing Email Messages

In this lesson, we will start by adding a Microsoft account to Outlook and work on composing an email message.  We will also reply to a message, and learn how to attach a file to a message, create and move messages into folders, and check spelling as you type in Outlook.

Lesson 2: Managing Calendars

In this lesson, we will learn how to work with calendars in Outlook. Topics include creating and scheduling appointments, meetings, and events, and sharing your calendar.

Lesson 3: Managing Contacts and Personal Contact Information

In this lesson, we will learn how to work with contacts in Microsoft Outlook. We will view and sort a contact list, edit a contact, and learn about creating contacts in various ways. 

Lesson 4: Tasks

In this lesson, we will work on the task function in Microsoft Outlook.  Topics will include categorizing and managing tasks, categorizing email messages, and working with display and print views.

Lesson 5: Customizing Outlook

In this lesson, we will explore how to customize Outlook. We will customize email messages, create signatures and stationery, and customizing the calendar.

All necessary materials are included.

Certification(s):

This course prepares students to take the Intuit QuickBooks Certified User Online and Microsoft Office Suite (MOS) Specialist certification exams.

System Requirements:

Internet Connectivity Requirements:

• Cable, Fiber, DSL, or LEO Satellite (i.e. Starlink) internet with speeds of at least 10mb/sec download and 5mb/sec upload are recommended for the best experience.

NOTE: While cellular hotspots may allow access to our courses, users may experience connectivity issues by trying to access our learning management system.  This is due to the potential high download and upload latency of cellular connections.   Therefore, it is not recommended that students use a cellular hotspot as their primary way of accessing their courses.

Hardware Requirements:

• CPU: 1 GHz or higher
• RAM: 4 GB or higher
• Resolution: 1280 x 720 or higher.  1920x1080 resolution is recommended for the best experience.
• Speakers / Headphones
• Microphone for Webinar or Live Online sessions.

Operating System Requirements:

• Windows 7 or higher.
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions
  

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

Basic Software Requirements (These are recommendations of software to use):

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is described in the above course outline.