Administrative Professional with Microsoft Office Specialist 2013

The Administrative Professional with Microsoft Office Specialist 2013 training program teaches the key skills you need to become an Administrative Professional and prepare you for the Microsoft Office Specialist Certification Exams: Word, Excel, PowerPoint, Outlook, Access.

You will learn essential skills including how to work in a modern professional office, how to maintain a professional image, personal and professional ethics, communication essentials, technology basics, record keeping and financial management, event planning and travel, and how to advance in an administrate career.

You will then learn essential skills of working at advanced level in Microsoft Word, Excel, PowerPoint, Outlook, and Access 2013.

Who Should Attend

Individuals interested in advancing in an administrative career.

Certificate Completion

Upon successful completion of the Administrative Professional with Microsoft Office Specialist 2013, you should be able to use the Microsoft Office suite of software effectively and knowledgeably.

Delivery Format

  • The entire program is offered online
  • Start anytime during the quarter
  • Learn from the convenience of your home and on your schedule
  • Instructor facilitated online course


Course Information
Course No. GES844
Units NC
Fee $2,395

Outline

Training Time

455 hours; 6 months

 - expand Administrative Professional
  1. The Dynamic Workplace
  2. Workplace Behaviors
  3. Communication Essentials
  4. Technology Basics
  5. Records and Financial Management
  6. Meetings and Travel
  7. Career Advancement
  8. Administrative Professional Exam
  9. Customer Service
  10. Goal Setting and Time Management
  11. Working with Difficult People
  12. Business Writing
  13. Administrative Professional Final Exam
 - expand Introduction to Microsoft Excel 2013
  1. Creating a Microsoft Excel Workbook
  2. The Ribbon
  3. The Backstage View (The File Menu)
  4. The Quick Access Toolbar
  5. Entering Data in Microsoft Excel Worksheets
  6. Formatting Microsoft Excel Worksheets
  7. Using Formulas in Microsoft Excel
  8. Working with Rows and Columns
  9. Editing Worksheets
  10. Finalizing Microsoft Excel Worksheets
  11. Microsoft Excel (2013) New Features
  12. Introduction to Microsoft Excel 2013 Exam
 - expand Intermediate Microsoft Excel 2013
  1. Advanced Formulas
  2. Working with Lists
  3. Working with Illustrations
  4. Visualizing Your Data
  5. Working with Tables
  6. Advanced Formatting
  7. Excel (2013) New Features
  8. Intermediate Microsoft Excel 2013 Exam
 - expand Advanced Microsoft Excel 2013
  1. Using Pivot Tables
  2. Auditing Worksheets
  3. Data Tools
  4. Working with Others
  5. Recording and Using Macros
  6. Random Useful Items
  7. Microsoft Excel (2013) New Features
  8. Advanced Microsoft Excel 2013 Exam
  9. Microsoft Excel 2013 Final Exam
 - expand Introduction to Microsoft Word 2013
  1. Creating a Microsoft Word Document
  2. The Ribbon
  3. File Tab
  4. The Quick Access Toolbar
  5. Formatting Microsoft Word Documents
  6. Editing Documents
  7. Finalizing Microsoft Word Documents
  8. Introduction to Microsoft Word 2013 Exam
 - expand Intermediate Microsoft Word 2013
  1. Advanced Formatting
  2. Working with Tables
  3. Working with Images
  4. Page Layout
  5. Working with Illustrations
  6. Viewing Your Document(s)
  7. Intermediate Microsoft Word 2013 Exam
 - expand Advanced Microsoft Word 2013
  1. Working with Long Documents
  2. Reviewing and Collaborating on Documents
  3. Comparing and Combining Documents
  4. Mailings
  5. Documents
  6. Useful Items
  7. Advanced Microsoft Word 2013 Exam
  8. Microsoft Word 2013 Final Exam
 - expand Introduction to Microsoft PowerPoint 2013
  1. Creating a PowerPoint Presentation
  2. The Ribbon
  3. The Quick Access Toolbar
  4. The File Tab
  5. Microsoft PowerPoint Presentations
  6. Working with Images
  7. Working with Tables and Charts
  8. Finalizing Microsoft PowerPoint Presentations
  9. Introduction to PowerPoint 2013 Exam
 - expand Advanced Microsoft PowerPoint 2013
  1. Customizing Presentations
  2. Masters
  3. Working with Special Effects
  4. Using SmartArt
  5. Setting up the Slide Show
  6. Outlines and Slides
  7. Sharing and Securing a Presentation
  8. Advanced PowerPoint 2013 Exam
  9. PowerPoint 2013 (MOS) Final Exam
 - expand Introduction to Microsoft Outlook 2013
  1. The Outlook Interface
  2. Performing Popular Tasks in Outlook
  3. Working with Messages
  4. Working with the Calendar
  5. Organizing Contacts
  6. Introduction to Microsoft Outlook 2013 Exam
 - expand Advanced Microsoft Outlook 2013
  1. Working with Tasks and Notes
  2. Using Signature and Themes
  3. Managing Your Inbox
  4. Working with Multiple Email Accounts
  5. Advanced Microsoft Outlook 2013 Exam
  6. Microsoft Outlook 2013 Final Exam
 - expand Introduction to Microsoft Access 2013
  1. Quick Overview of the Access User Interface
  2. Fundamentals
  3. Tables and Their Views
  4. Tables
  5. Queries
  6. Forms
  7. Reports
  8. Optional: Databases and Access Terms
  9. Introduction to Microsoft Access 2013 Exam
 - expand Advanced Microsoft Access 2013
  1. Relationships
  2. Queries
  3. Table Functions
  4. Forms
  5. Reports
  6. Macros
  7. Completing the Desktop Application
  8. Advanced Microsoft Access 2013 Exam
  9. Microsoft Access 2013 Final Exam

Skill Sets

In this program, learn about the following:

  • The constantly changing workplace and team environment
  • The virtual workplace
  • Ethical behavior in the workplace and business etiquette
  • Causes of workplace stress and how to handle them
  • Business etiquette
  • Best practices for written and verbal communication
  • Effective customer service
  • Records Management
  • Different types of meetings

You will also be able to do the following:

  • Work with computers and machines in the office
  • Invest and investment terms
  • Make travel arrangements
  • Create a job search plan
  • Understand the functions of management

Learn to do the following in Excel:

  • Create and modify basic worksheets and perform calculations
  • Modify the appearance of data within a worksheet
  • Use the print features, formulas, and functions
  • Create and modify charts
  • Convert, sort, filter, and manage lists
  • Insert and modify illustrations and tables
  • Use conditional formatting, styles, and pivot tables
  • Trace precedents and dependents
  • Convert text and validate/ consolidate data
  • Collaborate with others by protecting worksheets and workbooks
  • Create, use, edit, and manage macros
  • Import and export data

Learn to do the following in Word:

  • Create, format, and edit documents
  • Create new documents and use templates
  • Add page numbers, headers and footers, and spell and grammar check documents
  • Work with images, including placing and sizing images, wrapping text around images, and using borders and effects
  • Adjust page orientation, layout, and columns
  • Change page and section breaks and add footnotes and endnotes
  • Change document views, using the navigation pane, and viewing multiple windows
  • Create a table of contents and insert bibliographies and indexes
  • Used advanced editing tools: track changes, accepting and rejecting changes, adding comments, and comparing and combining documents
  • Use Mail Merge and create envelopes and labels and protect documents
  • Use bookmarks, add watermarks, and customize the Ribbon

Learn to do the following in PowerPoint:

  • Start and end a PowerPoint session
  • Edit a presentation and run a slide show
  • Create different types of slides, format slides, and use templates
  • Use the Outline tab
  • Use the Slide Sorter to reorganize a presentation
  • Apply Tables and Charts and special effects to a presentation
  • Print various components of a presentation
  • Create customized presentations with templates
  • Use the slide, notes, and handout masters
  • Create, edit, and import charts
  • Create custom shows and manage hyperlinks
  • Secure and share presentations

Learn to do the following in Outlook:

  • Navigate the newest features
  • Explore the backstage view
  • Set up accounts and work with messages
  • Work with calendars and contacts
  • Create tasks and notes
  • Establish signatures and themes
  • Manage your inbox including filtering, creating search folders, and archiving
  • Toggle between multiple accounts

Learn to do the following in Access:

  • Understand database concepts and terminology
  • Use the Access interface
  • Become familiar with table views, queries, forms, reports, and macros and modules
  • Plan a database
  • Apply database design fundamentals
  • Practice within forms and use the Form Wizard
  • Generate reports and use the Report Wizard
  • Establish database relationships and table relationships
  • Work with queries, reports, and forms at an advanced level
  • Use macros
  • Complete the desktop application with the navigation form

Requirements

This program can only be taken on a PC. It is not Mac compatible. It is compatible with Windows XP and later operating systems and IE 7 and later browsers.

We highly recommend that you use Chrome and Firefox in place of other web browsers.

Adobe Flash Player and Adobe Acrobat Reader are required for this program.

You will need the Microsoft 2013 Suite for this program. If you do not have the Microsoft 2013 Suite 2013 installed, you can download a free trial offer of Microsoft Office in the program, which includes Word, Excel, PowerPoint, Outlook, and Access 2013.

Manuals are included as downloadable PDFs throughout the program.