Administrative Assistant & Bookkeeping Specialist

Hours: 590 / Access Length: 12 Months / Delivery: Open, Mentor Supported
Retail Price: $0.00

Course Overview:

As an office professional, you only have to do one thing: everything! And there never seems to be enough time to do it all, much less learn how. But if you really want to ramp up your job performance – and add value to your employer – you need to take this Administrative Assistant course. This course offers an almost endless supply of savvy advice, great tips, proven tools, and powerful strategies for dealing with both everyday job responsibilities and requirements.

So whether you’re brushing up your skills, keeping up with new developments in business, increasing your own marketability, or just starting a challenging and rewarding career, this comprehensive course is just the right thing to move your career forward!

After completing this course, you should be able to:

• Type quickly and effectively
• Identify the steps to complete general office procedures
• Comprehend the basics of working within Microsoft® Office
• Identify the steps for creating business documents using professional language
• Identify the basic requirements for bookkeeping and accounting in the office

This Professional Bookkeeping course will show you the essentials of record keeping for a small business and will show why it's necessary to track information. The course will give you a greater understanding of the purpose and process of record keeping. Professional Bookkeeping teaches you how to sort through the masses of information and paperwork, how to record what is important for a business, and how to use that information to grow a business for success. This course helps prepare you to take the NACPB Bookkeeping Certification exam. Professional Bookkeeping also assists you in setting up and running a thriving home-based bookkeeping business. This course includes 50 lessons on DVD.

After completing this course, you should be able to:

• Define the basics of beginning, intermediate, and advanced bookkeeping
• Identify the steps involved in starting a bookkeeping business
• Define methods for recruiting and maintaining clients
• Distinguish between bookkeeping and accounting
• Identify methods for tax planning and minimizing taxes

To succeed in small business, you need great ideas, an entrepreneurial spirit, and competitive products or services. And one other thing: a good accounting system like QuickBooks. This QuickBooks course shows you how to use this popular business finance program to gain a clear view of your finances and keep your business in the black. Students will learn how to use QuickBooks 2013’s simpler interface to help manage a business, track company finances, and generate required reports.

After completing this course, you should be able to:

• Identify the basics for getting started with QuickBooks
• Define the steps for completing daily entry tasks
• Identify the steps to print checks, process taxes, and process payroll
• Identify the steps for creating and printing reports, file management, and backing up information
• Comprehend the role of the business owner related to QuickBooks

NOTE: This course does NOT include the QuickBooks program itself. Students will need to have QuickBooks 2013 already installed on their computers.

If you're looking for a way to get up to speed quickly on the newest version of Microsoft® Office, this course offers step-by-step instructions to make it easy. Office has new features and tools to master, and whether you're upgrading from an earlier version or encountering the Office applications for the first time, you'll appreciate this simplified approach.

This course covers:

• MS Word
• MS Excel
• MS PowerPoint
• MS Outlook
• MS Access
• MS Publisher

Microsoft® Office holds more than 90 percent of the market for Windows-based productivity suites. Our MS Office course makes this technology easy to understand, even for those who are new to computers.

After completing this course, you should be able to:

• Identify the steps to complete common Office tasks such as opening and saving a file
• Identify the steps to complete various tasks in Word
• Identify the steps to complete various tasks in Excel
• Identify the steps to complete various tasks in PowerPoint
• Identify the steps to complete various tasks in Access
• Identify the steps to complete various tasks in Outlook
• Identify the steps to complete various tasks in Publisher

This course prepares you for the following MOS exams:

• Exam 77-881: MOS: Microsoft Office Word 2010
• Exam 77-882: MOS: Microsoft Office Excel 2010
• Exam 77-883: MOS: Microsoft Office PowerPoint 2010
• Exam 77-884: MOS: Microsoft Office Outlook 2010
• Exam 77-885: MOS: Microsoft Office Access 2010

NOTE: This course does NOT include the MS Office programs themselves. Students will need to have Office 2010 &/or 2007 already installed on their computers.

The Administrative Assistant & Bookkeeping Specialist program includes 4 courses:

• Administrative Assistant
• Professional Bookkeeping
• QuickBooks Pro
• Microsoft Office (MOS)

Course Outline:

Administrative Assistant Module 1
Typing Practice & Improvement

• Pre-Test Your Typing Ability
• Finger Positioning Exercises
• Typing Practice Games
• Typing Progress Tracking
• Improve Your Typing Skills
• Increase Your Typing Speed

Administrative Assistant Module 2
General Office Procedures

• The New Administrative Assistant
• The Daily Routine
• Telephone Usage & Etiquette Tips
• Mail Services and Shipping
• Travel Arrangements
• Transportation Reservations
• Dealing with Meetings
• Meeting Agendas and Minutes
• Time Management
• Creating Action Plans
• Keeping Accurate Records
• Filing Systems and File Cabinets

Administrative Assistant Module 3
Office Equipment and Computers

• Understanding Office Equipment
• Using Microsoft Windows
• Using Apple Macintosh
• Navigating with Mac OS X
• Email Accounts & Programs
• Organizing Your Email
• Using the Internet
• Computer Networking
• Web Conferencing
• Data Security
• Troubleshooting Computer Problems
• Office Ergonomics

Administrative Assistant Module 4
Using Microsoft Office

• Common Microsoft Office  Features
• Using Microsoft Word
• Using Microsoft PowerPoint
• Using Microsoft Excel
• Using Microsoft Publisher
• Using Microsoft One Note
• Using Microsoft Outlook
• Using Microsoft Web Applications

Administrative Assistant Module 5
Business Documents

• Creating a Great Business Letter
• Appearance and Paragraphing
• Interoffice Memorandums and E-Mails
• Reports and Report Templates
• Press Releases
• Editing and Proofreading
• Forms of Address
• Legal Documents and Terms
• Grammalogues
• Notary Public Forms
• Agreements and Contracts
• Legal and Real Estate Terms

Administrative Assistant Module 6
Language Usage

• Grammar
• Using Adjectives and Adverbs
• Language Usage and Style
• Subject-Verb Agreement
• Avoiding Redundancies
• Phrases and Words to Omit
• Common English Usage Problems
• Spelling and Spell Check
• American English vs. British English
• Punctuation: Using a Period or Comma
• Writing Numerals
• Roman Numerals

Administrative Assistant Module 7
Financial Activities

• Bookkeeping and Accounting
• Business Taxes
• The Company’s Bank
• Business and Financial Information for Small Businesses
• U.S. Weights and Measures
• International Weights and Measures (Metric)
• Business Math
• Career Advancement
• Growing as the Company Grows
• Presentation Skills
• Communication Skills
• Office Management and Supervision

Professional Bookkeeping Module 1
Bookkeeping Basics

• Getting Started
• The Origins of Bookkeeping
• Generally Accepted Accounting Principles (GAAP)
• Accrual Accounting
• Debits and Credits
• Accountants versus Bookkeepers
• Accounting Jargon
• Setting Up the Record Keeping System
• The Balance Sheet
• Assets and Liabilities
• The Income Statement
• The Cash Flow Statement

Professional Bookkeeping Module 2
Intermediate Bookkeeping

• Recording the Sales Cycle
• Recording the Purchases Cycle
• Inventory Tracking Systems
• Capital Assets
• Understanding Depreciation
• Leases and Loans
• Transactions between the Company & Its Owners
• Remittances to the Government
• Maintaining a Petty Cash System
• Reconciling the Bank
• Backward Posting
• Organizing Messy Books

Professional Bookkeeping Module 3
Advanced Bookkeeping

• The Role of the External Accountant
• Creating Financial Statements
• Corporate Income Tax Returns
• Budgeting for a Business
• Setting up a 12-Month Budget
• Monitoring Cash Flow
• Understanding Bartering
• Foreign Currency Transactions
• Reconciling the Foreign Currency Bank Account
• Tax Planning
• Minimizing Taxes versus Avoiding Taxes
• Owner / Manager Remuneration

Professional Bookkeeping Module 4
Starting a Bookkeeping Business

• Starting a Bookkeeping Business
• Being Self-Employed
• Balancing Work and Family
• Financial Considerations
• Start Up Considerations
• Writing a Business Plan
• Management and Organization
• Doing your Accounting
• Establish a Business Identity
• Business Checking Account
• Business Credit Cards
• Setting Up Your Home Office

Professional Bookkeeping Module 5
Marketing & Clients

• Bookkeeping or Accounting
• Bookkeeping Certification
• Getting Experience
• Marketing Your Business
• Your Ideal Client
• Targeting a Niche
• Cultivating Referrals
• Online Marketing and Social Media
• Understanding Websites
• Writing Blogs or Articles
• Financial Considerations
• Client Management, Legal, and Ethical Issues

QuickBooks Pro Module 1   
Getting Started

• Opening QuickBooks
• Creating a Company File
• Modifying Company Info
• Opening an Existing Company File
• Converting from Another Program to QuickBooks
• Getting Around in QuickBooks
• Company Snapshot
• Financial Calendar
• Menus and Icon Bars
• Setting Up a Chart of Accounts
• Creating Accounts and Subaccounts
• Modifying Accounts

QuickBooks Pro Module 2       
Items, Lists, and Files

• Setting Up Items
• Tracking Inventory with Items
• Planning Items
• Creating Items
• Setting Up Lists
• Categorizing with Classes
• Fixed Asset Items
• Creating and Editing List Entries
• Sorting Lists
• Managing Files
• Backing Up Files
• Condensing Data

QuickBooks Pro Module 3    
Bookkeeping

• Tracking Time and Mileage
• Running Time Reports
• Paying for Expenses
• Entering Bills
• Purchasing Inventory
• Paying Your Bills
• Producing Checks
• Paying with Cash
• Invoicing
• Choosing the Right Form
• Creating Batch Invoices
• Estimating Jobs

QuickBooks Pro Module 4    
Accounts Receivable and Payroll

• Producing Statements
• Transaction Timesavers
• Printing Sales Forms
• Finding Transactions
• Receivables Aging
• Receiving Payments for Invoiced Income
• Applying Credits to Invoices
• Deposits, Down Payments, Retainers
• Applying Finance Charges
• Cash Sales
• Doing Payroll
• Paying Yourself

QuickBooks Pro Module 5  
Journal Entries and Financial Statements

• Bank Accounts and Petty Cash
• Handling Bounced Checks
• Transferring Funds
• Managing Loans
• Making Journal Entries
• Generating Financial Statements
• Profit and Loss Report
• Balance Sheet
• Statement of Cash Flows
• Performing End-of-Year Tasks
• Generating Tax Reports
• Managing Inventory

QuickBooks Pro Module 6   
Managing Your Business

• Budgeting and Planning
• Types of Budgets
• Creating Budgets in QuickBooks
• Working with Reports
• Running Reports
• Customizing Reports
• Online Banking Services
• Setting Up Accounts for Online Services
• Configuring Preferences to Fit Your Company
• Preferences: The Basics
• Integrated Applications
• Time and Expenses

QuickBooks Pro Module 7   
More QuickBooks Features

• Integrating QuickBooks with Other Programs
• Mail Merge to Word
• Synchronizing Contacts
• Exporting QuickBooks Data
• Importing Data
• Customizing QuickBooks
• Customizing the Desktop
• Fast Access to Favorite Features
• Customizing Forms
• Keeping QuickBooks Data Secure
• Setting Up the Administrator
• Creating QuickBooks Users

MOS Office  Module 1
Common Office Features

• Office Basics
• Work with the Ribbon
• Customize the Quick Access Toolbar
• Working with Files
• Create & Save a File
• Open & Print a File
• Cut, Copy, & Paste Data
• Office Graphics Tools
• Insert & Format Graphics
• Resize & Move Objects
• Crop & Add Effects to a Picture
• Create a WordArt Object
• Working with Office Files Online
• Create a New Workspace
• Share a Workspace Online
• Sharing Files
• Navigate the Workspace
• Adjust Default Settings
• Adjust File Properties
• Enter & Format data
• Run Spelling and Grammar Checker
• Manage Comments

MOS Office Module 2
MS Word

• Change Word's Views
• Type & Edit Text
• Insert Quick Parts
• Insert Symbols
• Apply Font and Paragraph Formatting
• Apply and Manipulate Page Setup
• Create Lists
• Copy & Clear Formatting
• Apply a Template
• Assign a Theme
• Add Borders
• Insert and Format a Table
• Insert an Excel Spreadsheet
• Add Headers & Footers
• Generate an Index
• Create a Bibliography and Table of Contents
• Find & Replace Text
• Work with AutoCorrect
• Track & Review Document Changes
• Protect a Document
• Manage Draft Versions
• Format Page Backgrounds
• Create and Format Text Boxes
• Create Endnotes and Footnotes
• Work with Comments
• Setup and Run Mail Merge

MOS Office Module 3
MS Excel

• Building Spreadsheets
• Enter & Select Cell Data
• Use the AutoFill Feature
• Turn on Text Wrapping
• Format Data
• Apply Conditional Formatting
• Resize Columns & Rows
• Worksheet Basics
• Move & Copy Worksheets
• Sort and Filter Data
• Track & Review Worksheet Changes
• Understanding Formulas
• Apply Absolute & Relative Cell References
• Audit a Worksheet for Errors
• Working with Charts
• Create, Move, or Change a Chart
• Add Gridlines
• Apply Sparklines
• Work with Hyperlinks
• Merge or Split Cells
• Create Row & Column Titles
• Hide & Unhide Rows and Columns
• Manipulate Page Setup
• Work with Cell Ranges

MOS Office Module 4
MS PowerPoint

• Creating a Presentation
• Create a Photo Album Presentation
• Change PowerPoint Views
• Change the Slide Layout
• Create a Custom Layout
• Populating Presentation Slides
• Apply a Theme
• Add a Text Box, Table or Chart
• Add a Picture or Video Clip
• Move or Resize a Slide Object
• Add, Delete, and Rearrange Slides
• Format Slides
• Define Slide Transitions
• Add Animation Effects
• Apply Effect & Path Options
• Create Custom Animation
• Record Narration
• Rehearse & Run a Slide Show
• Set Presentation Timing
• Modify WordArt and Shapes
• Add and Format SmartArt Graphics
• Edit Video and Audio
• Use Presentation Tools
• Record Presentations

MOS Office Module 5
MS Access

• Database Basics
• Create a Database Based on a Template
• Create a New Table
• Change Table Views
• Add or Delete a Field
• Hide or Move a Field
• Create and Format Forms
• Apply a Database Theme
• Add a Record to a Table or Form
• Navigate Records in a Form
• Search & Delete a Record
• Sort Records
• Filter Records
• Apply Conditional Formatting
• Design Reports
• Apply Application Parts
• Set Relationships
• Create and Manage Queries

MOS Office Module 6
MS Outlook

• Organizing with Outlook
• View Outlook Components
• Schedule an Appointment
• Schedule an Event
• Create a New Contact
• Create a New Task
• Organize Outlook Items
• Perform an Instant Search
• Compose & Send a Message
• Send a File Attachment
• Read an Incoming Message
• Reply To or Forward a Message
• Add a Sender to Your Outlook Contacts
• View, Clean Up or Ignore a Conversation
• Screen Junk E-mail
• Create a Message Rule
• Manipulate Item Tags
• Create and Manage Quick Steps
• Manage Automatic Message Content
• Create and Manipulate Meeting Requests
• Work with Notes and Journal Entries

MOS Office Module 7
MS Publisher

• Publisher Basics
• Create a Publication
• Zoom In & Out
• Add Text
• Add a New Text Box
• Add a Picture to a Publication
• Fine-Tuning a Publication
• Apply a Text Effect
• Change Text Alignment
• Add a Border
• Control Text Wrap
• Link Text Boxes
• Move & Resize Publication Objects
• Edit the Background
• Add & Create a Building Block Object

All necessary materials are included.

Certifications:

Upon successful completion of our Professional Bookkeeping course, students will be prepared for an entry-level position as a bookkeeper in an office setting and will be prepared to sit for the NACPB national certification exam. NACPB's Bookkeeper Certification assures employers you have bookkeeping knowledge and skill. You obtain the Certification by passing the Uniform Bookkeeper Certification Examination.

Upon successful completion of our Microsoft® Office course, students will be prepared to sit for Microsoft® Office certification exams to become a Microsoft® Office Specialist (MOS).

To assist in preparing for these Microsoft® Office certification exams, checklists are provided which outline all tasks that may be covered in that exam. To prepare for an exam, it is recommended that each task on the checklist be fully explored and practiced using the textbook and/or software. Links to practice tests are also provided to help prepare for these exams.

System Requirements:

• 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.