Microsoft Word 2019 And Excel 2019 Bundle - ITU Online

Microsoft Word 2019 and Excel 2019 Bundle

Included In This Course

Microsoft Word 2019 and Excel 2019 Bundle
10 Hrs 2 Min
Videos
97 On-demand Videos
Closed Captions

Closed Captions

Course Topics
3  Topics
Question & Answers
124 Prep Questions
Certificate of Completion

Certificate of Completion

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

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
Currently, we are not accepting new reviews
4.8
Based on 81 reviews
1-5 of 81 reviews
  1. SJ

    good

  2. AA
  3. K
  4. BO
  5. A

    Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

Your Training Instructor

Lindsay Hurley

Lindsay Hurley

Instructor

Word 2019 Training

Subscribe To All-Access
Lock In $16.99 / Month Forever

Gain access to this training and all our other courses with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.99 $16.99 Monthly

OR

$49.00