Call Us Today! 1-888-514-8944

Let us help you find the funding
that’s right for you today.
Call 1-888-514-8944

or For more information click here.

Administrative Assistant with MS Office


Microsoft Office Training Program Duration: 4 Months
Course Contact Hours: 310
Student Tuition: $3,500.00

This training program combines a two course training track:

  • Administrative Assistant
  • Microsoft Office (MOS) 2013

Our online training course in Administrative Assistant with Microsoft 2013 focuses on training folks in the office assistance skills needed to master a corporate office atmosphere. With a focus on computer software applications, our Administrative Assistant classes can offer you the hands-on education that will prepare you for a career in this challenging job market.

Administrative Assistant

Overview

As an office professional, you only need to do one thing: everything! There doesn’t seem to be suitable time in order to finish everything, much less find out how. Although if you truly like to increase your job performance– as well as bring value to your workplace– you need to take our Administrative Assistant classes. This course grants a nearly infinite supply of wise help, terrific ideas, proven solutions, as well as highly effective approaches when it comes to facing both everyday job responsibilities and requirements.

Therefore whether you’re looking over your skills, staying up to date with new innovations in business, boosting your own marketability, or merely beginning a demanding as well as rewarding career, this in depth program is the right thing to move your career forward!

After completing this course, you should have the ability to:

  •  Type quickly and proficiently.
  • Identify the steps to perform regular office procedures.
  • Cover the fundamentals of working within Microsoft ® Office.
  • Determine the steps for creating business documents using professional language.
  • Define the primary requirements for bookkeeping and accounting in the office.

Microsoft Office Training (MOS) 2013

Overview

If you’re trying to find a way to get up to speed swiftly on the latest version of Microsoft Office, this program offers detailed guidelines to make things easy. Office 2013 has brand new features and tools to master, and whether you’re updating from an earlier model or experiencing the Office applications for the very first time, you’ll welcome this simplified method.

This Microsoft Office online training covers:

  • Microsoft Word 2013.
  • Microsoft Excel 2013.
  • Microsoft PowerPoint 2013.
  • Microsoft Outlook 2013.
  • Microsoft Access 2013.

Microsoft Office has over 90 percent of the market for Windows-based productivity suites. Our MS Office 2013 program makes this technology understandable, even for those who are new to computers. As an added bonus, the training software that you will receive covers both MS Office
2013 and 2010.

This Microsoft Office training  prepares you for the following Microsoft Office Specialist (MOS) exams:

  • Exam 77-418: MOS: Microsoft Office Word 2013.
  • Exam 77-420: MOS: Microsoft Office Excel 2013.
  • Exam 77-422: MOS: Microsoft Office PowerPoint 2013.
  • Exam 77-423: MOS: Microsoft Office Outlook 2013.
  • Exam 77-424: MOS: Microsoft Office Access 2013.

NOTE: This training course does NOT include the MS Office programs themselves. Students will need to have Office 2013 currently installed on their computers.

After finishing this program, you will be able to:

  •  Recognize the steps to create, edit, and print documents in Word.
  • Recognize the steps to create and handle worksheets in Excel.
  • Identify the steps to build presentations in PowerPoint.
  • Recognize the steps to produce and handle databases in Access.
  • Identify the steps to take care of email and calendars in Outlook.

Certification

Administrative Assistant

Upon successful completion of our Administrative Assistant course, students will be prepared for an entry-level job as an Administrative Assistant in an office setting and to sit for the NCCB national certification exam to become a Certified Administrative Assistant (CAA).

Microsoft® Office (MOS) 2013

Upon successful completion of our Microsoft Office 2013 course, students will be prepared to sit for Microsoft Office certification exams to become a Microsoft® Office Specialist (MOS). Only one exam is required for the MOS certification. 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.

** Certification exams are not included in the cost of the course.**

Administrative Assistant

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
Read Full Outline Below
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 2010 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

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

Microsoft Office (MOS) 2013

Outline

Microsoft Office 2013 Module 1
Office Basics

  • Starting Programs
  • The Ribbon and File Tab
  • Ribbon Icons
  • Quick Access Toolbar
  • Customizing Office Programs
  • Selecting and Editing Data
  • Paste Options
  • Undo and Redo
  • Sharing Data Between Programs
  • Modifying Pictures
  • Enhancing Pictures
  • Using Help

Microsoft Office 2013 Module 2
Working With Word

  • Typing Text
  • Navigating a Document
  • Finding and Replacing Text
  • Checking Spelling and Grammar
  • Formatting Text
  • Text Alignment
  • Making Lists
  • Using Styles and Templates
  • Cover Pages
  • Text in Tables
  • Headers and Footers
  • Dividing Text into Columns

Microsoft Office 2013 Module 3
Working With Excel

  • Spreadsheet Basics
  • Formatting Numbers and Labels
  • Navigating Spreadsheets
  • Clearing Data
  • Creating a Formula
  • Conditional Formatting
  • Data Validation
  • Using Functions
  • Charting and Analyzing Data
  • Creating and Editing Charts
  • Sparklines
  • Pivot Tables

Microsoft Office 2013 Module 4
Working With PowerPoint

  •  Creating a Presentation
  •  Working with Text
  •  Adding Color and Pictures
  • Applying a Theme
  • Changing the Background
  • Adding Videos
  • Adding Sound
  • Spell-Checking Your Presentation
  • Creating Slide Sections
  • Using Transitions
  • Adding Hyperlinks
  • Creating Handouts

Microsoft Office 2013 Module 5
Working With Outlook

  •  Configuring Email Settings
  • Creating Email
  • Attaching Files
  • Reading and Organizing Email
  • Grouping Messages
  • Deleting Email Messages
  • Setting Appointments
  • Viewing Appointments
  • Storing Names and Addresses
  • Searching Names
  • Managing Tasks
  •  Storing a Task

Microsoft Office 2013 Module 6
Working With Access

  • Understanding Databases
  • Designing a Database
  •  Typing Data into Databases
  • Closing and Saving a Database
  • Searching a Database
  • Sorting a Database
  • Querying a Database
  • Creating a Simple Query
  • Report Wizard
  • Manipulating Report Data
  • Editing a Report
  • Designing Reports

Microsoft Office 2013 Module 7
Tips and Tricks

  • Saving Office 2013 Files
  • Password-Protection
  • Customize the Ribbon
  • Reduce Spam in Outlook
  • Using Office Web and Windows RT
  • Guarding Against Macro Viruses
  • Build Your Own Office Apps
  • Collaborate with the Review Tab
  • References Tab
  •  Using Excel’s Data Tab
  • Saving and Sending Files
  • Checking File Compatibility

Required Materials:

Administrative Assistant
Materials Included:

  • Mavis Beacon Teaches Typing 18 Software
  •  Administrative Assistant’s and Secretary’s Handbook by James Stroman, Kevin Wilson, Jenniver Wauson

Microsoft® Office (MOS) 2013
Materials Included:

  • Office 2013 for Dummies by Wallace Wang
  • Mastering Microsoft Office 2013 Made Easy by TeachUComp, Inc.

System Requirements:

Internet Access

  •  Broadband or high-speed internet access is required. Broadband includes DSL, cable, and wireless connections.
  • Dial-Up internet connections will result in a diminished online experience.
  • Moodle pages may load slowly and viewing large audio and video files may not be possible.

Hardware

  • Windows hardware configurations and processors are acceptable
  • Mac computers MUST have Microsoft Window Operating Systems over Bootcamp (downloadble from Apple).
  • 1 GB RAM minimum recommended
  • Operating Systems
  • Windows XP, Vista or 7 and Mac OS X 10 or higher with Windows
  • Web Browsers
  • Google Chrome is highly recommended
  • Internet Explorer is not recommended as it may not display certain menus and links
  • Cookies MUST be enabled
  • Pop-ups MUST be allowed (Pop-up Blocker disabled)
  • Kindle Reader App is needed for many of our courses.
  • Adobe PDF Reader
  • Media Plug-ins (These may be required depending on your course media.)
  • Adobe Flash Player (Required for many of our career courses and ALL of our IT courses.)
  • Adobe Acrobat Reader, Apple Quicktime, Windows Media Player, &/or Real Player
  • PowerPoint Viewer (Use this if you don’t have PowerPoint)