Microsoft Word 2019 and Excel 2019 Bundle
Included In This Course
10 Hrs 2 Min
97 On-demand Videos
Closed Captions
3 Topics
124 Prep Questions
Certificate of Completion
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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
ITU Online
Subscribe To All-Access
Lock In $16.99 / Month Forever
Access this course and over 2,700 hours of focused IT training. Start your first month for only $1.00. Then lock in only $16.99 / month for life.
- Get Every Course
- Free Updates / New Content Added
- 2,700+ Hours of Training
- Price Lock Guarantee
- Games / Flashcards
- 21,000+ Practice Questions
$49.99 $16.99 Monthly
OR
$49.00
