cart-icn

You already have a course in your cart

You can only add one course to your cart at a time! By adding this course, you will replace the existing course from your cart. How would you like to proceed?

The Executive Assistant with Microsoft Office Specialist (MOS) Expert (Vouchers Included) includes: Microsoft Office Specialist (MOS) Expert Certification Training (Vouchers Included)
Certified Administrative Professional (Voucher Included)
Management Training

Executive Assistant with Microsoft Office Specialist (MOS) Expert (Vouchers Included)

Prepare for a career as an executive assistant with comprehensive training in administrative skills and Microsoft Office. This course equips you for the Certified Administrative Professional (CAP) and Microsoft Office Specialist (MOS) Expert certifications, with exam vouchers included.

executive-assistant-with-microsoft-office-specialist-2019
$5,715.00 (USD)
List Price: $7,765.00
Save: $2,050.00 (26% off)

currency dollar icon
Payment & Funding: view your options
arrow right icon
Have a question?We're here to help
Back
customer service representatives

Explore your payments options

When it comes to paying for your course-you've got options! Schedule a call with us and we can help you find the payment method that works best for you.
credit card icon

Credit Card: Visa, Mastercard, Discover or American Express card Most Popular

affirm icon Affirm:

wallet icon

TuitionFlex: Low-interest monthly payments

building icon

Workforce Funding: Learn about eligibility

start icon

Military Benefits: Find out if your benefits apply

close icon

Overview

Objective

Outline

  1. Part 1 - Microsoft Office Specialist (MOS) Associate Certification Training
      Unit 1 - Introduction to Microsoft Excel Training

      Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

      • Logging in to Microsoft 365
      • Installing Applications
      • Creating New Files and AutoSaving
      • Protected View
      • File Sharing
      • File Collaboration
      • Version History
      • Getting Updates
      • Mac Versions

      Lesson 2: Creating a Microsoft Excel Workbook - Quizzes: 1, Assignments: 1

      • Starting Microsoft Excel
      • Creating a Workbook
      • Saving a Workbook
      • The Status Bar
      • Adding and Deleting Worksheets
      • Copying and Moving Worksheets
      • View Options for the Worksheet
      • Closing a Workbook

      Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

      • Tabs
      • Groups and Commands
      • Microsoft Search Box
      • Customizing the Ribbon

      Lesson 4: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 3

      • Introduction to the Backstage View
      • Opening a Workbook
      • New Workbooks and Excel Templates
      • Printing Worksheets
      • Personalizing Microsoft Office

      Lesson 5: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

      • Getting Started
      • Adding Common Commands
      • Adding Additional Commands with the Customize Dialog
      • Adding Ribbon Commands or Groups

      Lesson 6: Entering Data in Microsoft Excel Worksheets - Quizzes: 1, Assignments: 2

      • Entering Text
      • Inserting and Deleting Cells
      • Inserting Hyperlinks
      • Inserting WordArt
      • Using AutoComplete
      • Entering Numbers and Dates
      • Using the Fill Handle

      Lesson 7: Formatting Microsoft Excel Worksheets - Quizzes: 1, Assignments: 4

      • Selecting Ranges of Cells
      • Hiding Worksheets
      • Adding Color to Worksheet Tabs
      • Adding Themes to Workbooks
      • Adding a Watermark
      • The Font Group
      • The Alignment Group
      • The Number Group

      Lesson 8: Editing Worksheets - Quizzes: 1, Assignments: 2

      • Find
      • Find and Replace
      • Using the Clipboard
      • Moving Columns / Rows

      Lesson 9: Working with Rows and Columns - Quizzes: 1, Assignments: 1

      • Inserting and Deleting Rows, Columns, and Cells
      • Transposing Rows and Columns
      • Row Height and Column Width
      • Hiding and Unhiding Rows and Columns
      • Freezing Panes

      Lesson 10: Using Formulas in Microsoft Excel - Quizzes: 1, Assignments: 1

      • Math Operators and the Order of Operations
      • Entering Formulas
      • AutoSum (and Other Common Auto-Formulas)
      • Copying Formulas
      • Relative, Absolute, and Mixed Cell References

      Lesson 11: Finalizing Microsoft Excel Worksheets - Quizzes: 1, Assignments: 1

      • Setting Margins
      • Setting Page Orientation
      • Setting the Print Area
      • Print Scaling (Fit Sheet on One Page)
      • Repeating Headings
      • Headers and Footers

      Lesson 12: Using Copilot in Microsoft Excel - Quizzes: 1, Assignments: 1

      • Copilot in Microsoft 365 Excel
      • Creating Columns
      • Analyzing Your Data
      • Importing and Framing Data

      Introduction to Microsoft Excel Exam

      Unit 2 - Intermediate Microsoft Excel Training

      Lesson 1: Common Functions - Quizzes: 1, Assignments: 7

      • Using Named Ranges in Formulas
      • Using Formulas That Span Multiple Worksheets
      • Functions: IF and IFS
      • Functions: AND and OR
      • Functions: NOT
      • Functions: SWITCH
      • Functions: COUNTIF, AVERAGEIF, and SUMIF
      • Functions: PMT and NPER
      • Functions: TEXTJOIN and CONCAT
      • Text Functions
      • Date and Time Functions

      Lesson 2: Working with Lists - Quizzes: 1, Assignments: 4

      • What is a List of Data?
      • Removing Duplicates from a List
      • Sorting Data in a List
      • Filtering Data in a List
      • Adding Subtotals to a List

      Lesson 3: Visualizing Your Data - Quizzes: 1, Assignments: 2

      • Chart Basics
      • Tools for Editing Charts
      • The Format Tool Tab
      • Using the Three Chart Buttons
      • The Format Task Pane
      • Useful Charts
      • Line and Area Charts
      • Hierarchy Charts
      • Statistic Charts
      • Other Charts
      • Combo Charts
      • Using Recommended Charts
      • Sparklines
      • Add and Format Objects
      • Working with Shapes
      • Working with Icons
      • Working with SmartArt
      • Using the Quick Analysis Tool

      Lesson 4: Working with Tables - Quizzes: 1, Assignments: 1

      • Format Data as a Table
      • Table Design Tool Tab
      • Formatting Individual Cells
      • Selecting Table Rows and Columns
      • Structured References
      • Convert a Table to a Range

      Lesson 5: Advanced Formatting - Quizzes: 1, Assignments: 2

      • Cell Styles
      • Conditional Formatting
      • Conditional Formatting: Highlight Cells Rules
      • Conditional Formatting: Top/Bottom Rules
      • Conditional Formatting: Data Bars, Color Scales, and Icon Sets
      • Conditional Formatting: Create a New Rule
      • Removing Conditional Formatting

      Intermediate Microsoft Excel Exam

      Unit 3 - Advanced Microsoft Excel Training

      Lesson 1: Using PivotTables - Quizzes: 1, Assignments: 1

      • How PivotTables Work
      • Timeline Filters
      • Inserting Slicers
      • Grouping Data
      • Calculated Fields
      • PivotCharts

      Lesson 2: Advanced Functions - Quizzes: 1, Assignments: 2

      • Function Syntax
      • ROWS, COLUMNS, INDEX, and XMATCH
      • Arrays and Array Formulas
      • SORT, FILTER, and SORTBY
      • Lookup Functions
      • The LET Function
      • The TRANSPOSE Function

      Lesson 3: Auditing Workbooks - Quizzes: 1, Assignments: 1

      • Inspecting a Workbook
      • Tracing Precedents and Dependents
      • Watch Window
      • Evaluating Formulas
      • Error Checking

      Lesson 4: Data Tools - Quizzes: 1, Assignments: 5

      • Importing Data from Online Source
      • Converting Text to Columns
      • Importing Files
      • Linking to External Data
      • Controlling Calculation Options
      • Data Validation
      • Consolidating Data
      • What-If Analysis

      Lesson 5: Recording and Using Macros - Quizzes: 1, Assignments: 2

      • Recording Macros
      • Running Macros
      • Editing Macros
      • Adding Macros to the Quick Access Toolbar

      Lesson 6: Working with Others - Quizzes: 1, Assignments: 1

      • Comments and Notes
      • Protecting Worksheets and Workbooks
      • Marking a Workbook as Final
      • Other Sharing Concerns

      Advanced Microsoft Excel Exam, Final Microsoft Excel Exam

      Unit 4 - Introduction to Microsoft Word Training

      Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

      • Logging in to Microsoft 365
      • Installing Applications
      • Creating New Files and AutoSaving
      • Protected View
      • File Sharing
      • File Collaboration
      • Version History
      • Getting Updates
      • Mac Versions

      Lesson 2: Creating a Microsoft Word Document - Quizzes: 1, Assignments: 1

      • Starting Microsoft Word
      • Creating a Document
      • Saving a Document
      • The Status Bar
      • Closing a Document
      • Opening Documents

      Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

      • Tabs
      • Groups and Commands
      • Microsoft Search Box
      • Customizing the Ribbon

      Lesson 4: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 3

      • Introduction to the Backstage View
      • Opening a Document
      • New Documents and Word Templates
      • Configuring Documents to Print
      • Adding Your Name to Microsoft Word
      • Adding Values to Document Properties

      Lesson 5: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

      • Getting Started
      • Adding Common Commands
      • Adding Additional Commands with the Customize Dialog
      • Adding Ribbon Commands or Groups

      Lesson 6: Formatting Microsoft Word Documents - Quizzes: 1, Assignments: 7

      • Selecting Text
      • Fonts
      • Working with Lists
      • Inserting a Hyperlink in a Document
      • Using Styles
      • Using Themes
      • Using the Ruler
      • Indentation
      • Setting Margins
      • Special Characters
      • WordArt
      • Page Background Elements

      Lesson 7: Editing Documents - Quizzes: 1, Assignments: 2

      • Find
      • Find and Replace
      • Using the Clipboard
      • Search Options
      • Inserting Text from Another File

      Lesson 8: Finalizing Microsoft Word Documents - Quizzes: 1, Assignments: 3

      • Adding Page Numbers
      • Headers and Footers
      • Microsoft Editor
      • Checking Spelling and Grammar
      • Internationalization and Accessibility

      Lesson 9: Using Copilot in Microsoft Word

      • Copilot in Microsoft 365 Word
      • Highlighting Existing Text
      • Copilot Sidecar
      • Temporary Chat
      • Practical ways to use Copilot

      Introduction to Microsoft Word Exam

      Unit 5 - Intermediate Microsoft Word Training

      Lesson 1: Advanced Formatting - Quizzes: 1, Assignments: 3

      • Shading and Borders
      • Setting Line and Paragraph Spacing
      • Changing Styles
      • Paragraph Marks and Other Formatting Symbols
      • Character Space Options
      • Changing the Default Font
      • Custom Design Elements
      • Editing PDF Documents in Microsoft Word

      Lesson 2: Working with Tables - Quizzes: 1, Assignments: 3

      • Inserting a Table
      • Converting Tables to Text
      • Sorting Table Data
      • Setting Cell Margins
      • Modifying Table Dimensions
      • Merging and Splitting Cells
      • Applying Formulas to a Table
      • Table Styles
      • Manipulating Rows, Columns, and Cells

      Lesson 3: Working with Images - Quizzes: 1, Assignments: 3

      • Inserting Images
      • Placing and Sizing Images
      • Wrapping Text around an Image
      • Adjusting Images
      • Borders and Effects
      • Using Live Layout and Alignment Guides

      Lesson 4: Page Layout - Quizzes: 1, Assignments: 2

      • Orientation and Paper Size
      • Working with Columns
      • Page and Section Breaks
      • Adding Titles to Sections
      • Hyphenation
      • Line Numbers

      Lesson 5: Working with Illustrations - Quizzes: 1, Assignments: 5

      • Adding and Editing Charts
      • Inserting Images
      • Using Shapes
      • Working with Icons
      • 3D Models
      • Working with SmartArt
      • Using Building Blocks

      Lesson 6: Viewing Your Documents - Quizzes: 1, Assignments: 2

      • Document Views
      • Using the Navigation Pane
      • Multiple Windows
      • Object Zoom Feature

      Intermediate Microsoft Word Exam

      Unit 6 - Advanced Microsoft Word Training

      Lesson 1: Working with Long Documents - Quizzes: 1, Assignments: 4

      • Adding a Table of Contents
      • Updating the Table of Contents
      • Deleting the Table of Contents
      • Cross References
      • Footnotes and Endnotes
      • Inserting Citations and a Bibliography
      • Adding an Index
      • Inserting a Table of Figures
      • Inserting and Updating a Table of Authorities
      • Using Bookmarks
      • Go To Feature

      Lesson 2: Reviewing and Collaborating on Documents - Quizzes: 1, Assignments: 4

      • Adding Comments
      • Tracking Changes
      • Viewing Changes
      • Accepting and Rejecting Changes
      • Sharing

      Lesson 3: Comparing and Combining Documents - Quizzes: 1, Assignments: 2

      • Comparing Documents
      • Combining Documents

      Lesson 4: Forms - Quizzes: 1, Assignments: 6

      • Showing the Developer Tab

      Lesson 5: Managing Mailings - Quizzes: 1, Assignments: 2

      • Creating Envelopes and Labels
      • Using Mail Merge

      Lesson 6: Protecting Documents - Quizzes: 1, Assignments: 2

      • Marking Documents Final
      • Password Protect Word Documents
      • Removing Metadata from Files
      • Restrict Formatting and Editing
      • Adding Watermarks

      Lesson 7: Macros - Quizzes: 0, Assignments: 1

      • Using Macros

      Advanced Microsoft Word Exam, Final Microsoft Word Exam

      Unit 7 - Introduction to Microsoft PowerPoint Training

      Lesson 1: Microsoft Office Basics - Quizzes: 0, Assignments: 0

      • Logging in to Microsoft 365
      • Installing Applications
      • Creating New Files and AutoSaving
      • Protected View
      • File Sharing
      • File Collaboration
      • Version History
      • Getting Updates
      • Mac Versions

      Lesson 2: Creating a Presentation - Quizzes: 1, Assignments: 1

      • Starting Microsoft PowerPoint
      • Creating a Presentation
      • Saving a Presentation
      • The Status Bar
      • Closing a Presentation

      Lesson 3: The Ribbon - Quizzes: 1, Assignments: 0

      • Tabs
      • Groups and Commands
      • Microsoft Search Box
      • Customizing the Ribbon

      Lesson 4: The Quick Access Toolbar - Quizzes: 1, Assignments: 1

      • Getting Started
      • Adding Common Commands
      • Adding More Commands with the Customize Dialog Box
      • Adding Ribbon Commands or Groups

      Lesson 5: The Backstage View (The File Menu) - Quizzes: 1, Assignments: 2

      • Introduction to the Backstage View
      • Opening a Presentation
      • New Presentations and Presentation Templates
      • Adding Your Name to Microsoft PowerPoint

      Lesson 6: Formatting Presentations - Quizzes: 1, Assignments: 1

      • Selecting a Slide Layout
      • Adding and Editing Text
      • Adding Text from a Text File or Word Outline
      • Formatting Text
      • Text Effects and WordArt
      • Bulleted and Numbered Lists
      • Columns
      • Adding Slides to a Presentation
      • Arranging Slides

      Lesson 7: Working with Images - Quizzes: 1, Assignments: 1

      • Adding Images to a Slide
      • Removing an Image Background
      • Picture Format Tools Tab
      • Grouping and Ungrouping Images
      • Arranging Images
      • Adding Shapes
      • Working with Icons
      • 3D Models
      • Using Digital Ink

      Lesson 8: Working with Tables and Charts - Quizzes: 1, Assignments: 2

      • Inserting a Table
      • Formatting Tables
      • Importing Tables from External Sources
      • Inserting a Chart
      • Formatting a Chart
      • Importing Charts from External Sources

      Lesson 9: Preparing and Presenting - Quizzes: 1, Assignments: 2

      • Checking Spelling
      • Accessing Different Views of a Presentation
      • Running the Slide Show
      • Organizing a Presentation in Sections
      • Adding Transitions to Slides
      • Adding Speaker Notes
      • Printing a Presentation

      Lesson 10: Using Copilot in Microsoft PowerPoint - Quizzes: 1, Assignments: 1

      • Copilot in Microsoft 365 PowerPoint
      • Creating a New Presentation
      • Creating New Slides
      • Summarizing Large Amounts of Content
      • Branding a Deck

      Introduction to Microsoft PowerPoint Exam

      Unit 8 - Advanced Microsoft PowerPoint Training

      Lesson 1: Customizing Presentations - Quizzes: 1, Assignments: 1

      • Applying a Theme
      • Formatting Backgrounds
      • Headers and Footers
      • Adding a Background Image

      Lesson 2: Presentation Masters - Quizzes: 1, Assignments: 1

      • Working with the Slide Master
      • Slide Layouts
      • Formatting Slide Masters and Layouts
      • Adding a Watermark to Your Presentation
      • Adding Slide Numbers Using the Slide Master
      • Inserting a New Slide Master
      • Removing Unused Slide Masters and Layouts
      • Modifying the Notes Master
      • Modifying the Handout Master

      Lesson 3: Working with Special Effects - Quizzes: 1, Assignments: 1

      • Animating Bullets
      • Working with the Animation Painter
      • Motion Paths
      • Animating a Chart
      • Slide Transitions

      Lesson 4: Using SmartArt - Quizzes: 1, Assignments: 1

      • Inserting SmartArt Graphics
      • Modifying SmartArt Graphics
      • Resizing/Repositioning a SmartArt Object
      • Inserting Text into a SmartArt Object
      • Adding Shapes to a SmartArt Object
      • Ungrouping SmartArt Objects

      Lesson 5: Multimedia - Quizzes: 1, Assignments: 2

      • Creating a Photo Album
      • Editing a Photo Album
      • Inserting Sounds and Video
      • Editing Media Clips

      Lesson 6: Setting up the Slide Show - Quizzes: 1, Assignments: 2

      • Setting up a Custom Slide Show
      • Creating a Hyperlink
      • Adding an Action Button
      • Zoom
      • Using Rehearse Timings
      • Navigating within a Slide Show
      • Annotating a Presentation
      • Recording a Slide Show

      Lesson 7: Outlines and Slides - Quizzes: 1, Assignments: 1

      • Exporting Handouts to Word
      • Exporting an Outline to Word
      • Saving a Presentation as an Outline
      • Saving a Slide as a Graphic

      Lesson 8: Managing Multiple Presentations - Quizzes: 1, Assignments: 1

      • Merging Multiple Presentations
      • Viewing Multiple Presentations
      • Tracking Changes in PowerPoint
      • Adding Comments

      Lesson 9: Finalizing Presentations - Quizzes: 1, Assignments: 0

      • Inspecting a Presentation
      • Encrypting a Presentation
      • Embedding the Fonts in a Presentation
      • Saving a Presentation in PDF Format
      • Compressing Pictures
      • Marking a Presentation as Final

      Advanced Microsoft PowerPoint Exam, Final Microsoft PowerPoint Exam

      Unit 9 - Introduction to Microsoft Outlook 365 Training

      Lesson 1: The Outlook Interface - Quizzes: 1, Assignments: 0

      • Overview of the Outlook Interface
      • The Ribbon
      • Review of Differences Between Classic and New Layouts

      Lesson 2: Working with Messages - Quizzes: 1, Assignments: 1

      • Compose a Message
      • Add an Attachment
      • Add Polling Options
      • Check Spelling and Grammar
      • Format Text
      • Insert a Hyperlink or Image in a Message
      • Send a Message

      Lesson 3: Working with the Calendar - Quizzes: 1, Assignments: 2

      • Change Your Calendar View
      • Set Up Availability Status
      • Print Your Schedule
      • Share Your Calendar
      • Schedule a Meeting
      • Make Updates to Meetings
      • Cancel a Meeting
      • View Others’ Calendars
      • Delete a Calendar
      • Work with Calendar Items
      • Create and Add Calendars

      Lesson 4: Organizing Contacts - Quizzes: 1, Assignments: 1

      • Add, Delete, and Import/Export a Contact
      • Update a Contact
      • Locate a Contact
      • Sort Contacts
      • Work with Contact Lists
      • Manage Multiple Address Books

      Lesson 5: Working with Groups - Quizzes: 1, Assignments: 1

      • Search for a Group
      • Create a Group
      • Add or Remove Members
      • Send Email to a Group

      Lesson 6: Using Copilot in Microsoft Outlook

      • Copilot in Microsoft 365 Outlook
      • Emails
      • Meetings

      Introduction to Microsoft Outlook 365 Exam

      Unit 10 - Advanced Microsoft Outlook 365 Training

      Lesson 1: Performing Popular Tasks - Quizzes: 1, Assignments: 3

      • Open Email Messages
      • Reply to and Forward Email Messages
      • Preview and Save an Attachment
      • Print a Message
      • Delete a Message
      • Save a Message in an Alternate Format
      • Customize the Navigation Pane

      Lesson 2: Working with Tasks and Notes - Quizzes: 1, Assignments: 1

      • Create a Task
      • Print a Task
      • Add Steps to a Task
      • Update a Task
      • Search for Tasks
      • Change Your Task View

      Lesson 3: Using Signature and Themes - Quizzes: 1, Assignments: 1

      • Create a Signature
      • Automatically Add a Signature to Messages
      • Modify a Signature
      • Format Outgoing Messages

      Lesson 4: Managing Your Inbox - Quizzes: 1, Assignments: 2

      • Search for Messages
      • Sort Messages
      • Add New Local Folders
      • Move Messages between Folders
      • Group Your Mailbox Items
      • Filter Messages
      • Organize Messages
      • Create and Manage Rules
      • Manage Your Junk Email
      • Archive Your Messages
      • Create a Quick Step
      • Create Auto-Replies

      Lesson 5: Working with Multiple Email Accounts - Quizzes: 1, Assignments: 1

      • Setting Up Multiple Accounts in Outlook
      • Send Emails from Different Accounts
      • POP vs. IMAP Email Protocols

      Advanced Microsoft Outlook 365 Exam, Microsoft Outlook 365 Final Exam

    Part 11 - Introduction to Microsoft Access 365 Training

    Lesson 1: Databases and Access Terms - Quizzes: 0, Assignments: 2

    • Database Defined
    • Databases vs. Spreadsheets
    • Access vs. Excel
    • Relational Database Defined
    • Relational Database Management System (RDBMS) Defined
    • Access is an RDBMS
    • Creating a Relationship
    • Benefits and Limitations of Access

    Lesson 2: Quick Overview Access Interface - Quizzes: 1, Assignments: 1

    • Access Ribbon
    • Quick Access Toolbar
    • Object Navigation Pane
    • Access Work Surface
    • Object Overview
    • Process Overview
    • Create a Database Using a Wizard

    Lesson 3: Fundamentals - Quizzes: 1, Assignments: 3

    • Questions to Ask Before You Start
    • Approaches to Database Design
    • Gather Information
    • A Few Words about Naming Conventions
    • Normalization
    • Table Relationships

    Lesson 4: Tables and Their Views - Quizzes: 1, Assignments: 1

    • Definition and Purpose
    • Datasheet View
    • Import a Table of Data
    • Design View

    Lesson 5: Tables - Quizzes: 1, Assignments: 3

    • Creating an Access Database
    • Data Types
    • Create a Table in Design View
    • Link a Table of Data

    Lesson 6: Queries - Quizzes: 1, Assignments: 1

    • Queries
    • Select Queries
    • Select Queries with Criteria
    • Logical Operators
    • Group and Total with Queries

    Lesson 7: Forms - Quizzes: 1, Assignments: 2

    • Forms
    • Alter a Form
    • Form Record Navigation
    • Layout View and Design View
    • One-Click Forms
    • Form Wizard

    Lesson 8: Reports - Quizzes: 1, Assignments: 1

    • Reports
    • Report Wizard

    Introduction to Microsoft Access 365 Exam

    Part 12 - Advanced Microsoft Access 365 Training

    Lesson 1: Relationships - Quizzes: 1, Assignments: 1

    • Reviewing Data Normalization and Table Relationships
    • Relationships
    • Referential Integrity
    • A Few Words about Naming Conventions

    Lesson 2: Advanced Queries - Quizzes: 1, Assignments: 2

    • Query Design View
    • Review of Select Queries
    • Review of Select Queries with Criteria
    • Logical Operators
    • Parameter Queries
    • Action Queries

    Lesson 3: Table Functions - Quizzes: 1, Assignments: 2

    • Importing Data
    • Linking Tables from External Sources
    • Import Tables from Other Databases
    • Tables from Templates and Application Parts
    • Exporting Data

    Lesson 4: Advanced Forms - Quizzes: 1, Assignments: 1

    • Design View
    • Formatting
    • Tab Order and Properties
    • Create Forms with Application Parts
    • Creating a Subform
    • Alter a Form

    Lesson 5: Advanced Reports - Quizzes: 1, Assignments: 1

    • Design View
    • Report Sections
    • Arranging Fields on a Report
    • Resizing the Detail Section
    • Grouping and Sorting
    • Setting Properties on a Report
    • Special Report Fields
    • Controls
    • SubReports
    • Application Parts
    • Deleting a Report
    • Formatting a Report

    Lesson 6: Macros - Quizzes: 1, Assignments: 1

    • Macro Basics
    • Running a Macro

    Lesson 7: Completing the Desktop Application - Quizzes: 1, Assignments: 1

    • The Navigation Form
    • Running Macros from a Navigation Form
    • Setting the Navigation Form as the Default Form
    • Splitting the Database
    • Distributing the Front-End Database
    • Database Maintenance

    Advanced Microsoft Access 365 Exam, Final Microsoft Excel Exam, Final Microsoft PowerPoint Exam, Final Microsoft Word Exam, Microsoft Access 365 Final Exam, Microsoft Outlook 365 Final Exam

  2. Part 2 - Certified Administrative Professional
    1. Organizational Communication (Part 1)
      1. Understanding the Workplace Team
      2. Interacting with Stakeholders
      3. Communication Essentials
    2. Organizational Communication (Part 2)
      1. Networking
      2. Motivation, Leadership, And Change Management
      3. Public Speaking
      4. International Business
      5. Organizational Structures And Systems
      6. Legal And Ethical Issues
    3. Business Writing and Document Production
      1. Business Writing
      2. Software Applications
      3. Managing Hardware and Software
    4. Technology and Information Distribution
      1. Information Systems
      2. Telephone and Electronic Communication
      3. Copyright Laws and Intellectual Property
      4. Research and Analysis
      5. Managing Remote Meetings
      6. Information Distribution and Storage
    5. Office and Records Management
      1. Filing Standards
      2. File Security
      3. Creating Workspaces
      4. Managing Materials and Supplies
    6. Event and Project Management
      1. Event Scheduling And Management
      2. Travel Planning
      3. Meeting Coordination
      4. Project Management And Negotiations
    7. Human Resources
      1. Human Resources Terminology and Processes
      2. Employee Handbooks, Training, and Standard Operating Procedures
      3. Employee Records and Evaluation
      4. Staffing And Onboarding
      5. Human Resource Law and Harassment
    8. Financial Functions
      1. Budgeting Basics
      2. Introduction to Financial Statements
      3. Introduction to Banking and Statement Reconciliation
    9. Workplace Behaviors and Activities (Part 1)
      1. Goal Setting and Creativity
      2. Problem Solving and Decision Making
      3. Time Management and Stress Management
    10. Workplace Behaviors and Activities (Part 2)
      1. Planning And Controlling
      2. Multitasking
      3. Generational Distinctions
      4. Diversity and Inclusion
    11. Workplace Behaviors and Activities (Part 3)
      1. Supply chain management
      2. Purchasing and logistics
      3. Scheduling
      4. Customer service
    12. Becoming an Administrative Assistant and Advancing Your Career
      1. Duties and Traits
      2. Position Options
      3. Seeking Employment
      4. Career Planning
  3. Part 3 - Management Training
    1. Introduction to Management Principles
    2. The Role and Responsibilities of a Manager
    3. Building a Personal Development Plan, Your Leadership Blueprint
    4. Corporate Culture in the Management Context
    5. Ethics and Social Responsibility
    6. Diversity, Equity, and Inclusion (DEIB)
    7. Strategic vs. Operational Thinking
    8. Goal Setting and Prioritization
    9. Planning and Execution
    10. Decision-Making
    11. Time and Project Management Fundamentals
    12. Managing Human Talent
    13. Managing Change
    14. Customer Relationship Management
    15. Leadership
    16. Motivating Employees
    17. Team Building and Collaboration
    18. Managing Communication and Conflict
    19. Controlling
    20. Career Planning

Requirements

Prerequisites

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO

Instructor

FAQs

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO