Microsoft Word 2019 And Excel 2019 Bundle » ITU Online IT Training
+1 855.488.5327 customerservice@ituonline.com Mon – Fri: 9:00am – 5:00pm ET
Login To My Training Cart
Ready to start learning? Individual Plans →Team Plans →
[ Course ]

Microsoft Word 2019 and Excel 2019 Bundle


10 Hrs 2 Min97 Videos124 QuestionsCertificate of CompletionClosed Captions

Microsoft Word 2019 and Excel 2019 Bundle



Microsoft Excel Course Content

Download Outline

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

Download Outline

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

This course is included in all of our team and individual training plans. Choose the option that works best for you.

[ Team Training ]

Enroll My Team.

Give your entire team access to this course and our full training library. Includes team dashboards, progress tracking, and group management.

Get Team Pricing

[ Individual Plans ]

Choose a Plan.

Get unlimited access to this course and our entire library with a monthly, quarterly, annual, or lifetime plan.

View Individual Plans

Ready to start learning? Individual Plans →Team Plans →