Administrative Professional with Microsoft Office 2013 Master

Career Training Program
Program Code: GES842
Hours: 445


Procert Exam Ready

The Administrative Professional with Microsoft Office 2013 Master training program teaches the basic and necessary skills to work as an Administrative Professional, including the proficiencies required to work with four major Microsoft Office programs: Word, Excel, PowerPoint, and Outlook. The program also prepares you for the Microsoft Certification Exams 77-418, 77-425, and 77-426 (Word), 77-420, 77-427, and 77-428 (Excel), 77-422 (PowerPoint), and 77-423 (Outlook).

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, records and financial management, event planning and travel, and how to achieve career advancement.

You will also learn advanced level skills in Microsoft Word, Excel, PowerPoint, and Outlook 2013.


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
  • Use the Ribbon and navigate the file tab
  • 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 
  • Use the ribbon, tabs, groups, and commands
  • 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