Advanced Administrative Assistant with Microsoft Office 2019 Course.

Learning Objectives

After completing this course, you should 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

Course Outline

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

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
• Engaging in Virtual meetings
  • Skype
  • Zoom
  • Microsoft Teams
  • Google Meet
  • GoToMeeting
  • ezTalks Meetings
  • StarLeaf
  • Cisco Webex
  • Toasty
  • Lifesize
• Time Management
• Creating Action Plans
• Keeping Accurate Records
• Filing Systems and File Cabinets

Module 3: Office Equipment and Computers Applications

• 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

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

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

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

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

Microsoft 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

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

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

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

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