• Product Library
  • School Locator

    Administrative Assistant with Microsoft Office 2019

    This multimedia-rich course is designed for administration professionals to enhance their skills and acquire command over Microsoft Office 2019. It will allow them to leverage their cutting-edge skills in the job market and increase their worth. This course offers training in useful tools and powerful strategies to help you deal with your job responsibilities more efficiently.

    Program Name

    Administrative Assistant with Microsoft Office 2019

    Program Code

    WE-BP-7X927

    Website Short Description

    This multimedia-rich course is designed for administration professionals to enhance their skills and acquire command over Microsoft Office 2019. It will allow them to leverage their cutting-edge skills in the job market and increase their worth.
    This course offers training in useful tools and powerful strategies to help you deal with your job responsibilities more efficiently.
    This course contains two modules:
    • Administrative Assistant
    • Microsoft Office 365 Training Bundle Suite 2019

    This course covers the following applications of Microsoft office 2019:
    • Microsoft Word 2019
    • Microsoft Excel 2019
    • Microsoft PowerPoint 2019
    • Microsoft Outlook 2019
    • Microsoft Access 2019
    • Microsoft Publisher 2019

    After completing this course, you’ll be able to:
    ? Type quickly and effectively
    ? Identify the steps to complete general office procedures
    ? Comprehend the basics of working within Microsoft® Office
    ? Identify the steps for creating business documents using professional language
    ? Identify the basic requirements for bookkeeping and accounting in the office
    ? Recall ways to create, edit, and print documents in Word
    ? Recognize how to create and manage worksheets in Excel
    ? Identify the steps to develop presentations in PowerPoint
    ? List how to create and manage databases in Access
    ? Identify the steps to manage email and calendars in Outlook

    Duration

    12 months

    Hours

    375

    Language

    English

    Prerequisites

    There are no specific prerequisites for this program but it is recommended that students have the Microsoft Office suite installed on their computer. Students will need access to both a computer and the internet. Students should have basic keyboarding and computer skills, and be comfortable navigating the internet.

    Outline

    Administrative Assistant
    Administrative Assistant Module 1
    Typing Practice & Improvement
    • Pre-Test Your Typing Ability
    • Finger Positioning Exercises
    • Typing Practice Games
    • Typing Progress Tracking
    • Improve Your Typing Skills
    • Increase Your Typing Speed

    Administrative Assistant Module 2
    General Office Procedures
    • The New Administrative Assistant
    • The Daily Routine
    • Telephone Usage & Etiquette Tips
    • Mail Services and Shipping
    • Travel Arrangements
    • Transportation Reservations
    • Dealing with Meetings
    • Meeting Agendas and Minutes
    • Time Management
    • Creating Action Plans
    • Keeping Accurate Records
    • Filing Systems and File Cabinets

    Administrative Assistant Module 3
    Office Equipment and Computers
    • Understanding Office Equipment
    • Using Microsoft Windows
    • Using Apple Macintosh
    • Navigating with Mac OS X
    • Email Accounts & Programs
    • Organizing Your Email
    • Using the Internet
    • Computer Networking
    • Web Conferencing
    • Data Security
    • Troubleshooting Computer Problems
    • Office Ergonomics

    Administrative Assistant Module 4
    Using Microsoft Office
    • Common Microsoft Office 2010 Features
    • Using Microsoft Word
    • Using Microsoft PowerPoint
    • Using Microsoft Excel
    • Using Microsoft Publisher
    • Using Microsoft One Note
    • Using Microsoft Outlook
    • Using Microsoft Web Applications

    Administrative Assistant Module 5
    Business Documents
    • Creating a Great Business Letter
    • Appearance and Paragraphing
    • Interoffice Memorandums and E-Mails
    • Reports and Report Templates
    • Press Releases
    • Editing and Proofreading
    • Forms of Address
    • Legal Documents and Terms
    • Grammalogues
    • Notary Public Forms
    • Agreements and Contracts
    • Legal and Real Estate Terms

    Administrative Assistant Module 6
    Language Usage
    • Grammar
    • Using Adjectives and Adverbs
    • Language Usage and Style
    • Subject-Verb Agreement
    • Avoiding Redundancies
    • Phrases and Words to Omit
    • Common English Usage Problems
    • Spelling and Spell Check
    • American English vs. British English
    • Punctuation: Using a Period or Comma
    • Writing Numerals
    • Roman Numerals

    Administrative Assistant Module 7
    Financial Activities
    • Bookkeeping and Accounting
    • Business Taxes
    • The Company’s Bank
    • Business and Financial Information for Small Businesses
    • U.S. Weights and Measures
    • International Weights and Measures (Metric)
    • Business Math
    • Career Advancement
    • Growing as the Company Grows
    • Presentation Skills
    • Communication Skills
    • Office Management and Supervision

    Module 1: Office 365
    Lesson 1: Common Office Tasks
    • All About Office 365
    • Office Interface
    • Saving Your Files
    • Manipulating the Text
    • Handling Case or Capitalization
    • Entering Symbols and Foreign Characters
    • Undoing and Repeating Commands
    • Correcting Typos
    • AutoCorrect Command
    Lesson 2: One Step Beyond
    • Customizing the Ribbon
    • Customizing the Quick Access Toolbar
    • Ways of Distributing Your Work
    • Working with Publisher
    • Printing a Publication
    • Filing Sharing and Collaborating
    • OneDrive
    • Sharing Files and Folders with Other
    Lesson 3: Working with Charts and Graphs
    • Creating a Chart
    • Saving a Chart as a Template
    • Chart Tricks
    • SmartArt Diagram
    • Handling Graphics and Photos
    • Touching Up a Picture
    • Drawing and Manipulating Lines, Shapes and Objects
    • WordArt
    Lesson 4: Working with Publisher
    • Introducing Frames
    • Creating a Publication
    • Redesigning a Publication
    • Formatting Text
    • Text Wraps
    • Placeholder Pictures
    • Frames
    • Decorating the Text
    • Design Checker
    Lesson 5: Working with Access
    • Tables and Queries
    • Forms
    • Creating a Database File
    • Designing a Database
    • Field Properties
    • Entering Data
    • Sorting
    • Querying
    • Filtering for Data
    Lesson 6: SharePoint for End Users
    • SharePoint Overview
    • Creating Your First Site
    • Adding Content to the Team Site
    Module 2: Word
    Lesson 1: Working with Word Part I
    • Getting Started with Word 2019
    • Formatting Text and Paragraphs
    • Working More Efficiently
    • Managing Lists
    • Adding Tables
    • Inserting Graphic Objects
    • Controlling Page Appearance
    • Preparing to Publish a Document
    Lesson 2: Working with Word Part II
    • Organizing Content Using Tables and Charts
    • Customizing Formats Using Styles and Themes
    • Inserting Content Using Quick Parts
    • Using Templates to Automate Document Formatting
    • Controlling the Flow of a Document
    • Simplifying and Managing Long Documents
    • Using Mail Merge to Create Letters, Envelopes, and Labels
    Lesson 3: Working with Word Part III
    • Manipulating Images
    • Using Custom Graphic Elements
    • Collaborating on Documents
    • Adding Document References and Links
    • Securing a Document
    • Using Forms to Manage Content
    • Automating Repetitive Tasks with Macros
    Module 3: Excel
    Lesson 1: Working With Excel Part I
    • Getting Started with Microsoft Office Excel 2019
    • Performing Calculations
    • Modifying a Worksheet
    • Formatting a Worksheet
    • Printing Workbooks
    • Managing Workbooks
    • Adding Borders and Colors to Worksheets
    • Basic Excel Customization
    Lesson 2: Working with Excel Part II
    • Working with Functions
    • Working with Lists
    • Analyzing Data
    • Visualizing Data with Charts
    • Using PivotTables and PivotCharts
    • Working with Graphical Objects
    • Using Array Formulas
    Lesson 3: Working with Excel Part III
    • Working with Multiple Worksheets and Workbooks
    • Sharing and Protecting Workbooks
    • Automating Workbook Functionality
    • Using Lookup Functions and Formula Auditing
    • Forecasting Data
    • Creating Sparklines and Mapping Data
    • Importing and Exporting Data
    • Internationalizing Workbooks
    • Working with Power Pivot
    • Advanced Customization Options
    • Working with Forms and Controls
    Module 4: PowerPoint
    Lesson 1: Working With PowerPoint Part I
    • Getting Started with PowerPoint 2019
    • Developing a PowerPoint Presentation
    • Performing Advanced Text Editing Operations
    • Adding and Arranging Graphical Elements
    • Modifying Graphical Elements
    • Preparing to Deliver Your Presentation
    Lesson 2: Working with PowerPoint Part II
    • Customizing Design Templates
    • Using Ink to Hand Draw Elements
    • Adding Tables
    • Adding Charts
    • Working with Media
    • Building Advanced Transitions and Animations
    • Finalizing a Presentation
    • Customizing Presentation Navigation
    • Securing and Distributing a Presentation
    Module 5: Outlook
    Lesson 1: Working With Outlook Part I
    • Getting Started With Outlook 2019
    • Formatting Messages
    • Working with Attachments and Illustrations
    • Customizing Message Options
    • Organizing Messages
    • Managing Your Contacts
    • Working with the Calendar
    • Working with Tasks and Notes
    Lesson 2: Working with Outlook Part II
    • Modifying Message Properties and Customizing Outlook
    • Organizing, Searching, and Managing Messages
    • Managing Your Mailbox
    • Automating Message Management
    • Working with Calendar Settings
    • Managing Contacts
    • Managing Activities Using Tasks
    • Sharing Outlook Items
    • Managing Outlook Data Files

    Audience

    The intended audience for this program is individuals that are seeking to enhance their skills or find employment as an Administrative Assistant.

    Certification

    Upon successful completion of our Administrative Assistant course, students will be prepared to sit for the NCCB national certification exam to become a Certified Administrative Assistant (CAA). Upon successful completion of our Microsoft® Office 2019 course, students will be prepared to sit for the Microsoft Office 2019 exams. Each state may have additional licensing requirements, be sure to research your states requirements for employment by visiting your states occupation board.

    Instructor Description

    This class is supported by an Educational Mentor. Educational mentors have worked or are working in the subject they mentor. Educational Mentors review student work, student progress, and interact with students as needed. They respond to any questions or concerns you might have, as well as encouraging and motivating you to succeed.

    Required Materials

    All required reference materials are provided with this program. NOTE: This course does NOT include the MS Office programs themselves.

    Technical requirements:
    Internet Connection
    • Broadband or High-Speed (DSL, Cable, Wireless)
    Hardware Requirements
    • Processor - 2GHz Processor or Higher
    • Memory - 1 GB RAM Minimum Recommended

    Software Requirements
    • Operating Systems - Windows 7, 8 or 10; Mac OS x 10 or higher
    • Internet Browsers - Google Chrome is highly recommended
    • Cookies MUST be enabled
    • Pop-ups MUST be allowed (Pop-up Blocker disabled)

    Reviews

    No customer reviews for the moment.

    Write your review