Administrative Professional with Microsoft Office 2013 Master

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

To be a successful Administrative Professional, you must possess skills to handle a wide variety of workplace tasks and scenarios.  This program provides training across a variety of skills necessary for this field in addition to training in the four main Microsoft Office programs: Word, Excel, PowerPoint, and Outlook.

Microsoft Office 2013 skills are important to have in any profession or workplace. Being able to work with Office programs is essential to today's workplace whether you are preparing for an entry-level or an advanced position. Developing skills and experience working with Microsoft Word, Excel, PowerPoint, and Outlook will allow you to work independently and problem solve in your job.

The material is presented in a step-by-step manner, and you will learn by completing readings and hands-on exercises, in addition to watching video presentations. The program also includes quizzes and exams, so you can assess your skills at regular intervals.

In addition to these Microsoft Office skills, you will learn about the modern professional workplace and how to maintain a professional image. You will learn the importance of time management, and workplace behaviors and ethics.

This program will help you develop verbal and written communication skills to effectively communicate with your coworkers and superiors. You will also explore technology basics like working with computers and other office tools and devices.  Learn record keeping and financial management essentials in order to comfortably take on responsibilities like budgeting or handling invoices. Gain knowledge of event planning basics, so you can organize office meetings and special events. Learn travel basics such as how to create itineraries for other employees and how to book travel. Also, gain career advancement training and job searching skills.

When you register you receive six (6) months to complete this program

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

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. Microsoft Excel (2013) New Features
8. Intermediate Microsoft Excel 2013 Exam

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

Microsoft Excel 2013 Final Exam

Introduction to Microsoft Word 2013

1. Creating a Microsoft Word Document
2. The Ribbon
3. The 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

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

Advanced Microsoft Word 2013

1. Working with Long Documents
2. Reviewing and Collaborating on Documents
3. Comparing and Combining Documents
4. Managing Mailings
5. Protecting Documents
6. Random Useful Items
7. Advanced Microsoft Word 2013 Exam

Microsoft Word 2013 Final Exam

Introduction to Microsoft PowerPoint 2013

1. Creating a PowerPoint Presentation
2. The Ribbon
3. The Quick Access Toolbar
4. The File Tab
5. Formatting Microsoft PowerPoint Presentations
6. Working with Images
7. Working with Tables and Charts
8. Finalizing Microsoft PowerPoint Presentations
9. Introduction to PowerPoint 2013 Exam

Advanced Microsoft PowerPoint 2013

1. Customizing Presentations
2. Presentation Masters
3. Working with Special Effects
4. Using SmartArt
5. Multimedia
6. Setting up the Slide Show
7. Outlines and Slides
8. Sharing and Securing a Presentation
9. Advanced PowerPoint 2013 Exam

PowerPoint 2013 (MOS) Final Exam

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

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

Microsoft Outlook 2013 Final Exam

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 Basics
10. Developing Responsible Customer Service Skills
11. Developing Verbal and Nonverbal Communication
12. Customer Service Best Practices
13. Attracting Loyal Customers
14. Customer Service Exam
15. Become an Expert in Time Management
16. Microsoft Outlook and Time Management
17. Understanding the Importance of Goal Setting
18. Creating a Strategy to Achieve Smart Goals
19. Implementing by Building a Support System
20. Sustaining Goal Setting for Success
21. Goal Setting and Time Management Exam
22. The Impact of Unhealthy Personalities
23. Understanding People
24. Communication
25. Setting Boundaries
26. Handling Conflict
27. Working with Difficult People Exam
28. Major Functions and Forms of Business Writing
29. Writing and Communication Guidelines
30. Email and Instant Messenger
31. Letters, Documents, and Proposals
32. More Writing Tips
33. Business Writing Exam

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

Click here to download the Acrobat Reader.

Click here to download the Flash Player.

Students will need to have the Microsoft Office Professional 2013 Suite or Microsoft Office Professional Plus 2013 Suite to complete the course.

*Students can also have 2016 version; however, it is not reccomended as there may some differences and students may be unable to properly complete exercises.

Manuals are included as downloadable PDFs throughout the program.

Students should be familiar with using a personal computer, mouse, and keyboard. They should be comfortable in a Windows environment, and have the ability to launch and close activities and navigate to information stored on the computer. They should also have an ability to manage files and folders.

1.  Can I register for programs if I am an international student?

Yes, because ed2go programs are online you never have to actually travel to the school.  Most schools offer telephone or online registration.

2.  How long does it take to complete a program?

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace. When you register you receive six (6) months to complete this program.

3.  Do I have to buy additional materials?

No additional materials are required for this program.

4.  Can I get financial assistance?

ed2go courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements.

5.  What happens when I complete the program?

Upon successful completion of the program, you will be awarded a certificate of completion.

6.  Am I guaranteed a job?

ed2go programs will provide you with the skills you need to obtain an entry-level position in most cases. We don’t provide direct job placement services, but our facilitators and career counselors will help you build your resume and are available to give advice on finding your first job. Facilitators will also be available to use as a professional reference upon completion of the program. Potential students should always do research on the job market in their area before registering.

7.  Who will be my instructor?

Each student is paired with a facilitator for one-on-one interaction.  The facilitator will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.

8.  What software or hardware do I need in order to take online programs and what are the system requirements?

In order to take our online programs, you must have access to a computer and the Internet. You can access the program contents from any Web-enabled computer. You don’t have to use the same computer to log-in to the program every time.  We recommend that you have a word-processing program (Microsoft Word is best) and the latest version of Internet Explorer.

9.  Can I use a Mac?

No, this program cannot be taken on a Mac.

10.  How can I get more information about this program?

If you have questions that are not answered on our website, please feel free to contact us via LIVE chat (click the button above). If you are visiting us during non-business hours, please feel free to send us a question using the “Contact Us” form to the right.  You may also call us at 1-877-221-5151. We will answer your questions promptly.

11.  When can I start the program?

Our programs are all open enrollment. You can register and start the program as soon as you are ready.

Please note: Once the program curriculum is accessed online or through submission of a material shipment confirmation, refunds cannot be issued.

12.  Does this program prepare me to take Microsoft Office certification exams?

Yes, this program helps prepares you to take 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).

13.  What if I don't have enough time to complete my program within the time frame provided?

The time allotted to complete your program has been calculated based on the number of hours for each program, so don't worry too much about not completing in time. If, after a concerted effort, you are still unable to complete, your Student Advisor will help you work out a suitable completion date. Please note that a fee may be charged for an extension.