University of New Mexico, Continuing Education Division
Home > Training Programs > Administrative > Administrative Professional with Microsoft Office 2016 Master


Fill out the form below

Close Window

Thank you for your interest in this program. We should be contacting you shortly.

Close Window

Administrative Professional with Microsoft Office 2016 Master

$1,995.00 (USD)




I. Introduction to Microsoft Excel
    A.    Creating a Microsoft Excel Workbook
    B.    The Ribbon
    C.    The Backstage View (The File Menu)
    D.    Entering Data in Microsoft Excel Worksheets
    E.    Formatting Microsoft Excel Worksheets
    F.    Using Formulas in Microsoft Excel
    G.    Working with Rows and Columns
    H.    Editing Worksheets
    I.    Finalizing Microsoft Excel Worksheets
    J.    Microsoft Excel Features that Were New in 2013
    K.    Features New in 2016
    L.    Introduction to Microsoft Excel 2016 Exam
II. Intermediate Microsoft Excel 2016
    A.    Advanced Formulas
    B.    Working with Lists
    C.    Working with Illustrations
    D.    Visualizing Your Data
    E.    Working with Tables
    F.    Advanced Formatting
    G.    Microsoft Excel Features that Were New in 2013
    H.    Features New in 2016
    I.    Intermediate Microsoft Excel 2016 Exam
III. Advanced Microsoft Excel 2016
    A.    Using Pivot Tables
    B.    Auditing Worksheets
    C.    Data Tools
    D.    Working with Others
    E.    Recording and Using Macros
    F.    Random Useful Items
    G.    Microsoft Excel Features that Were New in 2013
    H.    Features New in 2016
    I.    Advanced Microsoft Excel 2016 Exam
IV. Microsoft Excel Final Exam

V. Introduction to Microsoft Word 2016
    A.    Creating a Microsoft Word Document
    B.    The Ribbon
    C.    The File Tab
    D.    The Quick Access Toolbar
    E.    Formatting Microsoft Word Documents
    F.    Editing Documents
    G.    Finalizing Microsoft Word Documents
    H.    Introduction to Microsoft Word 2016 Exam
VI. Intermediate Microsoft Word 2016
    A.    Advanced Formatting  
    B.    Working with Tables
    C.    Working with Images
    D.    Page Layout
    E.    Working with Illustrations
    F.    Viewing Your Document(s)
    G.    Intermediate Microsoft Word 2016 Exam
VII. Advanced Microsoft Word 2016
    A.    Working with Long Documents
    B.    Reviewing and Collaborating on Documents
    C.    Comparing and Combining Documents
    D.    Managing Mailings
    E.    Protecting Documents
    F.    Random Useful Items
    G.    Advanced Microsoft Word 2016 Exam
VIII. Microsoft Word 2016 Final Exam

IX. Introduction to Microsoft PowerPoint 2016
    A.    Creating a PowerPoint Presentation
    B.    The Ribbon
    C.    The Quick Access Toolbar
    D.    The Backstage View (The File Menu)
    E.    Formatting Microsoft PowerPoint Presentations
    F.    Working with Images
    G.   Working with Tables and Charts
    H.    Finalizing Microsoft PowerPoint Presentations
    I.      Introduction to Microsoft PowerPoint 2016 Exam
X. Advanced Microsoft PowerPoint 2016
    A.    Customizing Presentations
    B.    Presentation Masters
    C.    Working with Special Effects
    D.    Using SmartArt
    E.    Multimedia
    F.    Setting up the Slide Show
    G.    Outlines and Slides
    H.    Managing Multiple Presentations
    I.    Sharing and Securing a Presentation
    J.    Features New in 2016
    K.   Advanced Microsoft PowerPoint 2016 Exam
XI. Microsoft PowerPoint 2016 Final Exam

XII. Introduction to Microsoft Outlook 2016
    A.    The Outlook 2016 Interface
    B.    Performing Popular Tasks in Outlook 2016
    C.    Working with Messages
    D.    Working with the Calendar
    E.    Organizing Contacts
    F.    Introduction to Microsoft Outlook 2016 Exam
XIII. Advanced Microsoft Outlook 2016
    A.    Working with Tasks and Notes
    B.    Using Signature and Themes
    C.    Managing Your Inbox
    D.    Working with Multiple Email Accounts
    E.    New Features in 2016
    F.    Advanced Microsoft Outlook 2016 Exam
XIV. Microsoft Outlook Final Exam

Administrative Professional
XV. Administrative Professional
    A.    The Dynamic Workplace
    B.    Workplace Behaviors
    C.    Communication Essentials
    D.    Technology Basics
    E.    Records and Financial Management
    F.    Meetings and Travel
    G.    Career Advancement
    H.    Administrative Professional Exam
XVI. Customer Service
    A.    Customer Service Basics
    B.    Developing Responsible Customer Service Skills
    C.    Developing Verbal and Nonverbal Communication
    D.    Customer Service Best Practices
    E.    Attracting Loyal Customers
    F.    Customer Service Exam
XVII. Goal Setting and Time Management
    A.    Become an Expert in Time Management
    B.    Understanding the Importance of Goal Setting
    C.    Creating a Strategy to Achieve Smart Goals
    D.    Implementing by Building a Support System
    E.    Sustaining Goal Setting for Success
    F.    Goal Setting and Time Management Exam
XVIII. Working with Difficult People
    A.    The Impact of Unhealthy Personalities
    B.    Understanding People
    C.    Communication
    D.    Setting Boundaries
    E.    Handling Conflict
    F.    Working with Difficult People Exam
XIX. Business Writing
    A.    Major Functions and Forms of Business Writing
    B.    Writing and Communication Guidelines
    C.    Email and Instant Messenger
    D.    Letters, Documents, and Proposals
    E.    More Writing Tips
    F.    Business Writing Exam





University of New Mexico, Continuing Education Division
Division of Continuing Education
1634 Univeristy Blvd. NE
Albuquerque, NM 87131 US

Copyright © Education To Go. All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Education To Go. Education To Go and ed2go are registered trademarks of Education To Go, a part of Cengage Learning.