Administrative Professional

Hours: 310 / Access Length: 12 Months / Delivery: Open, Mentor Supported
Retail Price: $1,875.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

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 Professional program includes 2 courses:

• Administrative Assistant
• 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

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