Shop our Labor Day sale and take 40% off all regularly priced courses and bundles sitewide.  Just add to cart to see your discounts.

Lock In At Our Lowest Price Ever: $14.99/month for 2,500+ hours of IT training.
Limited time only. Enroll now, cancel anytime!

Microsoft Word 2019 and Excel 2019 Bundle

Included In This Course

Included In This Course

Total Hours
10  Training Hours
Microsoft Word 2019 and Excel 2019 Bundle
97 On-demand Videos
Closed Caption

Closed Captions

Course Topics
3  Topics
Prep Questions
124 Prep Questions
Microsoft Word 2019 and Excel 2019 Bundle

Certificate of Completion

Course Description

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft Excel 2019 Course Content

Module 1: Beginner

  •    1.0 Intro

  •    1.1 The Ribbon

  •    1.2 Saving Files

  •    1.3 Entering and Formatting Data

  •    1.4 Printing from Excel & Using Page Layout View

  •    1.5 Formulas Explained

  •    1.6 Working with Formulas and Absolute References

  •    1.7 Specifying and Using Named Range

  •    1.8 Correct a Formula Error

  •    1.9 What is a Function

  •    1.10 Insert Function & Formula Builder

  •    1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE

  •    1.12 Create and Customize Charts

Module 2: Intermediate

  •    2.0 Recap

  •    2.1 Navigating and editing in two or more worksheets

  •    2.2 View options - Split screen, view multiple windows

  •    2.3 Moving or copying worksheets to another workbook

  •    2.4 Create a link between two worksheets and workbooks

  •    2.5 Creating summary worksheets

  •    2.6 Freezing Cells

  •    2.7 Add a hyperlink to another document

  •    2.8 Filters

  •    2.9 Grouping and ungrouping data

  •    2.10 Creating and customizing all different kinds of charts

  •    2.11 Adding graphics and using page layout to create visually appealing pages

  •    2.12 Using Sparkline formatting

  •    2.13 Converting tabular data to an Excel table

  •    2.14 Using Structured References

  •    2.15 Applying Data Validation to cells

  •    2.16 Comments - Add, review, edit

  •    2.17 Locating errors

Module 3: Advanced

  •    3.1 Recap

  •    3.2 Conditional (IF) functions

  •    3.3 Nested condition formulas

  •    3.4 Date and Time functions

  •    3.5 Logical functions

  •    3.6 Informational functions

  •    3.7 VLOOKUP & HLOOKUP

  •    3.8 Custom drop down lists

  •    3.9 Create outline of data

  •    3.10 Convert text to columns

  •    3.11 Protecting the integrity of the data

  •    3.12 What is it, how we use it and how to create a new rule

  •    3.13 Clear conditional formatting & Themes

  •    3.14 What is a Pivot Table and why do we want one

  •    3.15 Create and modify data in a Pivot Table

  •    3.16 Formatting and deleting a Pivot Table

  •    3.17 Create and modify Pivot Charts

  •    3.18 Customize Pivot Charts

  •    3.19 Pivot Charts and Data Analysis

  •    3.20 What is it and what do we use it for

  •    3.21 Scenarios

  •    3.22 Goal Seek

  •    3.23 Running preinstalled Macros

  •    3.24 Recording and assigning a new Macro

  •    3.25 Save a Workbook to be Macro enabled

  •    3.26 Create a simple Macro with Visual Basics for Applications (VBA)

  •    3.27 Outro

Microsoft Word 2019 Course Content

Module 1: Beginner

  •    1.01 Instructor Intro

  •    1.02 Course Intro

  •    1.1 Explaining the Ribbon

  •    1.2 Creating a Document

  •    1.3 Saving Files

  •    1.4 Page Views

  •    1.5 Formatting Text

  •    1.6 Ruler, Margins and Tab Stops

  •    1.7 Moving and Duplicating Text

  •    1.8 Line Spacing and Paragraph Formatting

  •    1.9 Basic Editing

  •    1.10 Insert a Basic Table and Graphics

  •    1.11 Working with Styles

Module 2: Intermediate

  •    2.1 Intermediate Intro

  •    2.2 Collaboration & Co-Authorship

  •    2.3 Tracking and Viewing Changes

  •    2.4 Commenting

  •    2.5 Templates & Layouts

  •    2.6 Layout Functions on the Ribbon

  •    2.7 Customize, Format and Convert Tables and Use as a Page Layout

  •    2.8 Insert and Edit a Cover Page

  •    2.9 Insert and Customize Headers and Footers

  •    2.10 Insert and Customize Endnotes and Footnotes

  •    2.11 Creating Sections in a Long Document

  •    2.12 Using Sections to Format a Document

  •    2.13 Deleting a Section

  •    2.14 Reviewing, Inserting and Updating TOC

  •    2.15 Creating a Data Source and Linking a Mailing List

  •    2.16 Print Settings for Mail Merge

Module 3: Advanced

  •    3.1 Adding the Developer Tab

  •    3.2 Functionality Among Microsoft Office Products

  •    3.3 Using Formulas in Word

  •    3.4 Citing Sources in Word

  •    3.5 Reviewing and Merging Versions of the Same Document

  •    3.6 Creating a Master Document

  •    3.7 Creating Sub Documents and Editing Master and Sub Docs

  •    3.8 Controlling Editable Content

  •    3.9 Form Creation Using the Developer Tab

  •    3.10 Macros

Add a review
Microsoft Word 2019 and Excel 2019 Bundle Microsoft Word 2019 and Excel 2019 Bundle
* Rating is required
Your review
* Review is required
* Name is required
Based on 49 reviews
5 star
4 star
3 star
2 star
1 star
1-5 of 49 reviews
  1. I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.

  2. The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.

  3. The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!

  4. This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.

Your Training Instructor

Lindsay Hurley

Lindsay Hurley


Microsoft Word 2019 and Excel 2019 Bundle



Subscribe To All-Access

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft Word 2019 and Excel 2019 Bundle

Word 2019 Training
Microsoft Word 2019 and Excel 2019 Bundle
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses


Gain expertise in Windows Server with our Microsoft 70-740 training. Learn to install, configure, and manage this powerful operating system.

With our Microsoft 70-740 course, take your first step towards becoming a Microsoft Certified Solutions Associate (MCSA) for Windows Server 2016 with the Installation, Storage and Compute course. This comprehensive program covers everything from manually installing to imaging-based installation of various versions in great detail. With 75 videos spread across 22 hours of instruction, you’ll acquire an unrivalled precept on setting up servers for optimal execution.


Discover the power of Adobe Flash / Animate and become a master animator. Get the skills you need to succeed with ITU Online. Enroll now!

In this course you will learn how to create animation projects such as short films, commercials and even big projects such as television shows. Flash is capable of both frame-by-frame animation, as well as other, more complex puppeting animation.


Master the art of video editing with Adobe Premiere Pro online training from ITU Online. Get started today and take your skills to the next level!

This course is designed to get you up and running with Adobe Premiere Pro. Whether you are new to Premiere Pro or just brushing up because you haven’t used it for a while, this course should help.