Administrative Professional with Microsoft Office 2013

Administrative Professional with Microsoft Office 2013

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

Get A FREE Kindle Fire HD8!
meditec's new programs
student testimonial

What other students are saying...

I finished your school in late May and have JUST now found the time to touch base with you once again! I have been so excited about finishing and working!

Get A FREE Amazon Fire 7! Limited time offer - Get a FREE Amazon Fire 7" Tablet, Wi-Fi, 16 GB when you enroll with Meditec.com*. Offer expires 2/28/2017.
*Terms & Conditions Apply.

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 77-418, 77-425, and 77-426 (Word), 77-420, 77-427, and 77-428 (Excel), 77-422 (PowerPoint), 77-423 (Outlook), and 77-424 (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.

Eligible users will get a voucher for MS 77-418: Word 2013 exam

Eligibility Criteria:

A core-level candidate for the Microsoft Word 2013 exam should have a fundamental understanding of the Word environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Word 2013.These candidates should be able to create and edit 2-3 page documents for a variety of purposes and situations. Examples include professional-looking reports, multi-column newsletters, résumés, and business correspondence. Candidate roles might include students, clerical workers, instructors, and others.

Learning Objectives:

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

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

Program Outline:

Administrative Professional

  • The Dynamic Workplace
  • Workplace Behaviors
  • Communication Essentials
  • Technology Basics
  • Records and Financial Management
  • Meetings and Travel
  • Career Advancement
  • Administrative Professional Exam
  • Customer Service
  • Goal Setting and Time Management
  • Working with Difficult People
  • Business Writing
  • Administrative Professional Final Exam

Introduction to Microsoft Excel 2013

  • Creating a Microsoft Excel Workbook
  • The Ribbon
  • The Backstage View (The File Menu)
  • The Quick Access Toolbar
  • Entering Data in Microsoft Excel Worksheets
  • Formatting Microsoft Excel Worksheets
  • Using Formulas in Microsoft Excel
  • Working with Rows and Columns
  • Editing Worksheets
  • Finalizing Microsoft Excel Worksheets
  • Microsoft Excel (2013) New Features
  • Introduction to Microsoft Excel 2013 Exam

Intermediate Microsoft Excel 2013

  •  Advanced Formulas
  • Working with Lists
  • Working with Illustrations
  • Visualizing Your Data
  • Working with Tables
  • Advanced Formatting
  • Microsoft Excel (2013) New Features
  • Intermediate Microsoft Excel 2013 Exam

Advanced Microsoft Excel 2013

  • Using Pivot Tables
  • Auditing Worksheets
  • Data Tools
  • Working with Others
  • Recording and Using Macros
  • Random Useful Items
  • Microsoft Excel (2013) New Features
  • Advanced Microsoft Excel 2013 Exam
  • Microsoft Excel 2013 Final Exam

Introduction to Microsoft Word 2013

  • Creating a Microsoft Word Document
  • The Ribbon
  • The File Tab
  • The Quick Access Toolbar
  • Formatting Microsoft Word Documents
  • Editing Documents
  • Finalizing Microsoft Word Documents
  • Introduction to Microsoft Word 2013 Exam

Intermediate Microsoft Word 2013

  •  Advanced Formatting
  • Working with Tables
  • Working with Images
  • Page Layout
  • Working with Illustrations
  • Viewing Your Document(s)
  • Intermediate Microsoft Word 2013 Exam

Advanced Microsoft Word 2013

  • Working with Long Documents
  • Reviewing and Collaborating on Documents
  • Comparing and Combining Documents
  • Managing Mailings
  • Protecting Documents
  • Random Useful Items
  • Advanced Microsoft Word 2013 Exam
  • Microsoft Word 2013 Final Exam

Introduction to Microsoft PowerPoint 2013

  • Creating a PowerPoint Presentation
  • The Ribbon
  • The Quick Access Toolbar
  • The File Tab
  • Formatting Microsoft PowerPoint Presentations
  • Working with Images
  • Working with Tables and Charts
  • Finalizing Microsoft PowerPoint Presentations
  • Introduction to PowerPoint 2013 Exam

Advanced Microsoft PowerPoint 2013

  • Customizing Presentations
  • Presentation Masters
  • Working with Special Effects
  • Using SmartArt
  • Multimedia
  • Setting up the Slide Show
  • Outlines and Slides
  • Sharing and Securing a Presentation
  • Advanced PowerPoint 2013 Exam
  • PowerPoint 2013 (MOS) Final Exam

Introduction to Microsoft Outlook 2013

  • The Outlook Interface
  • Performing Popular Tasks in Outlook
  • Working with Messages
  • Working with the Calendar
  • Organizing Contacts
  • Introduction to Microsoft Outlook 2013 Exam

Advanced Microsoft Outlook 2013

  • Working with Tasks and Notes
  • Using Signature and Themes
  • Managing Your Inbox
  • Working with Multiple Email Accounts
  • Advanced Microsoft Outlook 2013 Exam
  • Microsoft Outlook 2013 Final Exam

Introduction to Microsoft Access 2013

  • Quick Overview of the Access User Interface
  • Fundamentals
  • Tables and Their Views
  • Tables
  • Queries
  • Forms
  • Reports
  • Optional: Databases and Access Terms
  • Introduction to Microsoft Access 2013 Exam

Advanced Microsoft Access 2013

  • Relationships
  • Queries
  • Table Functions
  • Forms
  • Reports
  • Macros
  • Completing the Desktop Application
  • Advanced Microsoft Access 2013 Exam
  • Microsoft Access 2013 Final Exam

Program Course List

Administrative Professional with Microsoft Office Specialist 2013: 455 Hours
The Administrative Professional with Microsoft Office Specialist 2013 training program prepares you for the Microsoft Office Specialist Certification Exams 77-418, 77-425, and 77-426 (Word), 77-420, 77-427, and 77-428 (Excel), 77-422 (PowerPoint), 77-423 (Outlook), and 77-424 (Access).

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.

Through these methods, you will learn essential introductory and advanced Office skills across Microsoft Office’s Word, Excel, PowerPoint, Outlook, and Access programs.

Introduction to Leadership: 5 Hours
This course examines how to be a successful (that is, effective) leader. Based on D. Quinn Mills’ book, Leadership: How to Lead, How to Live, a text used at Harvard Business School, this course asks the crucial questions about leadership in today’s organizations: What is leadership and why is it important? What does effective leadership require? What is visionary leadership? What is the role of charisma? What is the difference between managing, administering, and leading?

Leaders and Work-Life Balance: 5 Hours
This course addresses the question of work-life balance, one which is of great importance to leaders in all settings. Based on D. Quinn Mills’ book, Leadership: How to Lead, How to Live, a text used at Harvard Business School, this course looks at methods and techniques to reconcile work and family. You will also consider the question of personal fulfillment and the needs and demands of leadership.

Leading and Managing Change: 5 Hours
Whether adopting new technology or adapting to a drastic shift in an organization’s core focus, managers play a fundamental role in effecting changes. Based on D. Quinn Mills’ book, Leadership: How to Lead, How to Live, a text used at Harvard Business School, this course addresses the key issues managers face in a dynamic environment. By understanding the steps in effecting change and how to overcome resistance, a manager can successfully lead change at various levels of an organization.

Leading Teams: 5 Hours
This course addresses the key issues surrounding leadership in a team. Why is it important? What does it require for a team leader to lead his team effectively? Based on D. Quinn Mills’ book, Leadership: How to Lead, How to Live, a text used at Harvard Business School, this course considers how team leaders must account for the special and unique circumstances of working in a team, where responsibility, accountability, communication, and leadership are shared.

Business Essentials: 30 Hours
This course teaches students the basic necessities of business, to help them develop core competencies they can use in the business world. The course provides a broad introduction to business, covering business principles, structure, and functions of management. The course examines the purposes and activities of organizations of various types, sizes and structures, and explores the interrelationships among functional departments. Students will also learn about different forms of ownership, management functions, styles, and processes. Learning objectives for each lesson are accomplished through a combination of theory and conceptual application within exercises. Students are given ample opportunity to practice, apply, and develop their business knowledge and skills through review questions and practical exercises. Course manual provided for on-going reference. There is a final exam upon completion of the course. Participants who receive 75% or higher on their exam will receive a certificate.

Management Fundamentals: 25 Hours
Management Fundamentals is an introductory management course that provides students with the essential tools required of today’s effective supervisors or junior managers. The course combines theoretical, how-to information, with practical applications. Students are required to draw on their own experiences, to research information, and to apply their knowledge to typical junior management situations. The course provides students with a balance of soft and hard skills. The soft skills students will develop and apply to realistic case studies include communication, problem-solving, decision-making, negotiating, planning and organizing, time management, facilitating, and coordinating. The hard skills include setting goals and objectives; preparing forecasts and budgets; using planning and organizing tools; maintaining records; drafting training and development plans, procedural checklists, and reward initiatives; and developing strategies. Course aims to assist students in learning how to handle the basic responsibilities of a managerial position.

Marketing and Sales: 30 Hours
Course introduces students to the theory and application of modern marketing concepts, principles, and techniques, and examines the importance of marketing in society as well as within a company. Learning objectives for each lesson are accomplished through a combination of theory and conceptual application within exercises. Students are given ample opportunity to practice, apply, and develop their skill set.

Business Financial Management: 40 Hours
The Business Financial Management course teaches students about the fundamentals of business financial management, and helps them to develop core competencies to understand and analyze financial information presented in typical business scenarios.

Business in the Electronic Age: 30 Hours
The Business in the Electronic Age course introduces students to the effects the Internet and other modern technological innovations have had on the global business landscape, specifically the components of ebusiness: business to business commerce, business to consumer commerce, and internal business processes. It focuses on how technology has altered the way businesses operate, with respect to communications, distribution, sales and marketing, procurement, and the management of information. In addition, students examine how organizations use the Internet and software systems to remain productive and competitive in their existing marketplaces, thereby driving technological innovation.

Business Presentation Skills: 25 Hours
The Business Presentations course is designed to introduce students to tools and techniques used to create and deliver effective presentations to many types of audiences, including managers, colleagues and existing and prospective clients. Students are given the opportunity to explore and practice these techniques throughout the course. Students gain insight into producing effective presentations at each stage of the presentation development process, i.e., planning, creating, strengthening, and delivery. Students are given the opportunity to practice, apply, and develop presentation skills through the completion of hands-on tasks and exercises found throughout each lesson.

Business Correspondence Level 1: 25 Hours
This course places emphasis on the acquisition of skills and style mechanics needed to produce personal and office correspondence. The parts of a business letter are examined in detail, as are the guidelines for organizing and writing a letter.

Human Resource Management: 30 Hours
The Human Resource Management course introduces students to the key concepts and processes of effective human resource management, and exposes them to this dynamic and diverse field. This course provides a foundation in theory and practice of techniques and activities that organizations utilize in acquiring, developing, and maintaining an effective workforce. Topics include human resources planning, recruitment and selection of staff, training and development, performance appraisal, compensation, and employee safety, security, and health. Current events, relevant legislation, and future trends are also explored. Learning objectives for each lesson are accomplished through a combination of theory and conceptual application within exercises. Students are given ample opportunity to practice, apply, and develop their human resource skills through review questions and practical exercises. Multimedia content is incorporated in this course to introduce.

Office Procedures Level 1: 30 Hours
This course teaches introductory office procedures and practices to the novice office worker. It consists of six Lessons and a Final Exam. Each Lesson is divided into Sections with related Tasks. There are questions at the end of each Lesson designed to reinforce the concepts the student has learned in the Lesson.

Office Procedures Level 2: 30 Hours
This course covers a variety of topics as it simulates an office environment and challenges students with tasks that they would typically perform. This course consists of six Lessons and a Final Exam. Each Lesson is divided into Sections with related Tasks. There are questions at the end of each Lesson designed to reinforce the concepts the student has learned in the Lesson.

COURSE MATERIAL:

Manuals are included as downloadable PDFs throughout the program.

REGISTRATION CRITERIA

Students should meet the following eligibility criteria:

  • High School Diploma or equivalent
  • English Proficiency

Students need to possess proficiency in reading and writing the English Language, as all of our programs are administered in English. This enables students to communicate effectively through written assignments at the end of each Module.

SYSTEM REQUIREMENTS

Software

  • 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 the latest version of Chrome and Firefox in place of other web browsers.
    • Cookies must be enabled
    • JavaScript must be enabled
    • Pop-ups must be enabled/allowed
  • 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.
  • You will need Microsoft Office Professional 2013 for this program.
  • Manuals are included as downloadable PDFs throughout the program.
  • The latest Windows Media Player (free download available)
  • The latest Quick Time Player (free download available)
  • The latest Real Player (free download available)
  • The latest Shockwave Player (free download available)
  • The latest Java (free download available)

Hardware

  • Video card
  • Sound card
  • 512 MB RAM or greater of memory
  • Headphones or Speakers

Renae Evaro

Renae has extensive experience in the business world, including time spent in the Health Care, Finance, Regulatory and Compliance, and the Restaurant industries. Renae has a B.B.A in Finance and plans to return to school to obtain her masters. Renae has held various positions throughout her career, from an In-House Trainer for a Home Health company to a Compliance Analyst.

Renae is committed to helping others be successful and is excited to help students with their careers.

Start Your New Career Today! Call us or Enroll Now!

Financing Options
Enroll in Courses Online

Student Information

We have options for financing your education. We offer three different monthly payment plans for your convenience. There are also Federal and State Grant Funding programs and the Military MyCAA Program. Click “NEED MORE INFO” button and an admissions advisor will contact you directly to discuss the option that will work the best for you.

Enrollment Summary

Administrative Professional with Microsoft Office 2013

Other Online Careers
  • Medical and Healthcare Training Programs

    Explore our online Medical & Healthcare programs.

    Learn more
  • Legal Career Training Program

    Explore our online Legal programs

    Learn more
  • Creative Arts courses

    Explore our online Creative Arts programs.

    Learn more
  • Fitness and Nutrition Courses

    Explore our online Fitness and Nutrition programs

    Learn more