After completing this course, you should be able to:
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
Describe ways to create professional publications with Publisher
Price: $995.00


    Quantity:
    If you're looking for a way to get up to speed quickly on the newest version of Microsoft Office, this course offers step-by-step instructions to make it easy. Office 2019 has new features and tools to master, and whether you're upgrading from an earlier version or encountering the Office applications for the first time, you'll appreciate this simplified approach.

    This course covers:

    Microsoft Word 2019
    Microsoft Excel 2019
    Microsoft PowerPoint 2019
    Microsoft Outlook 2019
    Microsoft Access 2019
    Microsoft Publisher 2019
    Microsoft Office holds more than 90 percent of the market for Windows-based productivity suites. Our MS Office 2019 course makes this technology easy to understand, even for those who are new to computers.

    NOTE: This course does NOT include the MS Office programs themselves. Students will need to have Office 2019 already installed on their computers.
    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
    All required reference materials are provided with this program. 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
    • Microsoft Office 2007, 2010 or 2013 or a Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
    • Internet Browsers - Google Chrome is highly recommended
    • Cookies MUST be enabled
    • Pop-ups MUST be allowed (Pop-up Blocker disabled)
    • Adobe PDF Reader
    This class is an independent-study course. Students will have all the resources needed to successfully complete the course within the online material. A student helpdesk is available for technical support during the course enrollment.

    Product Type:
    Course
    Course Type:
    Professional Enrichment
    Level:
    Beginner
    Language:
    English
    Hours:
    135
    Duration:
    6 months
    Avg Completion:
    3 Months

      Get the support you need, when you need it

        • Our admissions advisors will help you identify career paths, accredited colleges, and funding solutions
        • Customer & Technical Support is available throughout your course experience via Live Chat, Phone, Email, and Text
        • Office hours are Monday through Friday, 8-5pm CT

      Stay on track to reach your completion goal

        • Scheduling and Time Management assistance tailored just for you
        • Active reminder notifications about important deadlines in your class
        • Join giveaway raffles for achieving course milestones

      Become Job-Ready: Career Training Programs ONLY

        • Take advantage of real-world experience outside of the classroom with an employer-based externship program
        • Work with a career counselor to schedule your certification exam (if applicable)
        • Complete an employer-ready resume with a career coach
        • Participate in live mock interviews and job guidance sessions

      Microsoft Office 365-Training Bundle Suite 2019 FAQs

      How do I request more information about a course?

      What is the difference between online courses and classroom courses?

      I'm not sure if I will be able to successfully take on online course, what should I do?

      Do I need a degree or high school diploma to take an online course?

      What do I need to take an online course?

      What format will my online course be in?

      Do I have to be local to take a course?

      Do you offer or accept any financial assistance options?

      What does the course duration mean?

      What does a Certification Voucher Included mean?

      When will I start my course?

      What type of support will I receive during my course?

      Who do I contact if I cannot access my course?

      When will I receive my course materials?

      Who do I contact if I need an extension?

      What do I receive when I complete my course?

      Will I receive any job search assistance or externship opportunity after I finish my course?