Get $1 credit for every $25 spent!

The Ultimate Beginner’s Guide to Microsoft Office

Ending In:
Add to Cart - $34.99
Add to Cart ($34.99)
$2,400
98% off
wishlist
Courses
12
Lessons
986
Enrolled
1,287

What's Included

Product Details

Access
Lifetime
Content
1.0 hours
Lessons
118

Introduction to Microsoft Excel 2019 Training

Get Familiar with the 2019 Interface of Microsoft Excel & Work on Basic Excel Projects

By Webucator | in Online Courses

In this Introduction to Microsoft Excel 2019 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets using Excel 2019 or Excel 365. Choose this Excel class if you are new to Microsoft Excel and are using Excel 2019 or Excel 365. Catch up with the newest version and eventually master its features.

9.8/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 118 lectures & 1 hour of content 24/7
  • Create basic worksheets using Microsoft Excel 2019
  • Perform calculations in an Excel worksheet
  • Modify the appearance of data within a worksheet
  • Manage Excel workbooks
  • Learn how to use handy features new in 2019
Note: Software NOT included.

"The Excel training was great! Learned a lot of new tips and tricks and gained a better understanding of the functions available." – Ariel Hobza, Agile Group USA

"The instructor was very knowledgeable and helpful. I learned quite a bit even though I have used Excel for years." – Kellye Waller, Wurth Louis and Company

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Familiarity w/ using a personal computer, mouse & keyboard
  • Comfortable in the Windows environment
  • Ability to launch & close programs; navigate to information stored on the computer; and manage files and folders

Course Outline

  • Your First Program
  • Setup
    • Setup for Your Class
  • Lesson 1 - Creating a Microsoft Excel Workbook
    • Activity 1 - Starting Microsoft Excel - Reading
    • Activity 2 - Creating a Workbook - Reading
    • Activity 3 - Saving a Workbook - Reading
    • Activity 4 - The Status Bar - Reading
    • Activity 5 - Adding and Deleting Worksheets - Reading
    • Activity 6 - Copying and Moving Worksheets - Reading
    • Activity 7 - Changing the Order of Worksheets - Reading
    • Activity 8 - Splitting the Worksheet Window - Reading
    • Activity 9 - Closing a Workbook - Reading
    • Activity 10 - Starting in Excel - Presentation - 1:55
    • Activity 11 - Creating a Microsoft Excel Workbook - Exercise
    • Activity 12 - Exercise Solution - Creating a Microsoft Excel Workbook - Presentation - 1:22
    • Activity 13 - Creating an Excel Worksheet Quiz - Quiz
  • Lesson 2 - The Ribbon
    • Activity 1 - Tabs - Reading
    • Activity 2 - Groups - Reading
    • Activity 3 - Commands - Reading
    • Activity 4 - Tabs, Groups, and Commands - Presentation - 1:57
    • Activity 5 - Exploring the Ribbon - Exercise
    • Activity 6 - Exploring the Ribbon Quiz - Quiz
  • Lesson 3 - The Backstage View (The File Menu)
    • Activity 1 - Introduction to the Backstage View - Reading
    • Activity 2 - Opening a Workbook - Reading
    • Activity 3 - Using Backstage to Open a Workbook - Presentation - 1:25
    • Activity 4 - Open a Workbook - Exercise
    • Activity 5 - Exercise Solution - Open a Workbook - Presentation - 1:26
    • Activity 6 - New Workbooks and Excel Templates - Reading
    • Activity 7 - Select, Open, and Save a Template Agenda - Exercise
    • Activity 8 - Exercise Solution - Select, Open, and Save a Template Agenda - Presentation - 1:41
    • Activity 9 - Printing Worksheets - Reading
    • Activity 10 - Printing a Worksheet - Presentation - 2:00
    • Activity 11 - Print a Worksheet - Exercise
    • Activity 12 - Adding Your Name to Microsoft Excel - Reading
    • Activity 13 - Adding a Theme to Microsoft Excel - Reading
    • Activity 14 - How to Add Your Name - Presentation - 1:27
    • Activity 15 - The Backstage View Quiz - Quiz
  • Lesson 4 - The Quick Access Toolbar
    • Activity 1 - The Quick Access Toolbar - Reading
    • Activity 2 - Adding Common Commands - Reading
    • Activity 3 - Adding Additional Commands with the Customize Dialog Box - Reading
    • Activity 4 - Adding Ribbon Commands or Groups - Reading
    • Activity 5 - Placement - Reading
    • Activity 6 - Navigating and Customizing the Quick Access Toolbar - Presentation - 3:29
    • Activity 7 - Customize the Quick Access Toolbar - Exercise
    • Activity 8 - Exercise Solution - Customize the Quick Access Toolbar - Presentation - 2:41
    • Activity 9 - Quick Access Toolbar Quiz - Quiz
  • Lesson 5 - Entering Data in Microsoft Excel Worksheets
    • Activity 1 - Worksheets - Reading
    • Activity 2 - Entering Text - Reading
    • Activity 3 - Adding and Deleting Cells - Reading
    • Activity 4 - Adding a Hyperlink - Reading
    • Activity 5 - Add WordArt to a Worksheet - Reading
    • Activity 6 - Using AutoComplete - Reading
    • Activity 7 - Review of Entering Text and Using AutoComplete - Presentation - 1:55
    • Activity 8 - Entering Text and Using AutoComplete - Exercise
    • Activity 9 - Exercise Solution - Entering Text and Using AutoComplete - Presentation - 3:04
    • Activity 10 - Entering Numbers and Dates - Reading
    • Activity 11 - Using the Fill Handle - Reading
    • Activity 12 - Entering Data and Using the Fill Handle - Presentation - 2:14
    • Activity 13 - Entering Numbers and Dates - Exercise
    • Activity 14 - Exercise Solution - Entering Numbers and Dates - Presentation - 4:00
    • Activity 15 - Entering Data Quiz - Quiz
  • Lesson 6 - Formatting Microsoft Excel Worksheets
    • Activity 1 - The Most Common Formatting Commands - Reading
    • Activity 2 - Selecting Ranges of Cells - Reading
    • Activity 3 - Hiding Worksheets - Reading
    • Activity 4 - Adding Color to Worksheet Tabs - Reading
    • Activity 5 - Adding Themes to Workbooks - Reading
    • Activity 6 - Customize a Workbook Using Tab Colors and Themes - Exercise
    • Activity 7 - Adding a Watermark - Reading
    • Activity 8 - The Font Group - Reading
    • Activity 9 - Selecting Cells and Formatting Font - Presentation - 2:28
    • Activity 10 - Working with Font Group Commands - Exercise
    • Activity 11 - Exercise Solution - Working with Font Group Commands - Presentation - 4:20
    • Activity 12 - The Alignment Group - Reading
    • Activity 13 - Working with Alignment Group Commands - Exercise
    • Activity 14 - The Number Group - Reading
    • Activity 15 - Using the Number Group - Presentation - 2:33
    • Activity 16 - Working with Number Group Commands - Exercise
    • Activity 17 - Exercise Solution - Working with Number Group Commands - Presentation - 1:38
    • Activity 18 - Formatting Worksheets Quiz - Quiz
  • Lesson 7 - Using Formulas in Microsoft Excel
    • Activity 1 - Math Operators and the Order of Operations - Reading
    • Activity 2 - Entering Formulas - Reading
    • Activity 3 - AutoSum (and Other Common Auto-Formulas) - Reading
    • Activity 4 - Copying Formulas and Functions - Reading
    • Activity 5 - Using Formulas in Excel - Presentation - 3:19
    • Activity 6 - Relative, Absolute, and Mixed Cell References - Reading
    • Activity 7 - Working with Formulas - Exercise
    • Activity 8 - Exercise Solution - Working with Formulas - Presentation - 5:21
    • Activity 9 - Using Formulas Quiz - Quiz
  • Lesson 8 - Working with Rows and Columns
    • Activity 1 - Inserting Rows and Columns - Reading
    • Activity 2 - Deleting Rows and Columns - Reading
    • Activity 3 - Transposing Rows and Columns - Reading
    • Activity 4 - Setting Row Height and Column Width - Reading
    • Activity 5 - Inserting, Deleting, and Adjusting Size of Rows and Columns - Presentation - 2:47
    • Activity 6 - Hiding and Unhiding Rows and Columns - Reading
    • Activity 7 - Freezing Panes - Reading
    • Activity 8 - Hiding, Unhiding, and Freezing Rows and Columns - Presentation - 1:35
    • Activity 9 - Working with Rows and Columns - Exercise
    • Activity 10 - Exercise Solution - Working with Rows and Columns - Presentation - 2:47
    • Activity 11 - Working with Rows and Columns Quiz - Quiz
  • Lesson 9 - Editing Worksheets
    • Activity 1 - Find - Reading
    • Activity 2 - Find and Replace - Reading
    • Activity 5 - Exercise Solution - Using Find and Replace - Presentation - 1:09
    • Activity 6 - Using the Clipboard - Reading
    • Activity 7 - Using the Clipboard - Exercise
    • Activity 8 - Exercise Solution - Using the Clipboard - Presentation - 1:45
    • Activity 9 - Using Format Painter - Exercise
    • Activity 10 - Exercise Solution - Using Format Painter - Presentation - 1:11
    • Activity 11 - Managing Comments - Reading
    • Activity 12 - Editing Worksheets Quiz - Quiz
  • Lesson 10 - Finalizing Microsoft Excel Worksheets
    • Activity 1 - Setting Margins - Reading
    • Activity 2 - Setting Page Orientation - Reading
    • Activity 3 - Finalizing a Worksheet - Presentation - 2:16
    • Activity 4 - Setting the Print Area - Reading
    • Activity 5 - Print Scaling (Fit Sheet on One Page) - Reading
    • Activity 6 - Printing Headings on Each Page
    • Activity 7 - Headers and Footers - Reading
    • Activity 8 - Preparing to Print - Exercise
    • Activity 9 - Exercise Solution - Preparing to Print - Presentation - 2:40
    • Activity 10 - Finalizing Worksheets Quiz - Quiz
  • Lesson 11 - Introduction to Microsoft Excel 2019 Exam
    • Activity 1 - Introduction to Microsoft Excel 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
80

Introduction to Microsoft Access 2019

Learn Basic Database Concepts & Create Your Own Tables and Reports

By Webucator | in Online Courses

Choose this Access class if you are new to Microsoft Access. You will learn to work with table views, queries, forms, reports, and macros and modules, to design databases, and to use the Form Wizard to create forms and the Report Wizard to create reports in Access 2019 or Access 365. If you have little or no familiarity with Microsoft Access 2019, this is for you.

10/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 80 lectures & 1 hour of content 24/7
  • Gain an understanding of database concepts & terminology
  • Learn about the Access interface
  • Work w/ table views, queries, forms, reports, & macros and modules
  • Plan a database
  • Learn database design fundamentals
  • Work w/ forms & the Form Wizard
  • Work w/ reports & the Report Wizard
Note: Software NOT included

"Introduction to Access was an excellent class, and thoroughly enjoyable! The class size was small enough to get personal attention, and even though I have had some exposure to Access, I learned a lot. The instructor was knowledgeable enough to give tips and explanations that went beyond the lesson books." – Carrie Armenta, Oaktree Capital Management

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - Quick Overview of the Access User Interface
    • Activity 1 - Access Ribbon - Reading
    • Activity 2 - Quick Access Toolbar - Reading
    • Activity 3 - Object Navigation Pane - Reading
    • Activity 4 - Navigation - Presentation - 7:06
    • Activity 5 - Access Work Surface - Reading
    • Activity 6 - Object Overview - Reading
    • Activity 7 - Objects - Presentation - 5:12
    • Activity 8 - Process Overview - Reading
    • Activity 9 - Getting Around the Access Environment - Exercise
    • Activity 10 - Review_ Getting Around the Access Environment - Presentation - 3:46
    • Activity 11 - Create a Database Using a Wizard - Reading
    • Activity 12 - Wizard Interface - Presentation - 2:58
    • Activity 13 - Access User Interface Quiz - Quiz
  • Lesson 2 - Fundamentals
    • Activity 1 - Questions to Ask Before You Start - Reading
    • Activity 2 - Asking Questions - Exercise
    • Activity 3 - Review_ Asking Questions - Presentation - 2:09
    • Activity 4 - Approaches to Database Design - Reading
    • Activity 5 - Gather Information - Reading
    • Activity 6 - A Few Words about Naming Conventions - Reading
    • Activity 7 - Gathering Information - Exercise
    • Activity 8 - Review_ Gathering Information - Presentation - 1:47
    • Activity 9 - Normalization - Reading
    • Activity 10 - Table Relationships - Reading
    • Activity 11 - Normalizing Data - Exercise
    • Activity 12 - Review_ Normalization of Data - Presentation - 2:00
    • Activity 13 - Fundamental Quiz - Quiz
  • Lesson 3 - Tables and Their Views
    • Activity 1 - Definition and Purpose - Reading
    • Activity 2 - Definition and Purpose - Presentation - 1:30
    • Activity 3 - Datasheet View - Reading
    • Activity 4 - Datasheet View - Presentation - 7:44
    • Activity 5 - Working with Tables in Datasheet View - Exercise
    • Activity 6 - Review_ Working with Tables in Datasheet View - Presentation - 5:24
    • Activity 8 - Create a Table in Design View - Reading
    • Activity 9 - Create a Table in Design View - Presentation - 13:56
    • Activity 10 - Creating a Table in Design View - Exercise
    • Activity 11 - Review_ Creating a Table in Design View - Presentation - 4:06
    • Activity 12 - Table Quiz - Quiz
  • Lesson 5 - Queries
    • Activity 1 - Queries - Reading
    • Activity 2 - Select Queries - Reading
    • Activity 3 - Select Queries - Presentation - 4:40
    • Activity 4 - Select Queries with Criteria - Reading
    • Activity 5 - Select Queries with Criteria - Presentation - 4:22
    • Activity 6 - Logical Operators - Reading
    • Activity 7 - Group and Total with Queries - Reading
    • Activity 8 - Group and Total with Queries - Presentation - 3:35
    • Activity 9 - Creating Select Queries - Exercise
    • Activity 10 - Review_ Creating Select Queries - Presentation - 2:19
    • Activity 11 - Query Quiz - Quiz
  • Lesson 6 - Forms
    • Activity 1 - Forms - Reading
    • Activity 2 - Alter a Form - Reading
    • Activity 3 - Forms - Presentation - 8:04
    • Activity 4 - Adding Data Records in Form View - Exercise
    • Activity 5 - Review_ Adding Data Records in Form View - Presentation - 2:39
    • Activity 6 - Form Record Navigation - Reading
    • Activity 7 - Navigation - Presentation - 2:28
    • Activity 8 - Layout View and Design View - Reading
    • Activity 9 - One-Click Forms - Reading
    • Activity 10 - Form Wizard - Reading
    • Activity 11 - Methods of Form Creation - Presentation - 6:27
    • Activity 12 - Creating a Form with the Form Wizard - Exercise
    • Activity 13 - Review_ Creating a Form with the Form Wizard - Presentation - 2:08
    • Activity 14 - Forms Quiz - Quiz
  • Lesson 7 - Reports
    • Activity 1 - Reports - Reading
    • Activity 2 - Reports - Presentation - 6:16
    • Activity 3 - Report Wizard - Reading
    • Activity 4 - Report Wizard - Presentation - 3:56
    • Activity 5 - Creating a Report with the Report Wizard - Exercise
    • Activity 6 - Review_ Creating a Report with the Report Wizard - Presentation - 4:36
    • Activity 7 - Reports Quiz - Quiz
  • Lesson 8 - Databases and Access Terms
    • Activity 1 - Database Defined - Reading
    • Activity 2 - Databases vs. Spreadsheets - Reading
    • Activity 3 - Access vs. Excel - Reading
    • Activity 4 - Relational Database Defined - Reading
    • Activity 5 - Understanding Relational Databases - Exercise
    • Activity 6 - Relational Database Management System (RDBMS) Defined - Reading
    • Activity 7 - Access is an RDBMS - Reading
    • Activity 8 - Creating a Relationship - Reading
    • Activity 9 - Benefits and Limitations of Access - Reading
  • Lesson 9 - Introduction to Microsoft Access 2019 Exam
    • Activity 1 - Introduction to Microsoft Access 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
77

Introduction to Microsoft Outlook 2019

Work with Messages, Calendars & Contacts in Outlook 2019 or Outlook 365

By Webucator | in Online Courses

Choose this Outlook class if you are new to Microsoft Outlook. This Microsoft Outlook training class introduces the 2019 interface and gets students up and running quickly working with messages, calendars, and contacts in Outlook 2019 or Outlook 365. Your expert instructor will also teach you about the Ribbon, Tabs, Groups, and Commands, and other new features in Outlook.

9.7/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 77 lectures & 1 hour of content 24/7
  • Learn about the new features in Outlook
  • Learn about the Ribbon, Tabs, Groups, &Commands
  • Explore the Backstage View
  • Set up accounts & work w/ messages
  • Work with calendars & contacts
Note: Software NOT included.

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Familiarity with using a personal computer, mouse, and keyboard
  • Comfortable in the Windows environment

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - The Outlook 2019 Interface
    • Activity 1 - Overview of the Outlook Interface - Reading
    • Activity 2 - The Ribbon - Reading
    • Activity 3 - Tabs, Groups, and Commands on the Ribbon - Reading
    • Activity 4 - The Ribbon Review - Presentation - 2:09
    • Activity 5 - Exploring the Ribbon - Exercise
    • Activity 6 - The Backstage View (File Menu) - Reading
    • Activity 7 - Exploring the Backstage View - Exercise
    • Activity 8 - Exercise Solution - Exploring the Backstage View - Presentation - 1:23
    • Activity 9 - The Outlook 2019 Interface Quiz - Quiz
  • Lesson 2 - Performing Popular Tasks in Outlook 2019
    • Activity 1 - Setting Up an Email Account - Reading
    • Activity 2 - Setting Up an Email Account - Exercise
    • Activity 4 - Reply to and Forward Email Messages - Reading
    • Activity 5 - Review of Opening, Replying to, and Forwarding Messages - Presentation - 1:47
    • Activity 6 - Preview and Save an Attachment - Reading
    • Activity 7 - Opening and Replying to a Message - Exercise
    • Activity 8 - Exercise Solution - Opening and Replying to a Message - Presentation - 1:54
    • Activity 9 - Print a Message - Reading
    • Activity 10 - Delete a Message - Reading
    • Activity 11 - Save a Message in an Alternate Format - Reading
    • Activity 12 - Delegate Access - Reading
    • Activity 13 - Review of Printing and Deleting Emails - Presentation - 1:29
    • Activity 14 - Printing a Message - Exercise
    • Activity 15 - Exercise Solution - Printing a Message - Presentation - 1:19
    • Activity 16 - Customize the Navigation Pane - Reading
    • Activity 17 - Performing Popular Tasks in Outlook 2019 Quiz - Quiz
  • Lesson 3 - Working with Messages
    • Activity 1 - Compose a Message - Reading
    • Activity 2 - Add an Attachment - Reading
    • Activity 3 - Review of Composing Messages and Adding Attachments - Presentation - 1:56
    • Activity 4 - Add Voting Options - Reading
    • Activity 5 - Check Spelling and Grammar - Reading
    • Activity 6 - Format Text - Reading
    • Activity 7 - Use Microsoft Word to Edit Messages - Reading
    • Activity 8 - Insert a Hyperlink or Image in a Message - Reading
    • Activity 9 - Review of Inserting a Link or Image in a Message - Presentation - 1:40
    • Activity 10 - Send a Message - Reading
    • Activity 11 - Creating and Sending a New Message - Exercise
    • Activity 12 - Exercise Solution - Creating and Sending a New Message - Presentation - 2:00
    • Activity 13 - Working with Messages Quiz - Quiz
  • Lesson 4 - Working with the Calendar
    • Activity 1 - Change Your Calendar View - Reading
    • Activity 2 - Set Up Availability Status - Reading
    • Activity 3 - Setting Up Your Calendar - Exercise
    • Activity 4 - Exercise Solution - Setting Up Your Calendar - Presentation - 1:55
    • Activity 5 - Print Your Schedule - Reading
    • Activity 6 - Share Your Calendar - Reading
    • Activity 7 - Schedule a Meeting - Reading
    • Activity 8 - Make Updates to Meetings - Reading
    • Activity 9 - Cancel a Meeting - Reading
    • Activity 10 - Review of Scheduling a Meeting - Presentation - 2:30
    • Activity 11 - Reply to a Meeting Invitation - Reading
    • Activity 12 - Schedule an Appointment - Reading
    • Activity 13 - Make Updates to an Appointment - Reading
    • Activity 14 - Review of Scheduling an Appointment - Presentation - 1:46
    • Activity 15 - Create Calendar Groups - Reading
    • Activity 16 - Review of Creating a Calendar Group - Presentation - 1:34
    • Activity 17 - Delete a Calendar - Reading
    • Activity 18 - Work with Calendar Items - Reading
    • Activity 19 - Create and Add Calendars - Reading
    • Activity 20 - Scheduling a Meeting - Exercise
    • Activity 21 - Exercise Solution - Scheduling a Meeting - Presentation - 1:44
    • Activity 22 - Working with the Calendar Quiz - Quiz
  • Lesson 5 - Organizing Contacts
    • Activity 1 - Add, Delete, Import, and Print a Contact - Reading
    • Activity 2 - Update a Contact - Reading
    • Activity 3 - Review of Working with Contacts - Presentation - 2:29
    • Activity 4 - Adding and Updating a Contact - Exercise
    • Activity 5 - Exercise Solution - Adding and Updating a Contact - Presentation - 1:33
    • Activity 6 - Locate a Contact - Reading
    • Activity 7 - Sort Contacts - Reading
    • Activity 8 - Work with Contact Groups - Reading
    • Activity 9 - Review of Working with Contact Groups - Presentation - 2:19
    • Activity 10 - Manage Multiple Address Books - Reading
    • Activity 11 - Perform a Mail Merge - Reading
    • Activity 12 - Review of Performing a Mail Merge - Presentation - 3:31
    • Activity 13 - Performing a Mail Merge - Exercise
    • Activity 14 - Exercise Solution - Performing a Mail Merge - Presentation - 2:14
    • Activity 15 - Organizing Contacts Quiz - Quiz
  • Lesson 6 - Introduction to Microsoft Outlook 2019 Exam
    • Activity 1 - Introduction to Microsoft Outlook 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
86

Introduction to Microsoft Word 2019 Training

Learn to Create, Edit, Format, & Print Microsoft Word Documents

By Webucator | in Online Courses

New to Microsoft Word? If so, this Microsoft Word course is for you. Your live instructor will show you how to create new documents and how to open and work in existing documents using Word 2019 or Word 365. By the end of this Word class, you will be comfortable editing, formatting and printing documents and you will know your way around Microsoft Word.

8.8/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 86 lectures & 1 hour of content 24/7
  • Create & edit Microsoft Word documents
  • Learn about the Ribbon & File tab
  • Create new documents & use Word templates
  • Format Word documents
  • Add page numbers, headers & footers, and spell and grammar check documents
Note: Software NOT included.

"I liked the way this was customized to meet my needs. I learned a lot of things that will save me time." – Terry Humphries

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - Creating a Microsoft Word Document
    • Activity 1 - Starting Microsoft Word - Reading
    • Activity 2 - Creating a Document - Reading
    • Activity 3 - Saving a Document - Reading
    • Activity 4 - Starting, Creating, and Saving Review - Presentation - 1:59
    • Activity 5 - Importing a File - Reading
    • Activity 6 - The Status Bar - Reading
    • Activity 7 - Closing a Document - Reading
    • Activity 8 - Status Bar and Closing Review - Presentation - 2:02
    • Activity 9 - Create a Microsoft Word Document - Exercise
    • Activity 10 - Exercise Solution - Create a Microsoft Word Document - Presentation - 1:24
    • Activity 11 - Creating a Microsoft Word Document Quiz - Quiz
  • Lesson 2 - The Ribbon
    • Activity 1 - The Ribbon - Reading
    • Activity 2 - Tabs - Reading
    • Activity 3 - Groups - Reading
    • Activity 4 - Commands - Reading
    • Activity 5 - The Ribbon Review - Presentation - 2:35
    • Activity 6 - Exploring the Ribbon - Exercise
    • Activity 7 - Word Ribbon Quiz - Quiz
  • Lesson 3 - The Backstage View (The File Menu)
    • Activity 1 - Introduction to the Backstage View - Reading
    • Activity 2 - Backstage View Review - Presentation - 2:18
    • Activity 3 - Opening a Document - Reading
    • Activity 4 - Open a Document - Exercise
    • Activity 5 - Exercise Solution - Open a Document - Presentation - 1:18
    • Activity 6 - New Documents and Word Templates - Reading
    • Activity 7 - Write a Thank You Letter Using a Template Letter - Exercise
    • Activity 8 - Exercise Solution - Write a Thank You Letter Using a Template - Presentation - 1:42
    • Activity 9 - Configuring Documents to Print - Reading
    • Activity 10 - Print a Document - Exercise
    • Activity 11 - Printing Review - Presentation - 1:30
    • Activity 12 - Adding Your Name to Microsoft Word - Reading
    • Activity 13 - Adding Values to Document Properties - Reading
    • Activity 14 - Working with Autosaved Versions of Documents - Reading
    • Activity 15 - Word Backstage View (The File Menu) Quiz - Quiz
  • Lesson 4 - The Quick Access Toolbar
    • Activity 1 - Quick Access Toolbar - Reading
    • Activity 2 - Adding Common Commands - Reading
    • Activity 3 - Adding Additional Commands with the Customize Dialog Box - Reading
    • Activity 4 - Adding Ribbon Commands or Groups - Reading
    • Activity 5 - Placement - Reading
    • Activity 6 - Quick Access Toolbar Review - Presentation - 2:57
    • Activity 7 - Customize the Quick Access Toolbar - Exercise
    • Activity 8 - Exercise Solution - Customize the Quick Access Toolbar - Presentation - 2:21
    • Activity 9 - Word Quick Access Toolbar Quiz - Quiz
  • Lesson 5 - Formatting Microsoft Word Documents
    • Activity 1 - Selecting Text - Reading
    • Activity 2 - Selecting Fonts - Reading
    • Activity 3 - Text and Fonts Review - Presentation - 1:35
    • Activity 4 - Working with Fonts - Exercise
    • Activity 5 - Exercise Solution - Working with Fonts - Presentation - 2:10
    • Activity 6 - Working with Lists - Reading
    • Activity 7 - Working with Lists - Exercise
    • Activity 8 - Exercise Solution - Working with Lists - Presentation - 1:37
    • Activity 9 - Inserting a Hyperlink in a Document - Reading
    • Activity 10 - Inserting a Hyperlink - Exercise
    • Activity 11 - Exercise Solution - Inserting a Hyperlink - Presentation - 1:39
    • Activity 12 - Using Styles - Reading
    • Activity 13 - Applying and Creating Custom Styles - Exercise
    • Activity 14 - Exercise Solution - Applying and Creating Custom Styles - Presentation - 3:33
    • Activity 15 - Using Themes - Reading
    • Activity 16 - Using the Ruler - Reading
    • Activity 17 - Using Tabs - Exercise
    • Activity 18 - Exercise Solution - Using Tabs - Presentation - 3:22
    • Activity 19 - Setting Margins - Reading
    • Activity 20 - Setting Margins - Exercise
    • Activity 21 - Exercise Solution - Setting Margins - Presentation - 1:43
    • Activity 22 - Formatting Microsoft Word Documents Quiz - Quiz
  • Lesson 6 - Editing Documents
    • Activity 1 - Find - Reading
    • Activity 2 - Find and Replace - Reading
    • Activity 3 - Find and Replace Tips - Reading
    • Activity 4 - Appending Text to a Document - Reading
    • Activity 5 - Using Find and Replace - Exercise
    • Activity 6 - Exercise Solution - Using Find and Replace - Presentation - 1:37
    • Activity 7 - Using the Clipboard - Reading
    • Activity 8 - Using the Clipboard - Exercise
    • Activity 9 - Exercise Solution - Using the Clipboard - Presentation - 3:28
    • Activity 10 - Editing Documents Quiz - Quiz
  • Lesson 7 - Finalizing Microsoft Word Documents
    • Activity 1 - Adding Page Numbers - Reading
    • Activity 2 - Adding Page Numbers - Exercise
    • Activity 3 - Exercise Solution - Adding Page Numbers - Presentation - 2:35
    • Activity 4 - Headers and Footers - Reading
    • Activity 5 - Using Headers and Footers - Exercise
    • Activity 6 - Exercise Solution - Using Headers and Footers - Presentation - 3:28
    • Activity 7 - Checking Spelling and Grammar - Reading
    • Activity 8 - Checking Spelling & Grammar - Exercise
    • Activity 9 - Exercise Solution - Checking Spelling and Grammar - Presentation - 1:24
    • Activity 10 - Finalizing Microsoft Word Documents Quiz - Quiz
  • Lesson 8 - Introduction to Microsoft Word 2019 Exam
    • Activity 1 - Introduction to Microsoft Word 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
101

Introduction to Microsoft PowerPoint 2019 Training

Get Familiar with the 2019 Features, Animations, Transitions & More of Microsoft PowerPoint and Work on Basic Presentations

By Webucator | in Online Courses

This Introduction to PowerPoint 2019 training class is designed for students who are interested in learning the fundamentals needed to create and modify basic presentations using PowerPoint 2019 or PowerPoint 365. With 101 lectures, you will explore the PowerPoint environment and create a presentation. You'll be able to format text on slides to enhance clarity and add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form and then finalize a presentation.

9.7/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 101 lectures & 1 hour of content 24/7
  • Start & end a PowerPoint session
  • Edit a presentation
  • Create different types of slides
  • Use the Outline tab
  • Add Clipart to a slide
  • Format slides & use templates
  • Use the Slide Sorter to reorganize a presentation
  • Apply Tables & Charts to a presentation
  • Print various components of a presentation
  • Run a slide show
Note: Software NOT included.

"Easy to register. Easy to contact. Easy to follow along. Makes easy to learn." – Nikita Bolden

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - Creating a PowerPoint Presentation
    • Activity 1 - Starting Microsoft PowerPoint - Reading
    • Activity 2 - Starting Microsoft PowerPoint Review - Presentation - 2:27
    • Activity 3 - Normal View - Reading
    • Activity 4 - Creating a Presentation - Reading
    • Activity 5 - Saving a Document - Reading
    • Activity 6 - Importing a File - Reading
    • Activity 7 - The Status Bar - Reading
    • Activity 8 - The Status Bar Review - Presentation - 1:44
    • Activity 9 - Closing a Presentation - Reading
    • Activity 10 - Creating a Microsoft PowerPoint Presentation - Exercise
    • Activity 11 - Exercise Solution - Creating a Microsoft PowerPoint Presentation - Presentation - 1:57
    • Activity 12 - Creating a PowerPoint Presentation Quiz - Quiz
  • Lesson 2 - The Ribbon
    • Activity 1 - Tabs - Reading
    • Activity 2 - Groups - Reading
    • Activity 3 - Commands - Reading
    • Activity 4 - The Tell Me Tab - Reading
    • Activity 5 - The Ribbon - Reading
    • Activity 6 - The Ribbon Review - Presentation - 3:40
    • Activity 7 - Exploring the Ribbon - Exercise
    • Activity 8 - Exercise Solution - Exploring the Ribbon - Presentation - 2:25
    • Activity 9 - PPT Ribbon Quiz - Quiz
  • Lesson 3 - The Quick Access Toolbar
    • Activity 1 - The Quick Access Toolbar - Reading
    • Activity 2 - Adding Common Commands - Reading
    • Activity 3 - Adding More Commands with the Customize Dialog Box - Reading
    • Activity 4 - Adding Ribbon Commands or Groups - Reading
    • Activity 5 - Placement - Reading
    • Activity 6 - Quick Access Toolbar Review - Presentation - 3:09
    • Activity 7 - Customizing the Quick Access Toolbar - Exercise
    • Activity 8 - Exercise Solution - Customizing the Quick Access Toolbar - Presentation - 2:57
    • Activity 9 - PPT Quick Access Toolbar Quiz - Quiz
  • Lesson 4 - The Backstage View (The File Menu)
    • Activity 1 - Introduction to the Backstage View - Reading
    • Activity 2 - Backstage View Review - Presentation - 1:37
    • Activity 3 - Opening a Presentation - Reading
    • Activity 4 - Opening a Presentation - Exercise
    • Activity 5 - Exercise Solution - Opening a Presentation - Presentation - 1:33
    • Activity 6 - New Presentations and Presentation Templates - Reading
    • Activity 7 - Creating an Agenda Using a Template - Exercise
    • Activity 8 - Exercise Solution - Creating an Agenda Using a Template - Presentation - 1:51
    • Activity 9 - Presentation Properties - Reading
    • Activity 10 - Adding Your Name to Microsoft PowerPoint - Reading
    • Activity 11 - PPT Backstage View (The File Menu) Quiz - Quiz
  • Lesson 5 - Formatting Microsoft PowerPoint Presentations
    • Activity 1 - Selecting a Slide Layout - Reading
    • Activity 2 - Adding Text - Reading
    • Activity 3 - Adding Text from a Text File or Word Outline - Reading
    • Activity 4 - Editing Text - Reading
    • Activity 5 - Formatting Text - Reading
    • Activity 6 - Formatting Text as WordArt - Reading
    • Activity 7 - Formatting Review - Presentation - 2:25
    • Activity 8 - Creating Bulleted and Numbered Lists - Reading
    • Activity 9 - Ink Equation - Reading
    • Activity 10 - Formatting Text Placeholders - Reading
    • Activity 11 - Adding Slides to a Presentation - Reading
    • Activity 12 - Arranging Slides - Reading
    • Activity 13 - Formatting Text - Exercise
    • Activity 14 - Exercise Solution - Formatting Text - Presentation - 2:49
    • Activity 15 - Formatting Microsoft PowerPoint Presenations Quiz - Quiz
  • Lesson 6 - Working with Images
    • Activity 1 - Adding Images to a Slide - Reading
    • Activity 2 - Grouping and Ungrouping Images - Reading
    • Activity 3 - Inserting a Picture - Reading
    • Activity 4 - Arranging Images - Reading
    • Activity 5 - Adding Shapes - Reading
    • Activity 6 - Using Digital Ink - Reading
    • Activity 7 - Inserting Clip Art - Reading
    • Activity 8 - Inserting Images Review - Presentation - 1:46
    • Activity 9 - Editing an Image - Reading
    • Activity 10 - Editing Images Review - Presentation - 2:31
    • Activity 11 - Creating Custom Color with the Eyedropper - Reading
    • Activity 12 - Applying a Style and Cropping an Image - Reading
    • Activity 13 - Formatting Images - Reading
    • Activity 14 - Capturing and Inserting a Screenshot - Reading
    • Activity 15 - Inserting Icons - Reading
    • Activity 16 - Working with Images and Shapes - Exercise
    • Activity 17 - Exercise Solution - Working with Images and Shapes - Presentation - 2:37
    • Activity 18 - Working with Images in PPT Quiz - Quiz
  • Lesson 7 - Working with Tables and Charts
    • Activity 1 - Inserting a Table - Reading
    • Activity 2 - Formatting Tables - Reading
    • Activity 3 - Using Tables Review - Presentation - 2:34
    • Activity 4 - Importing Tables from External Sources - Reading
    • Activity 5 - Working with a Table - Exercise
    • Activity 6 - Exercise Solution - Working with a Table - Presentation - 3:02
    • Activity 7 - Inserting a Chart - Reading
    • Activity 8 - Formatting a Chart - Reading
    • Activity 9 - Using Charts Review - Presentation - 2:38
    • Activity 10 - Importing Charts from External Sources - Reading
    • Activity 11 - Working with Charts - Exercise
    • Activity 12 - Exercise Solution - Working with Charts - Presentation - 1:47
    • Activity 13 - Working with Tables and Charts Quiz - Quiz
  • Lesson 8 - Finalizing Microsoft PowerPoint Presentations
    • Activity 1 - Checking Spelling - Reading
    • Activity 2 - Accessing Different Views of a Presentation - Reading
    • Activity 3 - Viewing the Presentation - Exercise
    • Activity 4 - Exercise Solution - Viewing the Presentation - Presentation - 1:36
    • Activity 5 - Organizing a Presentation in Sections - Reading
    • Activity 6 - Adding Transitions to Slides - Reading
    • Activity 7 - Adding Speaker Notes - Reading
    • Activity 8 - Running a Slide Show - Reading
    • Activity 9 - Printing a Presentation - Reading
    • Activity 10 - Finalizing Your Presentation - Exercise
    • Activity 11 - Exercise Solution - Finalizing Your Presentation - Presentation - 2:18
    • Activity 12 - Finalizing Microsoft PowerPoint Presentations Quiz - Quiz
  • Lesson 9 - Introduction to Microsoft PowerPoint 2019 Final Exam
    • Activity 1 - Introduction to Microsoft PowerPoint 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
66

Intermediate Microsoft Word 2019 Training

Learn Advanced Formatting — Us eDrawing Tools, Create & Manage Tables, and Work with Column Layouts

By Webucator | in Online Courses

If you are already comfortable creating and editing documents in Microsoft Word, but aren't sure how to make your documents look great, then this is the Microsoft Word course for you. Your expert instructor will show you how to add images and tables to your documents and then how to customize them so they look how you want them to look using Word 2019 or Word 365. You will learn to add page and section breaks and you will learn advanced formatting techniques.

8.3/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 66 lectures & 1 hour of content 24/7
  • Use Word 2019's advanced editing tools
  • Work w/ images, including placing & sizing images, wrapping text around images, and using borders and effects
  • Adjust page orientation & layout
  • Work w/ columns & page and section breaks
  • Learn about document views, using the navigation pane, & viewing multiple windows
Note: Software NOT included.

"The instructor was very knowledgeable and friendly, making the course an enjoyable experience. I am looking forward to taking the Advanced Word course." – Rachel Nelson

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Basic Microsoft Word skills
  • Prerequisite course: Introduction to Microsoft Word 2019 Training

Course Outline

  • Setup for Your Class
    • Setup for Your Class
  • Lesson 1 - Advanced Formatting
    • Activity 1 - Shading and Borders - Reading
    • Activity 2 - Using Shading and Borders - Exercise
    • Activity 3 - Setting Line and Paragraph Spacing - Reading
    • Activity 4 - Changing Styles - Reading
    • Activity 5 - Styles Review - Presentation - 1:43
    • Activity 6 - Changing Styles - Exercise
    • Activity 7 - Exercise Solution - Changing Styles - Presentation - 1:31
    • Activity 8 - Paragraph Marks and Other Formatting Symbols - Reading
    • Activity 9 - Using Formatting Symbols - Exercise
    • Activity 10 - Exercise Solution - Using Formatting Symbols - Presentation - 1:33
    • Activity 11 - Editing PDF Documents in Microsoft Word - Reading
    • Activity 12 - Advanced Word Formatting Quiz - Quiz
  • Lesson 2 - Working with Tables
    • Activity 1 - Inserting a Table - Reading
    • Activity 2 - Tables Review - Presentation - 1:49
    • Activity 3 - Insert a Table - Exercise
    • Activity 4 - Exercise Solution - Insert a Table - Presentation - 1:47
    • Activity 5 - Table Styles - Reading
    • Activity 6 - Adding Styles to a Table - Exercise
    • Activity 7 - Exercise Solution - Adding Styles to a Table - Presentation - 1:43
    • Activity 8 - Formatting a Table - Reading
    • Activity 9 - Formatting a Table - Exercise
    • Activity 10 - Exercise Solution - Formatting a Table - Presentation - 2:05
    • Activity 11 - Working with Tables in Word Quiz - Quiz
  • Lesson 3 - Working with Images
    • Activity 1 - Inserting Images - Reading
    • Activity 2 - Inserting Images Review - Presentation - 1:46
    • Activity 3 - Insert an Image into a Microsoft Word Document - Exercise
    • Activity 4 - Exercise Solution - Insert an Image into a Word Document - Presentation - 1:17
    • Activity 5 - Placing and Sizing Images - Reading
    • Activity 6 - Place and Size an Image in a Microsoft Word Document - Exercise
    • Activity 7 - Exercise Solution - Place and Size an Image in a Word Document - Presentation - 1:36
    • Activity 8 - Wrapping Text around an Image - Reading
    • Activity 9 - Wrapping Text around an Image - Exercise
    • Activity 10 - Adjusting Images - Reading
    • Activity 11 - Adjusting Images in Microsoft Word - Exercise
    • Activity 12 - Exercise Solution - Adjusting Images in Microsoft Word - Presentation - 2:55
    • Activity 13 - Borders and Effects - Reading
    • Activity 14 - Adding Borders and Effects to Images in Microsoft Word - Exercise
    • Activity 15 - Exercise Solution - Adding Borders and Effects to Images in Microsoft Word - Presentation - 1:42
    • Activity 16 - Working with Images in Word Quiz - Quiz
  • Lesson 4 - Page Layout
    • Activity 1 - Orientation and Paper Size - Reading
    • Activity 2 - Using Live Layout and Alignment Guides - Reading
    • Activity 3 - Working with Columns - Reading
    • Activity 4 - Page Layout Review - Presentation - 1:57
    • Activity 5 - Changing the Page Setup - Exercise
    • Activity 6 - Exercise Solution - Changing the Page Setup - Presentation - 1:28
    • Activity 7 - Advanced Formatting - Reading
    • Activity 8 - Working with Fields - Reading
    • Activity 9 - Page and Section Breaks - Reading
    • Activity 10 - Adding Page and Section Breaks - Exercise
    • Activity 11 - Exercise Solution - Adding Page and Section Breaks - Presentation - 2:10
    • Activity 12 - Page Layout Quiz - Quiz
  • Lesson 5 - Working with Illustrations
    • Activity 1 - Adding and Editing Charts - Reading
    • Activity 2 - Charts Review - Presentation - 2:24
    • Activity 3 - Working with Charts - Exercise
    • Activity 4 - Exercise Solution - Working with Charts - Presentation - 2:37
    • Activity 5 - Working with Clip Art - Reading
    • Activity 6 - Working with Clip Art - Exercise
    • Activity 7 - Exercise Solution - Working with Clip Art - Presentation - 1:49
    • Activity 8 - Using Shapes - Reading
    • Activity 9 - Working with Icons - Reading
    • Activity 10 - Adding Shapes - Exercise
    • Activity 11 - Working with SmartArt - Reading
    • Activity 12 - Working with SmartArt - Exercise
    • Activity 13 - Exercise Solution - Working with SmartArt - Presentation - 2:21
    • Activity 14 - Creating Captions - Reading

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
96

Intermediate Microsoft Excel 2019 Training

Advance Your Skill Set with MS Excel 2019 & Work with Charts and Advanced Formatting

By Webucator | in Online Courses

This Intermediate Microsoft Excel 2019 training class is meant for students using Excel 2019 or Excel 365 who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles. Learn to streamline and analyze data and to keep data organized by managing large data sets with lists and tables. Learn to use filters to save time, as well as great ways to group and summarize data.

9.3/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 96 lectures & 1 hour of content 24/7
  • Learn to use formulas & functions
  • Convert, sort, filter & manage lists
  • Insert & modify illustrations in a worksheet
  • Learn to use conditional formatting & styles
Note: Software NOT included

"Very helpful and informative. Covered everything expected and more. Highly recommend to anyone that uses Excel." – Dawn Andrew, Triaco

"Our instructor was extremely knowledgeable in all facets of Excel and had a wonderful personality." – Mike Cusano, CSM Group of Companies

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Basic Excel
  • Pre-requisite course: Introduction to Microsoft Excel 2019 Training

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - Advanced Formulas
    • Activity 1 - Using Named Ranges in Formulas - Reading
    • Activity 2 - Review of Using Named Ranges in Formulas - Presentation - 1:14
    • Activity 3 - Using Named Ranges in Formulas - Exercise
    • Activity 4 - Exercise Solution - Using Named Ranges in Formulas - Presentation - 3:00
    • Activity 5 - Using Formulas That Span Multiple Worksheets - Reading
    • Activity 6 - Entering a Formula Using Data in Multiple Worksheets - Exercise
    • Activity 7 - Exercise Solution - Entering a Formula Using Data in Multiple Worksheets - Presentation - 3:10
    • Activity 8 - Using the IF Function - Reading
    • Activity 9 - Using the IF Function - Exercise
    • Activity 10 - Exercise Solution - Using the IF Function - Presentation - 3:39
    • Activity 11 - Using the PMT Function - Reading
    • Activity 12 - Using the PMT Function - Exercise
    • Activity 13 - Exercise Solution - Using the PMT Function - Presentation - 5:02
    • Activity 14 - Using the LOOKUP Function - Reading
    • Activity 15 - Using the VLOOKUP Function - Reading
    • Activity 16 - Using the VLOOKUP Function - Exercise
    • Activity 17 - Exercise Solution - Using the VLOOKUP Function - Presentation - 4:01
    • Activity 18 - Using the HLOOKUP Function - Reading
    • Activity 19 - Using the CONCAT Function - Reading
    • Activity 20 - Using the CONCAT Function - Exercise
    • Activity 21 - Exercise Solution - Using the CONCAT Function - Presentation - 2:28
    • Activity 22 - Using the TRANSPOSE Function - Reading
    • Activity 23 - Using the PROPER, UPPER, and LOWER Functions - Reading
    • Activity 24 - Using the PROPER Function - Exercise
    • Activity 25 - Exercise Solution - Using the PROPER Function - Presentation - 1:31
    • Activity 26 - Using the LEFT, RIGHT, and MID Functions - Reading
    • Activity 27 - Using the LEFT and RIGHT Functions - Exercise
    • Activity 28 - Exercise Solution - Using the LEFT and RIGHT Functions - Presentation - 2:48
    • Activity 29 - Using Date Functions - Reading
    • Activity 30 - Using the YEAR, MONTH, and DAY Functions - Exercise
    • Activity 31 - Exercise Solution - Using the YEAR, MONTH, and DAY Functions - Presentation - 2:22
    • Activity 32 - Creating Scenarios - Reading
    • Activity 33 - Advanced Formulas Quiz - Quiz
  • Lesson 2 - Working with Lists
    • Activity 1 - Converting a List to a Table - Reading
    • Activity 2 - Converting a List to a Table - Exercise
    • Activity 3 - Exercise Solution - Converting a List to a Table - Presentation - 2:15
    • Activity 4 - Removing Duplicates from a List - Reading
    • Activity 5 - Removing Duplicates from a List - Exercise
    • Activity 6 - Exercise Solution - Removing Duplicates from a List - Presentation - 1:33
    • Activity 7 - Sorting Data in a List - Reading
    • Activity 8 - Review of Sorting Data in a List - Presentation - 2:06
    • Activity 9 - Sorting Data in a List - Exercise
    • Activity 10 - Exercise Solution - Sorting Data in a List - Presentation - 2:09
    • Activity 11 - Filtering Data in a List - Reading
    • Activity 12 - Filtering Data in a List - Exercise
    • Activity 13 - Exercise Solution - Filtering Data in a List - Presentation - 3:20
    • Activity 14 - Adding Subtotals to a List - Reading
    • Activity 15 - Adding Subtotals to a List - Exercise
    • Activity 16 - Exercise Solution - Adding Subtotals to a List - Presentation - 1:49
    • Activity 17 - Working with Lists Quiz - Quiz
  • Lesson 3 - Working with Illustrations
    • Activity 1 - Working with Clip Art - Reading
    • Activity 2 - Working with Clip Art - Exercise
    • Activity 3 - Exercise Solution - Working with Clip Art - Presentation - 1:41
    • Activity 4 - Using Shapes - Reading
    • Activity 5 - Adding Shapes - Exercise
    • Activity 6 - Exercise Solution - Adding Shapes - Presentation - 1:09
    • Activity 7 - Working with Icons - Reading
    • Activity 8 - Working with SmartArt - Reading
    • Activity 9 - Using Office Ink - Reading
    • Activity 10 - Working with Illustrations in Excel Quiz - Quiz
  • Lesson 4 - Visualizing Your Data
    • Activity 1 - Using Charts - Reading
    • Activity 2 - New Charts - Reading
    • Activity 3 - Inserting Charts - Reading
    • Activity 4 - Review of Inserting Charts - Presentation - 3:09
    • Activity 5 - Using the Chart Recommendation Feature - Reading
    • Activity 6 - Inserting Charts - Exercise
    • Activity 7 - Exercise Solution - Inserting Charts - Presentation - 2:16
    • Activity 8 - Editing Charts - Reading
    • Activity 9 - Review of Editing Charts - Presentation - 1:55
    • Activity 10 - Using Chart Tools - Reading
    • Activity 11 - Using the Quick Analysis Tool - Reading
    • Activity 12 - Editing Charts - Exercise
    • Activity 13 - Exercise Solution - Editing Charts - Presentation - 3:06
    • Activity 14 - Add and Format Objects - Reading
    • Activity 15 - Create a Custom Chart Template - Reading
    • Activity 16 - Visualizing Your Data Quiz - Quiz
  • Lesson 5 - Working with Tables
    • Activity 1 - Format Data as a Table - Reading
    • Activity 2 - Formatting Your Data as a Table - Presentation - 1:29
    • Activity 3 - Move between Tables and Ranges - Reading
    • Activity 4 - Modify Tables - Reading
    • Activity 5 - Define Titles - Reading
    • Activity 6 - Creating and Modifying a Table in Excel - Exercise
    • Activity 7 - Exercise Solution - Creating and Modifying a Table in Excel - Presentation - 1:37
    • Activity 8 - Working with Tables in Excel Quiz - Quiz
  • Lesson 6 - Advanced Formatting
    • Activity 1 - Applying Conditional Formatting - Reading
    • Activity 2 - Review of Applying Conditional Formatting - Presentation - 2:48
    • Activity 3 - Using Conditional Formatting - Exercise
    • Activity 4 - Exercise Solution - Using Conditional Formatting - Presentation - 5:51
    • Activity 5 - Working with Styles - Reading
    • Activity 6 - Review of Working with Styles - Presentation - 1:29
    • Activity 7 - Working with Styles - Exercise
    • Activity 8 - Exercise Solution - Working with Styles - Presentation - 2:19
    • Activity 9 - Creating and Modifying Templates - Reading
    • Activity 10 - Advanced Excel Formatting Quiz - Quiz
  • Lesson 7 - Intermediate Microsoft Excel 2019 Exam
    • Activity 1 - Intermediate Microsoft Excel 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
110

Advanced Microsoft PowerPoint 2019 Training

Master the More Advanced Features of PowerPoint 2019/365 Including Masters & Special Effects

By Webucator | in Online Courses

This Advanced Microsoft PowerPoint 2019 training class is for PowerPoint 2019 users who want to build upon their basic skills. Students will use advanced techniques such as working with Masters and Special Effects within their presentations in PowerPoint 2019 or PowerPoint 365. With 110 lectures, you'll be able to customize presentations, use SmartArt, add multimedia, set up slide shows, and more.

9/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 110 lectures & 1 hour of content 24/7
  • Create customized presentations w/ templates
  • Add special effects
  • Use the slide, notes, & handout masters
  • Create, edit, & import charts
  • Manage hyperlinks
  • Create custom shows
  • Secure & share presentations
Note: Software NOT included.

"As someone who uses PowerPoint but never had the time to really learn how valuable this resource can be, I was able to take this class and walk away feeling very confident in my abilities in PowerPoint." – Chris Deigan

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Basic PowerPoint experience
  • Prerequisite course: Introduction to Microsoft PowerPoint 2019 Training

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - Customizing Presentations
    • Activity 1 - Applying a Theme - Reading
    • Activity 2 - Applying a Background Style - Reading
    • Activity 3 - Adding a Footer - Reading
    • Activity 4 - Arranging and Printing Sections - Reading
    • Activity 5 - Customizing Presentation Overview - Presentation - 3:10
    • Activity 6 - Adding a Background Image - Reading
    • Activity 7 - Customizing Your Presentation - Exercise
    • Activity 8 - Exercise Solution - Customizing Your Presentation - Presentation - 2:31
    • Activity 9 - Customizing Presentations Quiz - Quiz
  • Lesson 2 - Presentation Masters
    • Activity 1 - Working with the Slide Master - Reading
    • Activity 2 - Slide Layouts - Reading
    • Activity 3 - Slide Layouts Review - Presentation - 1:43
    • Activity 4 - Formatting Slide Masters and Layouts - Reading
    • Activity 5 - Adding a Watermark to Your Presentation - Reading
    • Activity 6 - Adding Slide Numbers Using the Slide Master - Reading
    • Activity 7 - Inserting a New Slide Master - Reading
    • Activity 8 - Preserving a Slide Master - Reading
    • Activity 9 - Slide Master Review - Presentation - 3:24
    • Activity 10 - Modifying the Notes Master - Reading
    • Activity 11 - Modifying the Handout Master - Reading
    • Activity 12 - Adding a Header and Footer to Notes and Handouts - Reading
    • Activity 13 - Using the Slide Master - Exercise
    • Activity 14 - Exercise Solution - Using the Slide Master - Presentation - 2:24
    • Activity 15 - Presentation Masters Quiz - Quiz
  • Lesson 3 - Working with Special Effects
    • Activity 1 - Setting Animation Timing - Reading
    • Activity 2 - Animating a Chart - Reading
    • Activity 3 - Animating Text and Objects - Reading
    • Activity 4 - Motion Paths - Reading
    • Activity 5 - Slide Transitions - Reading
    • Activity 6 - Working with the Animation Painter - Reading
    • Activity 7 - Special Effects Review - Presentation - 4:00
    • Activity 8 - Applying Special Effects to a Presentation - Exercise
    • Activity 9 - Exercise Solution - Applying Special Effects to a Presentation - Presentation - 2:23
    • Activity 10 - Working with Special Effects - Quiz
  • Lesson 4 - Using SmartArt
    • Activity 1 - Inserting SmartArt Graphics - Reading
    • Activity 2 - Modifying SmartArt Graphics - Reading
    • Activity 3 - Resizing - Repositioning a SmartArt Object - Reading
    • Activity 4 - Inserting Text into a SmartArt Object - Reading
    • Activity 5 - Formatting Text in a SmartArt Object - Reading
    • Activity 6 - Adding Shapes to a SmartArt Object - Reading
    • Activity 7 - SmartArt Graphics Review - Presentation - 2:55
    • Activity 8 - Ungrouping SmartArt Objects - Reading
    • Activity 9 - Working with SmartArt - Exercise
    • Activity 10 - Exercise Solution - Working with SmartArt - Presentation - 2:10
    • Activity 11 - Using SmartArt Quiz - Quiz
  • Lesson 5 - Multimedia
    • Activity 1 - Creating a Photo Album - Reading
    • Activity 2 - Adding Captions - Reading
    • Activity 3 - Applying a Theme to Your Album - Reading
    • Activity 4 - Customizing an Album - Reading
    • Activity 5 - Photo Album Review - Presentation - 3:55
    • Activity 6 - Creating and Modifying a Photo Album - Exercise
    • Activity 7 - Exercise Solution - Creating and Modifying a Photo Album - Presentation - 2:47
    • Activity 8 - Inserting Sounds and Video - Reading
    • Activity 9 - Editing Media Clips - Reading
    • Activity 10 - Adding Video to a Presentation - Exercise
    • Activity 11 - Exercise Solution - Adding Video to a Presentation - Presentation - 2:14
    • Activity 12 - Multimedia Quiz - Quiz
  • Lesson 6 - Setting up the Slide Show
    • Activity 1 - Setting up a Custom Show - Reading
    • Activity 2 - Setting Up Slide Show Review - Presentation - 2:48
    • Activity 3 - Creating a Hyperlink - Reading
    • Activity 4 - Adding an Action Button - Reading
    • Activity 5 - Jumping to Another Presentation - Reading
    • Activity 6 - Presenting a Custom Show - Exercise
    • Activity 7 - Exercise Solution - Presenting a Custom Show - Presentation - 1:51
    • Activity 8 - Using Rehearse Timings - Reading
    • Activity 9 - Navigating within a Slide Show - Reading
    • Activity 10 - Annotating a Presentation - Reading
    • Activity 11 - Recording a Slide Show - Reading
    • Activity 12 - Setting Up a Slide Show to Repeat Automatically - Reading
    • Activity 13 - Preparing the Slide Show - Exercise
    • Activity 14 - Exercise Solution - Preparing the Slide Show - Presentation - 2:01
    • Activity 15 - Setting Up the Slide Show Quiz - Quiz
  • Lesson 7 - Outlines and Slides
    • Activity 1 - Exporting Notes and Handouts to Word - Reading
    • Activity 2 - Exporting an Outline to Word - Reading
    • Activity 3 - Saving a Presentation as an Outline - Reading
    • Activity 4 - Outlines Review - Presentation - 1:57
    • Activity 5 - Saving a Slide as a Graphic - Reading
    • Activity 6 - Exporting an Outline to Word - Exercise
    • Activity 7 - Exercise Solution - Exporting an Outline to Word - Presentation - 1:14
    • Activity 8 - Outlines and Slides Quiz - Quiz
  • Lesson 8 - Managing Multiple Presentations
    • Activity 1 - Merging Multiple Presentations - Reading
    • Activity 2 - Reusing Slides from Other Presentations - Reading
    • Activity 3 - Merging Presentations Review - Presentation - 1:57
    • Activity 4 - Viewing Multiple Presentations - Reading
    • Activity 5 - Tracking Changes in PowerPoint - Reading
    • Activity 6 - Reviewing Changes in PowerPoint - Exercise
    • Activity 7 - Exercise Solution - Reviewing Changes - Presentation - 1:27
    • Activity 8 - Managing Multiple Presentations Quiz - Quiz
  • Lesson 9 - Sharing and Securing a Presentation
    • Activity 1 - Sharing a Presentation with a Remote Audience - Reading
    • Activity 2 - Embedding the Fonts in a Presentation - Reading
    • Activity 3 - Sharing Presentations Review - Presentation - 1:27
    • Activity 4 - Inspecting the Presentation - Reading
    • Activity 5 - Using Comments - Reading
    • Activity 6 - Packaging a Presentation for CD - Reading
    • Activity 7 - Using the PowerPoint Viewer - Reading
    • Activity 8 - Sharing a Presentation - Exercise
    • Activity 9 - Encrypting a Presentation - Reading
    • Activity 10 - Adding a Digital Signature - Reading
    • Activity 11 - Marking a Presentation as Final - Reading
    • Activity 12 - Compressing Pictures - Reading
    • Activity 13 - Sending a Presentation in PDF Format - Reading
    • Activity 14 - Securing a Presentation - Exercise
    • Activity 15 - Exercise Solution - Securing a Presentation - Presentation - 1:37
    • Activity 16 - Sharing and Securing a Presentation Quiz - Quiz
  • Lesson 10 - Cloud
    • Activity 1 - Using the Cloud - Reading
    • Activity 2 - Using the Cloud - Exercise
    • Activity 3 - Cloud Review - Presentation - 2:43
    • Activity 4 - Cloud Quiz - Quiz
  • Lesson 11 - Advanced Microsoft PowerPoint 2019 Exam
    • Activity 1 - Advanced Microsoft PowerPoint 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
78

Advanced Microsoft Excel 2019 Training

Use Excel 2019 to Your Advantage & Work on More Critical Functions Including Data Tools, Macros, Pivot Tables, and More

By Webucator | in Online Courses

Already comfortable using Microsoft Excel 2019 or Excel 365 and ready to become an Excel expert? Take your skills to the next level in this Advanced Excel course. Learn Excel's most powerful and advanced tools, including PivotTables, PivotCharts, Macros, and more. You will gain skills for better collaboration, including password protection and tracking changes, learn to audit worksheets, validate data to ensure consistency, and use other essential business tools in Microsoft Excel.

9.7/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 78 lectures & 1 hour of content 24/7
  • Create pivot tables & charts
  • Learn to trace precedents & dependents
  • Convert text & validate and consolidate data
  • Collaborate w/ others by protecting worksheets & workbooks
  • Create, use, edit & manage macros
  • Import & export data
Note: Software NOT included.

"The instructor's explanations were clear, concise and relevant. I learned so much from this course that I will be able to implement immediately to expedite my data analysis process." – Glenda Pinckney, United Postal Service

"Our instructor knows everything there is to know about Excel & was an excellent teacher. She kept the class engaged the entire time." – Kerry Novak, COTG – A Xerox Company

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

  • Basic & intermediate Excel experience
  • Pre-requisite courses
    • Introduction to Microsoft Excel 2019 Training
    • Intermediate Microsoft Excel 2019 Training

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - Using Pivot Tables
    • Activity 1 - What Are Pivot Tables_ - Reading
    • Activity 2 - Creating Pivot Tables - Reading
    • Activity 3 - Review of Creating Pivot Tables - Presentation - 2:21
    • Activity 4 - More PivotTable Functionality - Reading
    • Activity 5 - Inserting Slicers - Reading
    • Activity 6 - Multi-Select Option in Slicers - Reading
    • Activity 7 - Review of Inserting Slicers - Presentation - 2:14
    • Activity 8 - PivotTable Enhancements - Reading
    • Activity 9 - Working with Pivot Tables - Reading
    • Activity 10 - Inserting Pivot Charts - Reading
    • Activity 11 - More Pivot Table Functionality - Reading
    • Activity 12 - Working with Pivot Tables - Exercise
    • Activity 13 - Exercise Solution - Working with Pivot Tables - Presentation - 4:35
    • Activity 14 - Using Pivot Tables Quiz - Quiz
  • Lesson 2 - Auditing Worksheets
    • Activity 1 - Formatting Auditing Commands - Reading
    • Activity 2 - Tracing Precedents - Reading
    • Activity 3 - Tracing Precedents - Exercise
    • Activity 4 - Exercise Solution - Tracing Precedents - Presentation - 2:44
    • Activity 5 - Tracing Dependents - Reading
    • Activity 6 - Tracing Dependents - Exercise
    • Activity 7 - Exercise Solution - Tracing Dependents - Presentation - 1:26
    • Activity 8 - Showing Formulas - Reading
    • Activity 9 - Auditing Worksheets Quiz - Quiz
  • Lesson 3 - Data Tools
    • Activity 1 - Converting Text to Columns - Reading
    • Activity 2 - Review of Converting Text to Columns - Presentation - 2:09
    • Activity 3 - Converting Text to Columns - Exercise
    • Activity 4 - Exercise Solution - Converting Text to Columns - Presentation - 2:09
    • Activity 5 - Linking to External Data - Reading
    • Activity 6 - Controlling Calculation Options - Reading
    • Activity 7 - Data Validation - Reading
    • Activity 8 - Review of Data Validation - Presentation - 2:53
    • Activity 9 - Using Data Validation - Exercise
    • Activity 10 - Exercise Solution - Using Data Validation - Presentation - 3:53
    • Activity 11 - Consolidating Data - Reading
    • Activity 12 - Consolidating Data - Exercise
    • Activity 13 - Exercise Solution - Consolidating Data - Presentation - 2:33
    • Activity 14 - Goal Seek - Reading
    • Activity 15 - Using Goal Seek - Exercise
    • Activity 16 - Exercise Solution - Using Goal Seek - Presentation - 4:48
    • Activity 17 - Data Tools Quiz - Quiz
  • Lesson 4 - Working with Others
    • Activity 1 - Protecting Worksheets and Workbooks - Reading
    • Activity 2 - Password Protecting a Workbook - Exercise
    • Activity 3 - Exercise Solution - Password Protecting a Workbook - Presentation - 1:30
    • Activity 4 - Password Protecting a Worksheet - Exercise
    • Activity 5 - Exercise Solution - Password Protecting a Worksheet - Presentation - 1:33
    • Activity 6 - Password Protecting Ranges in a Worksheet - Exercise
    • Activity 7 - Exercise Solution - Password Protecting Ranges in a Worksheet - Presentation - 1:26
    • Activity 8 - Marking a Workbook as Final - Reading
    • Activity 9 - Working with Others Quiz - Quiz
  • Lesson 5 - Recording and Using Macros
    • Activity 1 - Recording Macros - Reading
    • Activity 2 - Review of Recording Macros - Presentation - 1:42
    • Activity 3 - Recording a Macro - Exercise
    • Activity 4 - Exercise Solution - Recording a Macro - Presentation - 2:03
    • Activity 5 - Running Macros - Reading
    • Activity 6 - Editing Macros - Reading
    • Activity 7 - Adding Macros to the Quick Access Toolbar - Reading
    • Activity 8 - Adding a Macro to the Quick Access Toolbar - Exercise
    • Activity 9 - Exercise Solution - Adding a Macro to the Quick Access Toolbar - Presentation - 1:04
    • Activity 10 - Recording and Using Macros Quiz - Quiz
  • Lesson 6 - Random Useful Items
    • Activity 1 - Sparklines - Reading
    • Activity 2 - Review of Using Sparklines - Presentation - 2:32
    • Activity 3 - Inserting and Customizing Sparklines - Exercise
    • Activity 4 - Exercise Solution - Inserting and Customizing Sparklines - Presentation - 3:26
    • Activity 5 - Using Microsoft Translator - Reading
    • Activity 6 - Preparing a Workbook for Internationalization and Accessibility - Reading
    • Activity 7 - Importing and Exporting Files - Reading
    • Activity 8 - Importing Text Files - Exercise
    • Activity 9 - Exercise Solution - Importing Text Files - Presentation - 2:32
    • Activity 10 - Copying Data from Excel to Word - Exercise
    • Activity 11 - Exercise Solution - Copying Data from Excel to Word - Presentation - 1:25
    • Activity 12 - Copying Charts from Excel to Word - Exercise
    • Activity 13 - Exercise Solution - Copying Charts from Excel to Word - Presentation - 1:07
    • Activity 14 - Excel Random Useful Items Quiz - Quiz
  • Lesson 7 - Cloud
    • Activity 1 - Using the Cloud - Reading
    • Activity 2 - Using the Cloud - Exercise
    • Activity 3 - Cloud Review - Presentation - 2:07
  • Lesson 8 - Advanced Microsoft Excel 2019 Exam
    • Activity 1 - Advanced Microsoft Excel 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
76

Advanced Microsoft Word 2019 Training

Master the Use of MS Word as a Whole with More Advanced Techniques: Footnotes, Comments, Mail Merge & More

By Webucator | in Online Courses

Choose this Microsoft Word course if you are already very comfortable working in Microsoft Word 2019 or Word 365, and are ready to learn some of the more advanced features. With 76 lectures, you will learn how to collaborate with others in Microsoft Word, how to compare and combine documents and how to do mail merges. In this Word training course you will also learn to protect documents, to use bookmarks, and to add a table of contents to your documents, and much more.

9.4/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 76 lectures & 1 hour of content 24/7
  • Work w/ tables of contents, footnotes & endnotes
  • Insert bibliographies & indexes
  • Use comments, track changes including accepting & rejecting changes
  • Compare & combine documents
  • Use Mail Merge & create envelopes and labels
  • Protect documents
  • Use bookmarks, add watermarks, & customize the Ribbon
Note: Software NOT included.

"This was a very informative class. I've been an admin for 20 years and while I knew several things covered, it was well worth my time for the things I DIDN'T know." – Casandra Zessin, Farnsworth Group, Inc.

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

  • Intermediate Microsoft Word experience

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - Working with Long Documents
    • Activity 1 - Adding a Table of Contents - Reading
    • Activity 2 - Updating the Table of Contents - Reading
    • Activity 3 - Deleting the Table of Contents - Reading
    • Activity 4 - Table of Contents Review - Presentation - 2:30
    • Activity 5 - Insert and Update a Table of Contents - Exercise
    • Activity 6 - Exercise Solution - Insert and Update a Table of Contents - Presentation - 2:01
    • Activity 7 - Footnotes and Endnotes - Reading
    • Activity 8 - Working with Footnotes - Exercise
    • Activity 9 - Inserting Citations and a Bibliography - Reading
    • Activity 10 - Insert Citations and a Bibliography - Exercise
    • Activity 11 - Adding an Index - Reading
    • Activity 12 - Inserting an Index - Exercise
    • Activity 13 - Inserting a Table of Figures - Reading
    • Activity 14 - Inserting and Updating a Table of Authorities - Reading
    • Activity 15 - Creating an Outline - Reading
    • Activity 16 - Working with Long Documents Quiz - Quiz
  • Lesson 2 - Review and Collaborating on Documents
    • Activity 1 - Adding Comments - Reading
    • Activity 2 - Comments Review - Presentation - 2:26
    • Activity 3 - Adding Comments to a Document - Exercise
    • Activity 4 - Exercise Solution - Adding Comments to a Document - Presentation - 2:11
    • Activity 5 - Tracking Changes - Reading
    • Activity 6 - Tracking Changes - Exercise
    • Activity 7 - Exercise Solution - Tracking Changes - Presentation - 1:52
    • Activity 8 - Viewing Changes, Additions, and Comments - Reading
    • Activity 9 - Viewing Markup - Exercise
    • Activity 10 - Exercise Solution - Viewing Markup - Presentation - 3:54
    • Activity 11 - Accepting and Rejecting Changes - Reading
    • Activity 12 - Accepting and Rejecting Changes - Exercise
    • Activity 13 - Exercise Solution - Accepting and Rejecting Changes - Presentation - 2:54
    • Activity 14 - Reviewing and Collaborating on Documents Quiz - Quiz
  • Lesson 3 - Comparing and Combining Documents
    • Activity 1 - Comparing Documents - Reading
    • Activity 2 - Comparing Documents - Exercise
    • Activity 3 - Combining Documents - Reading
    • Activity 4 - Combining Documents - Exercise
    • Activity 5 - Comparing and Combining Documents Review - Presentation - 2:26
    • Activity 6 - Comparing and Combining Documents Quiz - Quiz
  • Lesson 4 - Managing Mailings
    • Activity 1 - Creating Envelopes and Labels - Reading
    • Activity 2 - Envelopes and Labels Review - Presentation - 2:36
    • Activity 3 - Printing an Envelope - Exercise
    • Activity 4 - Exercise Solution - Printing an Envelope - Presentation - 1:23
    • Activity 5 - Using Mail Merge - Reading
    • Activity 6 - Using Mail Merge - Exercise
    • Activity 7 - Exercise Solution - Mail Merge - Presentation - 4:30
    • Activity 8 - Managing Mailings Quiz - Quiz
  • Lesson 5 - Protecting Documents
    • Activity 1 - Making Word Documents Read Only - Reading
    • Activity 2 - Password Protect Word Documents - Reading
    • Activity 3 - Removing Metadata from Files - Reading
    • Activity 4 - Restrict Formatting and Editing - Reading
    • Activity 5 - Protecting Documents Review - Presentation - 2:25
    • Activity 6 - Protecting a Document - Exercise
    • Activity 7 - Exercise Solution - Protecting a Document - Presentation - 2:26
    • Activity 8 - Protecting Documents Quiz - Quiz
  • Lesson 6 - Random Useful Items
    • Activity 1 - Using Bookmarks - Reading
    • Activity 2 - Using Bookmarks - Exercise
    • Activity 3 - Exercise Solution - Using Bookmarks - Presentation - 2:11
    • Activity 4 - Adding Watermarks - Reading
    • Activity 5 - Review of Using Watermarks - Presentation - 1:53
    • Activity 6 - Adding Custom Watermarks - Exercise
    • Activity 7 - Exercise Solution - Adding Custom Watermarks - Presentation - 1:07
    • Activity 8 - Adding Titles to Sections - Reading
    • Activity 9 - Inserting Built-in Fields - Reading
    • Activity 10 - Using the Go To Feature - Reading
    • Activity 11 - Using Macros - Reading
    • Activity 12 - Recording a Macro - Exercise
    • Activity 13 - Exercise Solution - Recording a Macro - Presentation - 1:41
    • Activity 14 - Customizing the Ribbon - Reading
    • Activity 15 - Customizing the Ribbon - Exercise
    • Activity 16 - Exercise Solution - Customizing the Ribbon - Presentation - 1:57
    • Activity 17 - Preparing a Document for Internationalization and Accessibility - Reading
    • Activity 18 - Using the Cloud - Reading
    • Activity 19 - Using the Cloud - Exercise
    • Activity 20 - Exercise Solution - Using the Cloud - Presentation - 1:48
    • Activity 21 - Sharing - Reading
    • Activity 22 - Word Random Useful Items Quiz - Quiz
  • Lesson 7 - Advanced Microsoft Word 2019 Exam
    • Activity 1 - Advanced Microsoft Word 2019 Exam - Exam

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
44

Advanced Microsoft Access 2019

Improve Existing Access Databases & Eventually Design Databases at an Advanced Level

By Webucator | in Online Courses

Take your skills to the next level in this Advanced Access course. Your expert instructor will take you into the finer points of Access 2019 or Access 365, showing you the powerful features that many Access users never learn to take advantage of. After taking this course, you'll have a better understanding of how tables relate to each other within a database, and you will be able to use that knowledge to create more sophisticated queries, forms, and reports. You will also learn to work with macros and create a navigation form.

9.8/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 44 lectures & 1 hour of content 24/7
  • Learn about database relationships
  • Work w/ table relationships
  • Work w/ queries, forms, reports & macros at an advanced level
  • Complete the desktop application w/ the navigation form
Note: Software NOT included.

"Great class! Cleared all my previous doubts related to the application and gave me a very good sense of how information flows in the application!" – Neeraj Jain

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

  • Introductory-level knowledge and skills working with Microsoft Access

Course Outline

  • Lesson 1 - Relationships
    • Activity 1 - Review - Reading
    • Activity 2 - Referential Integrity - Reading
    • Activity 3 - Relationships - Reading
    • Activity 4 - Relationships - Presentation - 4:52
    • Activity 5 - A Few Words about Naming Conventions - Reading
    • Activity 6 - Creating Relationships - Exercise
    • Activity 7 - Review_ Creating Relationships - Presentation - 7:02
    • Activity 8 - Relationship Quiz - Quiz
  • Lesson 2 - Queries
    • Activity 1 - Query Design View - Reading
    • Activity 2 - Review of Select Queries - Reading
    • Activity 3 - Review of Select Queries - Presentation - 4:40
    • Activity 4 - Review of Select Queries with Criteria - Reading
    • Activity 5 - Review of Select Queries with Criteria - Presentation - 4:22
    • Activity 6 - Logical Operators - Reading
    • Activity 7 - Parameter Queries - Reading
    • Activity 8 - Parameter Queries - Presentation - 4:22
    • Activity 9 - Action Queries - Reading
    • Activity 10 - Action Queries - Presentation - 12:50
    • Activity 11 - Creating Select and Action Queries - Exercise
    • Activity 12 - Review_ Creating Select and Action Queries - Presentation - 3:40
    • Activity 13 - Creating a Parameter Query - Exercise
    • Activity 14 - Review_ Creating a Parameter Query - Presentation - 3:52
    • Activity 15 - Queries Advanced Quiz - Quiz
  • Lesson 3 - Table Functions
    • Activity 1 - Importing Data - Reading
    • Activity 2 - Importing Data - Presentation - 4:36
    • Activity 3 - Linking Tables from External Sources - Reading
    • Activity 4 - Import tables from other Databases - Reading
    • Activity 5 - Other Sources - Presentation - 4:41
    • Activity 6 - Tables from Templates and Application Parts - Reading
    • Activity 7 - Importing Data from Excel - Exercise
    • Activity 8 - Exercise Review_ Importing Data from Excel - Presentation - 2:41
    • Activity 9 - Exporting Data - Reading
    • Activity 10 - Exporting Data - Presentation - 5:22
    • Activity 11 - Exporting Data to Excel - Exercise
    • Activity 12 - Review_ Exporting Data to Excel - Presentation - 2:29
    • Activity 13 - Table Function Quiz - Quiz
  • Lesson 4 - Advanced Forms
    • Activity 1 - Design View - Reading
    • Activity 2 - Design View - Presentation - 9:56
    • Activity 3 - Formatting - Reading
    • Activity 4 - Editing a Form - Presentation - 7:49
    • Activity 5 - Tab Order - Reading
    • Activity 6 - Create Forms with Application Parts - Reading
    • Activity 7 - Creating a Subform - Reading
    • Activity 8 - Creating a Subform - Presentation - 3:34

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
54

Advanced Microsoft Outlook 2019

Build On Your Basic Skills & Learn Higher Level Skills in Outlook

By Webucator | in Online Courses

Already comfortable using Microsoft Outlook? Take your skills to the next level in this Advanced Outlook course. This training class builds on basic skills in Outlook 2019 or Outlook 365 and teaches students to work with some of the more advanced features of Outlook. You will learn to work with tasks, notes, signatures, and themes, to manage your inbox using filtering, search folders, and archives, and to work with multiple accounts in Outlook.

10/10 student rating: ★ ★ ★ ★ ★ ★ ★ ★ ★ ★

  • Access 54 lectures & 1 hour of content 24/7
  • Work w/ tasks & notes
  • Work w/ signatures & themes
  • Manage your inbox including filtering, creating search folders, & archiving
  • Work w/ multiple accounts
Note: Software NOT included.

Webucator | Certified Microsoft Partner | Registered Education Provider

Webucator is a global training company founded in 2003 that has trained over 60,000 students. They provide onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations are a Microsoft Certified Partner for Learning Solutions (CPLS).

64,442 Total Students

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

  • Familiarity with Windows.
  • Introductory level knowledge of Outlook

Course Outline

  • Setup
    • Setup for Your Class
  • Lesson 1 - Working with Tasks and Notes
    • Activity 1 - Create a Task - Reading
    • Activity 2 - Print a Task - Reading
    • Activity 3 - Update a Task - Reading
    • Activity 4 - Search for Tasks - Reading
    • Activity 5 - Review of Using Tasks - Presentation - 2:40
    • Activity 6 - Assign a Task - Reading
    • Activity 7 - Reply to a Task Request - Reading
    • Activity 8 - Track Tasks - Reading
    • Activity 9 - Change Your Task View - Reading
    • Activity 10 - Review of Changing Your Task View - Presentation - 1:12
    • Activity 11 - Working with Tasks - Exercise
    • Activity 12 - Exercise Solution - Working with Tasks - Presentation - 1:57
    • Activity 13 - Work with Notes - Reading
    • Activity 14 - Working with Tasks and Notes Quiz - Quiz
  • Lesson 2 - Using Signature and Themes
    • Activity 1 - Create a Signature - Reading
    • Activity 2 - Automatically Add a Signature to Messages - Reading
    • Activity 3 - Modify a Signature - Reading
    • Activity 4 - Review of Creating and Adding a Signature - Presentation - 2:53
    • Activity 5 - Format Outgoing Messages - Reading
    • Activity 6 - Create and Apply a Theme - Reading
    • Activity 7 - Adding a Theme and Signature to Your Messages - Exercise
    • Activity 8 - Exercise Solution - Adding a Theme and Signature to Your Messages - Presentation - 2:28
    • Activity 9 - Using Signatures and Themes Quiz - Quiz
  • Lesson 3 - Managing Your Inbox
    • Activity 1 - Search for Messages - Reading
    • Activity 2 - Review of Searching for Messages - Presentation - 1:25
    • Activity 3 - Create Search Folders - Reading
    • Activity 4 - Sort Messages - Reading
    • Activity 5 - Add New Local Folders - Reading
    • Activity 6 - Move Messages between Folders - Reading
    • Activity 7 - Group Your Mailbox Items - Reading
    • Activity 8 - Filter Messages - Reading
    • Activity 9 - Review of Filtering Messages - Presentation - 1:19
    • Activity 10 - Organize Messages - Reading
    • Activity 11 - Create and Manage Rules - Reading
    • Activity 12 - Organizing Your Messages - Exercise
    • Activity 13 - Manage Your Junk Email - Reading
    • Activity 14 - Archive Your Messages - Reading
    • Activity 15 - Create an Outlook Data File - Reading
    • Activity 16 - Create a Quick Step - Reading
    • Activity 17 - Review of Creating a Quick Step - Presentation - 1:50
    • Activity 18 - Add Protection to Your Outgoing Messages - Reading
    • Activity 19 - Create Auto-Replies - Reading
    • Activity 20 - Managing Your Mail By Creating a Quick Step - Exercise
    • Activity 21 - Exercise Solution - Managing Your Mail by Creating a Quick Step - Presentation - 1:50
    • Activity 22 - Managing Your Inbox Quiz - Quiz
  • Lesson 4 - Working with Multiple Email Accounts
    • Activity 1 - Setting Up Multiple Accounts in Outlook - Reading
    • Activity 2 - Send Emails from Different Accounts - Reading
    • Activity 3 - Review of Sending Email from Different Accounts - Presentation - 1:29
    • Activity 4 - POP vs. IMAP Email Programs - Reading
    • Activity 5 - Working with Multiple Email Accounts - Exercise
    • Activity 6 - Exercise Solution - Working with Multiple Email Accounts - Presentation - 1:52
    • Activity 7 - Working with Multiple Email Accounts Quiz - Quiz
  • Lesson 5 - Advanced Microsoft Outlook 2019 Exam
    • Activity 1 - Advanced Microsoft Outlook 2019 Exam - Exam

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.