Administrative Professional

290 Hours/12 Months/Instructor Supported

Course Overview:

Many types of offices require the skilled work of a trained office administrative assistant. Administrative assistant duties can vary by office, but most often, an administrative assistant, is someone who helps to keep an office well organized and managed.

Whether you want to organize your home office, enhance your current skills, or start toward an exciting new career, this administrative assistant course is for you! An administrative assistant job description can vary, but overall, our course can help you better understand the skills needed to become a qualified administrative assistant.

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 2010 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 program covers:

MS Word 2010
MS Excel 2010
MS PowerPoint 2010
MS Outlook 2010
MS Access 2010
MS Publisher 2010

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

BONUS: As an added bonus the training software that you will receive covers both MS Office 2010 & 2007.

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 2010

Course Outline:

Administrative Assistant

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
Daily Routine
Your Office
Work Planning
Telephone Usage
Screening Calls
Telephone Etiquette Tips
Mail Services and Shipping
Petering & Packaging
Travel Arrangements
Transportation Reservations
Before the Trip Checklist
Dealing with Meetings
Anatomy of a Meeting
Meeting Agendas and Minutes
Time Management
Maintaining an Activity List
Creating Action Plans
Keeping Accurate Records
Filing Systems and File Cabinets

Administrative Assistant Module 3
Office Equipment and Computers, Part 1

Understanding Office machines
Copy Machines
Telecommunications Equipment
Personal Data assistants
Computer Hardware
Input and Output Devices
Hand-Held Computers
Computer Software
Operating Systems
Starting a Computer Program
Using Explorer to View Files and Folders
Windows Help
Saving and Printing Files
Computer Shortcuts
Database Management
Creating and Using a Database
Computer Networking
Wireless Connections
Understanding E-Mail
E-Mail Accounts, Passwords and Programs
Organizing Your E-Mail
Using the Internet
Printing and Saving a Web Page
Downloading and Uploading Files
Error Messages
Web Conferencing

Administrative Assistant Module 4
Office Equipment and Computers, Part 2

Spreadsheet Software
Navigating Around a Spreadsheet
Spreadsheet Functions
Data Security
Security Threats from Outside and Inside
Computer Viruses
Keyboarding Skills
Word Processing
Creating, Editing and Formatting Documents
Desktop Publishing Issues Desktop Publishing Software Tools
Graphics Formats
Scanners
Digital Photography
Using PowerPoint
Planning a PowerPoint Presentation
Troubleshooting Computer Problems
Office Ergonomics
Positioning Your Computer Keyboard & Mouse
Arranging Your Workstation
Glossary of Computer Terms

Administrative Assistant Module 5
Business Documents

Creating a Great Business Letter
Parts of a Business Letter
Appearance and Paragraphing
Contents of the Letter
Routine Letters
Interoffice Memorandums and E-Mails
Paper Selection
Envelopes and Labels
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
The Parts of Speech
Nouns and Verbs
Using Adjectives and Adverbs
Pronouns and Prepositions
Language Usage and Style
Subject-Verb Agreement
Modifier Placement
Modifier Placement
Sentence Types
Compound Sentences
Avoiding Redundancies
Phrases and Words to Omit
Common English Usage Problems
Language: Key to Your Success
Spelling and Spell Check
Irregular Spelling
Capitalization
American English vs. British English
Pronunciation: Perfecting Your Speech
Punctuation
Using a Period or Comma
Writing Numerals
The Abbreviation for Numbers
Roman Numerals

Administrative Assistant Module 7
Financial Activities

Bookkeeping and Accounting
Financial Record Keeping
Assets and Liabilities
Effect of Business Transactions
Accounting Statements
Payroll
Travel and Entertainment Expenses
Records for Lenders
Business Taxes
State Taxes
Franchise Tax
Sales Tax
Employment Taxes
Self-Employment Tax
Employee or Independent Contractor?
The Company's Bank
Checking and Savings Accounts
Making Deposits
Trust Services
Reconciling Bank Statements
Trading with Other Countries
Sources of financing
U.S. Weights and Measures
International Weights and Measures (Metric)

Administrative Assistant Module 8
Career Advancement

Growing as the Company Grows
Upgrade Your Skills
Recognizing a Time for change
Your Resume'
The Interview
Presentation Kills
Preparing Your Presentation
Group Presentations
Communications Skills
Giving Feedback
Listening and Nonverbal Communication
Office Management and Supervision
The Role of the Office Manager
Building Trust with Your Team
Conflict Management

MS Office 2010

MS Office 2010 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 Clip Art or a Picture
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

MS Office 2010 Module 2
MS Word

Change Word's Views
Type & Edit Text
Insert Quick Parts
Insert Symbols
Change the Font, Size, & Color
Set Tabs & Margins
Create Lists Copy & Clear Formatting
Apply a Template
Assign a Theme
Add Borders
Insert a Table
Insert an Excel Spreadsheet
Add Headers & Footers
Generate an Index
Create a Bibliography
Find & Replace Text
Work with AutoCorrect
Track & Review Document Changes

MS Office 2010 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 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

MS Office 2010 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
Reorganize Slides
Define Slide Transitions
Add Animation Effects
Create Custom Animation
Record Narration
Rehearse & Run a Slide Show

MS Office 2010 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 a Form
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
Create a Report

MS Office 2010 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

MS Office 2010 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 TextBoxes
Move & Resize Publication Objects
Edit the Background
Add & Create a Building Block Object

All necessary materials included.

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 (Bootcamp is a free download from Apple's website).
1 GB RAM recommended
Software
Operating Systems
Windows XP or Vista and Mac OS X 10 and higher with Windows
Web Browsers
Google Chrome
Safari, Internet Explorer & FireFox are not currently recommended as they cannot display certain Moodle editing menus for both students and instructors
Adobe PDF Reader
Media Plug-ins (These may be required depending on your course media-click on the links below to download the latest versions)
Adobe Flash Player
Adobe Acrobat Reader
Apple Quicktime
Windows Media Player
Real Player
PowerPoint Viewer (use this if you don't have PowerPoint)

Administrative Professional