Help Icon

ETG8074

Course
ETG8074
Course Title
Microsoft Office 2013 Master Certification Training

Description

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.  Test vouchers not included.  Go to http://www.cpcc.edu/computertraining to schedule your exams.  Offered in partnership with ed2go.

Objectives

The program  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).

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

Content

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

 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 Basics
  • Developing Responsible Customer Service Skills
  • Developing Verbal and Nonverbal Communication
  • Customer Service Best Practices
  • Attracting Loyal Customers
  • Customer Service Exam
  • Become an Expert in Time Management
  • Microsoft Outlook and Time Management
  • Understanding the Importance of Goal Setting
  • Creating a Strategy to Achieve Smart Goals
  • Implementing by Building a Support System
  • Sustaining Goal Setting for Success
  • Goal Setting and Time Management Exam
  • The Impact of Unhealthy Personalities
  • Understanding People
  • Communication
  • Setting Boundaries
  • Handling Conflict
  • Working with Difficult People Exam
  • Major Functions and Forms of Business Writing
  • Writing and Communication Guidelines
  • Email and Instant Messenger
  • Letters, Documents, and Proposals
  • More Writing Tips
  • Business Writing Exam

Method of Instruction

Online

Evaluation

Class Participation