Administrative Office Assistant Master

620 Hours / Access Length: 12 Months / Delivery: Online, Self-Paced

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 2016 bundle includes: Microsoft Word 2016, Microsoft Excel 2016, Microsoft Outlook 2016, Microsoft PowerPoint 2016, and Microsoft Access 2016.

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.

** Students will need a copy of Microsoft Office 2016 to follow along with the Microsoft Office Suite 2016 course.

This course can help you prepare 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 Access 2016 Curriculum:

Access Beginner                   

• 1.1 Introduction Part 1
• 1.2 Introduction Part 2
• 1.3 Elements Part 1
• 1.4 Elements Part 2
• 1.5 Reviewing Data
• 1.6 Queries Part 1
• 1.7 Queries Part 2
• 1.8 Tracking Time Part 1
• 1.9 Tracking Time Part 2
• 1.10 Tracking Time Part 3
• 1.11 Design Work With Forms

Access Intermediate

• 1.1 Relationships Part 1
• 1.2 Relationships Part 2
• 1.3 Changing Information
• 1.4 Loading Tables
• 1.5 Relating Invoices Part 1
• 1.6 Relating Invoices Part 2
• 1.7 Relating Invoices Part 3
• 1.8 Relating Invoices Part 4
• 1.9 Time Entry Form

Access Advanced

• 1.1 Queries Part 1
• 1.2 Queries Part 2
• 1.3 Queries Part 3
• 1.4 Queries Part 4
• 1.5 Reports Based On Queries
• 1.6 Adding Additional Information
• 1.7 Update Query Part 1
• 1.8 Update Query Part 1
• 1.9 Creating A Report From Scratch Part 1
• 1.10 Creating A Report From Scratch Part 2
• 1.11 Creating A Report From Scratch Part 3

Microsoft Office Excel 2016 Curriculum:

Excel Beginner

• 1.1 Tabs And Ribbons Part 1
• 1.2 Tabs And Ribbons Part 2
• 1.3 Cells Part 1
• 1.4 Cells Part 2
• 1.5 Cells Part 3
• 1.6 Cells Part 4
• 1.7 Calculations Part 1
• 1.8 Calculations Part 2
• 1.9 Calculations Part 3
• 1.10 Printing Part 1
• 1.11 Printing Part 2

Excel Intermediate

• 1.1 Menus And Keyboard Shortcuts Part 1
• 1.2 Menus And Keyboard Shortcuts Part 2
• 1.3 Menus And Keyboard Shortcuts Part 3
• 1.4 Tabs Part 1
• 1.5 Tabs Part 2
• 1.6 Formulas And Calculations Part 1
• 1.7 Formulas And Calculations Part 2
• 1.8 Formulas And Calculations Part 3
• 1.9 Formulas And Calculations Part 4
• 1.10 Importing Data Part 1
• 1.11 Importing Data Part 2
• 1.12 Invoices

Excel Advanced

• 1.1 Advanced Invoice Part 1
• 1.2 Advanced Invoice Part 2
• 1.3 Advanced Invoice Part 3
• 1.4 Advanced Invoice Part 4
• 1.5 Number Crunching
• 1.6 Creating A Pivot Table From Scratch
• 1.7 Smaller Excel Components Part 1
• 1.8 Smaller Excel Components Part 2
• 1.9 Smaller Excel Components Part 3

Microsoft Office Outlook 2016 Curriculum:

Outlook Beginner

• 1.1 Introduction Part 1
• 1.2 Introduction Part 2
• 1.3 Options For Displaying Email Messages
• 1.4 Create And Send An Email
• 1.5 Receive An Email
• 1.6 Calendar Part 1
• 1.7 Calendar Part 2
• 1.8 Contacts Part 1
• 1.9 Contacts Part 2
• 1.10 Tasks

Outlook Intermediate

• 1.1 Folder Structure Part 1
• 1.2 Folder Structure Part 2
• 1.3 Multiple Email Accounts Part 1
• 1.4 Multiple Email Accounts Part 2
• 1.5 Create A New Email Part 1
• 1.6 Create A New Email Part 2
• 1.7 Signatures
• 1.8 Calendars Part 1
• 1.9 Calendars Part 2
• 1.10 Contacts
• 1.11 Outlook Settings Part 1
• 1.12 Outlook Settings Part 2

Outlook Advanced

• 1.1 One Note Introduction Part 1
• 1.2 One Note Introduction Part 2
• 1.3 One Note And PowerPoint
• 1.4 One Note And Word
• 1.5 One Note And Outlook
• 1.6 Sharing Information
• 1.7 One Note And Mobile Devices
• 1.8 Additional Elements Part 1
• 1.9 Additional Elements Part 2

Microsoft Office PowerPoint 2016 Curriculum:

PowerPoint Beginner

• 1.1 What Is PowerPoint Part 1
• 1.2 What Is PowerPoint Part 2
• 1.3 New Presentation
• 1.4 Viewing Presentation
• 1.5 Inserting Transitions
• 1.6 More Visual Designs Part 1
• 1.7 More Visual Designs Part 2
• 1.8 More Visual Designs Part 3
• 1.9 More Visual Designs Part 4
• 1.10 Notes

PowerPoint Intermediate

• 1.1 Visual Designs With Logos And Animation Part 1
• 1.2 Visual Designs With Logos And Animation Part 2
• 1.3 Visual Designs With Logos And Animation Part 3
• 1.4 Visual Designs With Logos And Animation Part 4
• 1.5 Visual Designs With Logos And Animation Part 5
• 1.6 Exit Animation Part 1
• 1.7 Exit Animation Part 2
• 1.8 Exit Animation Part 3
• 1.9 Navigation Buttons
• 1.10 Layout Options Part 1
• 1.11 Layout Options Part 2

PowerPoint Advanced

• 1.1 Master Pages Part 1
• 1.2 Master Pages Part 2
• 1.3 Software Simulation Part 1
• 1.4 Software Simulation Part 2
• 1.5 Setting Pictures To Music
• 1.6 Advanced Animation Techniques
• 1.7 Triggers
• 1.8 Motion Path Animation
• 1.9 Video In Powerpoint
• 1.10 PowerPoint Review Part 1
• 1.11 PowerPoint Review Part 2
• 1.12 Additional Options

Microsoft Office Word 2016 Curriculum:

Word Beginner

• 1.1 Course Introduction
• 1.2 Introduction To Word Interface Part 1
• 1.3 Introduction To Word Interface Part 2
• 1.4 Introduction To Word Interface Part 3
• 1.5 View
• 1.6 Typing Part 1
• 1.7 Typing Part 2
• 1.8 Typing Part 3
• 1.9 Typing Part 4
• 1.10 Resume Part 1
• 1.11 Resume Part 2
• 1.12 Bullet List

Word Intermediate

• 1.1 Menus And Keyboard Shortcuts Part 1
• 1.2 Menus And Keyboard Shortcuts Part 2
• 1.3 Tabs Part 1
• 1.4 Tables Part 1
• 1.5 Tables Part 2
• 1.6 Tables Part 3
• 1.7 Styles Part 1
• 1.8 Styles Part 2
• 1.9 Styles Part 3
• 1.10 Page Formatting Part 1
• 1.11 Page Formatting Part 2
• 1.12 Page Formatting Part 3

Word Advanced

• 1.1 Creating An Outline
• 1.2 Inserting Images Part 1
• 1.3 Inserting Images Part 2
• 1.4 Tracking Changes
• 1.5 Mail Merge Part 1
• 1.6 Mail Merge Part 2
• 1.7 Large Documents Part 1
• 1.8 Large Documents Part 2
• 1.9 Other Word Functions Part 1
• 1.10 Other Word Functions Part 2
• 1.11 Document Comparison

All necessary materials are included.

Certification(s):

This course can help you prepare to take the Intuit QuickBooks Certified User Online and Microsoft Office Suite (MOS) Specialist certification exams.

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• 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.

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

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