Online Class: Office 2019 — Word, Excel, PowerPoint, and Outlook

Learn the most popular Office 2019/Office 365 applications for one low bundled price, includes Word 2019, Excel 2019, PowerPoint 2019, and Outlook 2019.

$120.00
no certificate
- OR -
$145.00
with CEU Certificate*
Start Right Now!
$145.00 (with CEU Certificate)
Taking multiple courses? Save with our platinum program.
 
4 Course Bundle - One Low Price
Only $145.00* - Save $335.00
(normally $480.00)
* Includes Online CEU Certificates for Each Course
 
  • 60
    Lessons
  • 100
    Exams &
    Assignments
  • 31
    Hours
    average time
  • 3.1
    CEUs
 
 

Course Description

This course bundle includes the following courses: You may take these courses in any order you like. If you purchase the CEU Certificate option, you'll receive a separate CEU Certificate for each course you successfully complete.

Microsoft Word 2019:
 
Word 2019 is the latest version of the most popular word processing application on the market developed by Microsoft Corporation. You can't escape the number of businesses and individuals that use Microsoft Word on a daily basis. Regardless of your own word processing program preference, you're bound to do business or communicate with someone who uses MS Word exclusively. For this reason, you need to know what it can do and how to do it. This course will show you the many ways that you can integrate Microsoft Word 2019 into your everyday life.
 

In this course, you're going to learn how to...

 

  • Navigate the new MS Word interface
  • Create new documents and open existing documents
  • Use templates
  • Edit and format text, paragraphs, and whole documents
  • Use Microsoft Word for desktop publishing
  • Create brochures, flyers, and even business cards
  • Insert headers, footers, images, graphics, and video
  • Use mail merge
  • Create a table of contents
  • Compare, merge and protect documents
  • Proof, print, collaborate, and track changes in Word documents
  • Create even more impressive tables than ever before using new formatting tools
  • And much more! 

We'll start with an introduction to the core features of MS Word, but then quickly move on to the way Microsoft Word handles formatting and styles so that you can customize the look and feel of any Word document. We then move to more complex features such as creating tables, desktop publishing and mail merge.

We'll also review how you can use MS Word to create and manage long technical documents that may require headers and footers. We also go over unique MS Word methods for proofing and editing. For example, should you need to work with a third-party editor, we will show you ways to add comments and track changes as you pass documents from person-to-person.

Finally, we cover more complex topics such as recording macros and working with Visual Basic for Applications (VBA). Our course takes you from the basic introduction to the more complex tools of Word so that you can master the application whether for business or personal use.
 
Excel 2019:

Excel 2019 is the latest iteration of the popular spreadsheet software developed by Microsoft. Excel allows users to create rich, stylized spreadsheets used for storing, organizing, sorting, calculating, and charting data. With Excel, you can create visually appealing content that represents your data. Before you start using Excel though, you should first learn what all the features Excel offers are and how to use them, so that your spreadsheets are built correctly the first time.

In this course, you're going to learn how to...
  • Create spreadsheets
  • Format cells, rows, columns, and entire worksheets so they fit and match your data
  • Enter data into a spreadsheet
  • Use formulas and functions for math, accounting, and totaling
  • Create formulas and functions
  • Calculate data
  • Create charts and diagrams for your data
  • Create data lists and forms
  • Create and use pivot tables and pivot charts
  • Work with Excel templates
  • Share and protect your worksheets and workbooks
  • Use What-If Analysis to determine possible outcomes
  • And much more!
 
The first few lessons explain how to use Excel core features such as formatting rules and techniques. We then move on to formulas. Formulas are the foundation for most basic and complex spreadsheets that store data. Formulas allow you to automatically calculate results based on any number of variables including information stored in your rows, columns and cells. Once we learn how to use formulas, we'll move on to scenarios, pivot tables and what-if charts. These advanced tools allow you to track your reports and create projections for your business.

Nowadays, your Excel spreadsheet should include at least one chart, so we have step-by-step tutorials on charting, graphics, and using images. All these added components help make spreadsheets more visually appealing. We also review ways to use common functions as well as sort and filter data, so you can view large data sets in chronological, alphabetical or numerical order.

The final lesson introduces you to Visual Basic for Applications (VBA).  VBA is a powerful language used to make macros. We will show you how to create simple recorded macros as well as how to edit macros for more complex applications. 
 
PowerPoint 2019:
Microsoft PowerPoint is the de facto presentation software for people who want to create slideshows. PowerPoint 2019 is used in many different scenarios, including business presentations, sales presentations, academic lectures, student projects, and even for families documenting vacations and special events. If you have an idea you want to present in front of an audience, PowerPoint is your go-to solution. This course will teach you how to use all the major features of Microsoft PowerPoint so that you can create dynamic and engaging presentations.
 
With this course, you'll learn how to...
 
  • Navigate the PowerPoint interface
  • Create new presentations from scratch – or by using beautiful templates
  • Add text, pictures, sounds, movies, and charts to your presentations
  • Format the objects that you add to your presentations
  • Design slides using themes, colors, and special effects
  • Animate objects on slides to bring them to life.
  • Add special effects to slide transitions to spice up your presentations
  • Work with Master Slides to make editing your presentation easy
  • Set up slide shows and rehearse timings for your slides
  • Collaborate easier than before using PowerPoint
  • And much more! 

The first part of the course focuses on working with slides and the ways that users can create and customize layouts. Objects make up the content seen in a slideshow presentation, so we cover step-by-step how to add and edit text, images, shapes, diagrams, graphs and charts. These objects are common in PowerPoint presentations, so they will make up a majority of your slides.

We'll then show you how to add these objects and customize them using themes and colors. Charts and tables display information to viewers, and we will show you how to set up these objects to accurately convey numbers and data to potentials customers.

We also explore themes, so that you can stylize your layouts and objects. Themes contain predesigned color schemes, but you can also create your own themes that match your preferences. In additional, we'll learn about styles, transitions and animations. For example, we'll cover the ways that you can animate your presentations to make them more appealing to your audience.

Finally, we will review how to print and share slides. Microsoft Office includes OneDrive for file sharing and collaboration. This course takes you from building attractive, compelling presentations to sharing and collaborating with other users. You can then successfully build slides tailored to your target audience.

Outlook 2019:
Outlook 2019 is the latest version of Microsoft's powerful email client that lets you not only manage email messages, but schedule meetings and tasks, collaborate with other coworkers, and work with a calendar of scheduled events that send alerts for upcoming deadlines. What makes Outlook different from many other email clients is that it is an entire collaboration and scheduling tool that benefits fortune 500 corporations, small businesses, busy professionals, and even students and home users. For large corporations, Outlook is the email client standard that integrates seamlessly with Microsoft environments and Exchange server.
 
In this course, you'll learn how to...
  • Navigate Outlook
  • Create and format emails
  • Organize emails into folders
  • Create folders
  • Use the Calendar module
  • Add appointments, meetings, and events to the calendar
  • Use the Task module to manage your to-do list
  • Add contacts to address books
  • Create address books
  • Create notes
  • Add images and charts to emails
  • And much more 

This course focuses on teaching new users how to use all the features of Outlook 2019. First, we'll explore the basic ways Outlook can be used to create emails and format them according to certain standards. With Outlook, rich text formatting can be used as well as HTML. We cover creating emails with integrated images, graphs and stylized text so that your emails stand out from the vast sea of other plain text messages.

Next, we will work through all the amazing collaboration features of Outlook. We cover important Outlook components such as the calendar, scheduling tasks and sharing them with other coworkers. With Outlook, you can also automate incoming and outgoing emails using rules, which we cover step-by-step to help you manage and organize your inbox.

 
  • Completely Online
  • Self-Paced
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Additional Course Information

Online CEU Certificate
  • Document Your Lifelong Learning Achievements
  • Earn an Official Certificate Documenting Course Hours and CEUs
  • Verify Your Certificate with a Unique Serial Number Online
  • View and Share Your Certificate Online or Download/Print as PDF
  • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Document Your CEUs on Your Resume
 
Course Title: Office 2019: Word, Excel, PowerPoint, and Outlook
Course Number: 9770514
Languages: English - United States, Canada and other English speaking countries
Availability: This course is online and available in all 50 states including: California, Florida, Georgia, Illinois, New York, Pennsylvania, Ohio, and Texas.
Last Updated: February 2024
Course Type: Self-Paced, Online Class
CEU Value: 3.1 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Course Fee: $145.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$120
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$145
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
ALL COURSES
Certificates & CEUs
$189
per year
 
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 600+
 

Student Testimonials

  • "It was very educational, thorough, and was taught in a concise manner." -- Christine S.
  • "I thought the course was very informative and detailed, but not so much that a person not familiar with PowerPoint would be totally lost." -- Lawerence R.
  • "I thought I knew a lot about Microsoft because I use it all of the time. I really thought this course would be a waste of time and something I needed to drudge through just to get the certificate, but it was so helpful. I learned so many things. I guess you don't know what you don't know. I really appreciate the effort that went into creating this course. I really can't say thank you enough. Thank you!" -- Heather K.
  • "Course was great! Thank you." -- Deimante V.
  • "This course was very informative and I learned so much and I am lot more comfortable using Microsoft Excel." -- Rachel S.
  • "The course was excellent. Tutorials were very helpful." -- Evelyn E.
  • "This course was very helpful in refreshing my Excel skills and learning the newest version of Excel." -- Audra A.
  • "Very helpful information! I especially appreciated the Mail Merge lesson." -- Anastasia V.
  • "I thought I knew a lot about Excel until taking this course. I learned so many fun and new things. I can't wait to get creating!" -- Erica J.
  • "I felt this course was very helpful for me. Not knowing anything about excel before starting the course, I feel I have a much better understanding of its functions and capabilities now. I also feel a much greater confidence in applying knowledge of this program within my skills and experience." -- Tess H.
View More Testimonials...
 

Related Courses