Microsoft Office 2016 Essential Training: 9 Course Bundle

Comprehensive, all-in-one training to get the most out of Microsoft Office 2016. 9-in-1 courses with 70 hours of video.

4.50 (898 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Microsoft Office 2016 Essential Training: 9 Course Bundle
7,095
students
68 hours
content
Sep 2022
last update
$99.99
regular price

What you will learn

Discover new and improved features in Excel 2016, Word, PowerPoint, OneNote & Access.

How to effectively use Excel 2016 on a touchscreen device.

How create, save, and open a workbook.

Learn how to personalize your use of Excel using Excel Options.

How to use and how to customize the Quick Access Toolbar.

Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.

The basics of entering and editing data in a workbook.

Learn practical methods in which you can backup and recover your Excel spreadsheets.

Effectively use autofill and flashfill so you are more productive.

Discover the essentials of using fomulas and functions.

How to rename, insert, move, and reference an Excel 2016 worksheet.

Discover how to create charts and graphs

Learn practical methods to sort and filter your data

How to protect and secure your Excel data

Learn presentation tips for an effective presentation

Discover how to format text on a PowerPoint slide

Learn how to insert shapes, graphics and pictures to add some "zing" to your presentation

Add charts, graphs and tables to present information in a non-text format

Wow your audience by adding animations, audio and video

Discover practical tips to present your presentation to your audience

Learn time saving techniques including how to copy slides, and exporting your presentation

Customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon

Master the most common uses of Word

How to controlling page appearance including using columns, indents, footers, borders and watermarks

Learn to create many types of documents

How to create a mail merge

Printing envelopes and labels

Discover different page setup options

How to protect your document from changes

Learn how to spell check your documents

Insert pictures and graphics in your Word document

Discover how to insert and edit tables

Using "Go To, Find, and Replace"

How to create, save and open documents

Learn cool tips and tricks in the Ribbon

Discover common Excel hotkeys

How to use VLOOKUP and HLOOKUP

Learn how to use popular functions

Discover how to use named ranges

Discover the power of Dynamic Formulas and how to use them

Get advanced level tips for creating awesome charts and graphs

How to work with and analyze your data using data slicers, PivotTables, Power Query and PivotCharts

Sorting information and running queries

Creating tables and relationships

Learn valuable new skills for complex data projects at work

Discover how to into import data from Excel

Learn Queries, use validations, how to create and print reports

Dive into options for packaging your application for distribution

Share notebooks and collaborate with others

Integrate OneNote with Microsoft Outlook

How to use the OneNote interface

Tag your notes and how to search them

Use handwriting in OneNote

How to protect your notes

Description

Unlock the Power Of Microsoft Office 2016 and Watch Your Productivity Soar!

  • A KILLER TIME & MONEY SAVER! Equip yourself with in-depth knowledge of online Microsoft 2016 training courses and save precious time on class attendance! Get the skills required to skyrocket your performance at the classroom or the office with a COMPLETE bundle of 9 online courses that will turn you into a pro computer user from the convenience of your own home!

  • THE PERFECT CHOICE FOR BEGINNERS OR ADVANCED USERS! Whether you already know enough on the most popular Microsoft programs or you are an absolute beginner, this is the product for you! Get hands-on experience in using Access, Excel, OneNote, PowerPoint, and Word 2016 and meet your full potential on the demanding work market!

  • WE ARE REVOLUTIONIZING ONLINE LEARNING! With our long expertise in STRESS-FREE e- learning, at Simon Sez IT we know how to help you make the most of your home learning! Get ALL practice you need with the EXERCISE FILES, find useful info in the comprehensive VIDEO TUTORIALS, keep TRACK OF YOUR PROGRESS and get the CERTIFICATES OF COMPLETION as reliable proof of your knowledge!

  • TURBOCHARGE YOUR SKILLS THE EASY WAY! Acquiring the MUST-HAVE skills for the modern market requirements has never been easier! Get ALL 9 online software courses in one GREAT VALUE FOR MONEY pack and plan your own training based on your specific time schedule! Flexible, easy to follow and eye-opening both for BEGINNERS and ADVANCED users, this Microsoft 2016 course bundle is made for smart e-learners!

  • A THOUGHTFUL GIFTING IDEA! If you are in search of a gift that will thrill every computer user, your quest is ending here! Offer your best friend, teenaged kid or office co-worker this stunning gift and help them open new horizons in their work! Equip their arsenal with the best Microsoft 2016 software bundle on the market and have them thankful for your excellent choice!

Do you feel embarrassed every time you are asked to make a file in Word, Excel or Access? 

Do you wish you could be a competent Microsoft Software user but are deterred by the COST and TIME spent on classes?

Are you looking for an EASY, CONVENIENT way to conquer solid knowledge on the most sought-after programs and skyrocket your work potential?

With expertise in the last advances in e-learning, Simon Sez IT is now offering you the ultimate e-learning software training tool in a COMPLETE 9 in 1 bundle!

We Are Turning You Into A Software Savvy From The Convenience Of Your Home!

You don’t have to spend a fortune on classes anymore; you can save yourself the time spent on commuting to training institutes!

We are making hands-on knowledge of 9 training courses a breeze, teaching you in your own SELF- PACED learning environment:

  1. Microsoft Excel 2016 - Beginners

  2. Microsoft Excel 2016 - Advanced

  3. Microsoft Word 2016

  4. Microsoft OneNote 2013:

  5. Microsoft PowerPoint 2016:

  6. Microsoft Access 2016 – Beginners

  7. Microsoft Access 2016 – Advanced

  8. Microsoft Essential VBA for Excel

  9. VBA Intermediate Training- Discover Excel Automation Secrets

Why Take This Course

Most work today happens on a computer – optimize your effort by learning useful software tips and tricks that you'll apply for decades to come! And that will save you valuable time, money, and effort.

Want to get noticed by your boss or earn the respect of your colleagues? Become the office superstar by becoming the go-to expert on everything related to MS Office 2016!

Individual video training for these programs would easily cost hundreds of dollars, but this 9-in-1 package is available at one unbelievably low price. Tremendous learning at tremendous savings.


Here’s what our students are saying…

“I'm really enjoying this course. I've done a little bit of work with Microsoft Office in the past but never really knew all the details and exactly what it can do and this course is excellent for showing me this. The instructor explains everything very clearly and at a perfect pace for me. And because this is videos I can also skip along if I get to things that I already know. A very good course indeed."

– Tracy Somers

"I signed up for this course to more fully understand office for my work. Even the beginner modules had a few pieces of information that were new and useful for me.."

– Joseph Ketellapper

"What a great course, nice calm voice, easy to understand.....    Lucky I have found this course, it is a life saver for me at my new job

–  Regina


** Updated November 2020. Introduction to OneNote live recording added

Content

Excel 2016: Introduction to Excel 2016 Beginner Course

Introduction
Essential Information for a Successful Training Experience
Course exercise files
Course demo files
Exercise Files
Downloadable Course Transcripts for Excel 2016 Beginner Course

Excel 2016: What's New

New and Improved Features in Excel 2016

Excel 2016: Using Touch

Overview of Principles of Using Touchscreen

Excel 2016: Getting Started

Creating and Saving a Workbook
Opening a Workbook

Excel 2016: Using Help

Online Help and Contextual Help

Excel 2016: Excel Options

Personalizing your use of Excel

Excel 2016: The Ribbon and Toolbars

Basics of using the Ribbon
Quick Access Toolbar
Tell Me Feature
Mini Toolbars and Contextual Menus
Status Bar

Excel 2016: Entering and Editing Data

Basics of Entering and Editing Data in a Workbook
Exercise 01
Formatting Dates
Formatting Numbers
Exercise 02

Excel 2016: Backup and Recovery

AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

Excel 2016: Fill and Series

Working with Fill and Series
Flash Fill

Excel 2016: Viewing and Printing

Workbook Views, Zoom, and Freeze
Printing
Exercise 03

Excel 2016: Cut, Copy, and Paste

Methods of Cutting, Copying, and Pasting

Excel 2016: Formatting a Worksheet

Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Alignment
Themes and Styles
Exercise 04

Excel 2016: Formulas and Functions

Basics of Fomulas and Functions
Complex Examples of Formulas
Exercise 05

Excel 2016: Managing Worksheets

Managing Worksheets

Excel 2016: Working with Multiple Workbooks

Working with Multiple Workbooks

Excel 2016: Saving Workbooks

Saving in Different File Types

Excel 2016: Proofing

The Spell Checker

Excel 2016: Inserting Comments

Inserting Comments
Exercise 06

Excel 2016: Basic Functions in Excel

The VLOOKUP Function
Text Functions
Date and Time Functions
Logical Functions

Excel 2016: Graphs and Charts

Creating Graphs and Charts
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
Exercise 07

Excel 2016: Sorting and Filtering Data

Managing Data by Sorting
Managing Date by Filtering
Customizing Tables

Excel 2016: Shapes and Pictures

Inserting Shapes and Pictures
Exercise 08

Excel 2016: Formatting Cells Based on Content

Conditional Formatting

Excel 2016: Protection and Security

Protecting Worksheets
Protecting Workbooks

Excel 2016: Naming Items

Giving Items Names
Exercise 09

Excel 2016: Finding and Replacing Words

Find and Replace

Excel 2016: Borders

Adding Borders

Excel 2016: Workbook Inspection

Inspecting a Workbook

Excel 2016: Privacy Options

Trust Center Privacy Options

Excel 2016: Sharing Options

Sharing a Workbook

Excel 2016: Wrap Up

Closing
Excel 2016 Quiz

Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

Prerequisites of the Course and Version of Excel
Essential Information for a Successful Training Experience
Excel 2016 Advanced Course Exercise Files
Excel 2016 Advanced Course Demo Files
Course Structure

Excel 2016 Advanced: Functions

Functions - Part 1
Functions - Part 2
Autosum

Excel 2016 Advanced: Date and Time Functions

How Date and Time Works
Basic Date and Time Functions
Complex Date and Time Functions

Excel 2016 Advanced: Text Functions

Using Text Functions - Part 1
Using Text Functions - Part 2

Excel 2016 Advanced: Logical Functions

Using Logical Functions
Exercise 01

Excel 2016 Advanced: Lookup Functions

HLOOKUP Function
VLOOKUP Function
Exercise 02

Excel 2016 Advanced: Financial Functions

Financial Functions and Terminology
Personal Financial Functions
Professional Financial Functions
Depreciation
Exercise 03

Excel 2016 Advanced: Statistical Functions

Statistical Functions for Description - Part 1
Statistical Functions for Description - Part 2
Statistical Functions for Forecasting - Part 1
Statistical Functions for Forecasting - Part 2
Exercise 04
One Click Forecasting
Statistical Functions for Inference

Excel 2016 Advanced: Connecting to External Data

Connecting to Other Workbooks
Connecting to Access Databases
Connecting to Web Data Sources
Get and Transform
Exercise 05

Excel 2016 Advanced: Tables

Introduction to Tables
Working with Tables
Table References
Table Styles
Exercise 06

Excel 2016 Advanced: Pivot Tables

Introduction to Pivot Tables
Working with Pivot Tables
Filters and Slicers
Pivot Charts
Exercise 07

Excel 2016 Advanced: Data Analysis

What If Analysis
Scenario Manager
Goal Seek
Solver
Exercise 08

Excel 2016: Graphs and Charts

Area Charts
Surface Charts
Radar Charts
Bubble Charts
Sparklines
Stock Charts
Exercise 09

Excel 2016 Advanced: Excel Web App

Web App - Part 1
Web App - Part 2

Excel 2016 Advanced: Conclusion

Closing Message
Excel 2016 Advanced - Quiz

PowerPoint 2016: Course Introduction

Welcome and Overview
Essential Information for a Successful Training Experience
Course exercise files
New Features in PowerPoint 2016
New features in PowerPoint 2016 for MAC

PowerPoint 2016: Overview

Navigate a PowerPoint Presentation
Overview of the Desktop Screen and Views
Exercise 01

PowerPoint 2016: Getting Started

Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Saving a Presentation
Exercise 02

PowerPoint 2016: Text and Bullet Editing Options

Formatting Text
Working with Bullets
Exercise 03

PowerPoint 2016: Adding Graphics to Your Presentation

Inserting Shapes
Inserting Graphics
Inserting Pictures
Exercise 04

PowerPoint 2016: Working with Objects

Selecting Objects
Editing Objects
Formatting Objects - Part 1
Formatting Objects - Part 2
Arranging Objects
Grouping Objects
Exercise 05

PowerPoint 2016: Working with Pictures

Picture Options
Cropping Pictures
Formatting Pictures
Things You Can Do with Pictures
Exercise 06

PowerPoint 2016: Working with SmartArt

Creating SmartArt
Modifying SmartArt
Creating a Flowchart Using SmartArt
Exercise 07

PowerPoint 2016: Working with Tables

Creating Tables
Formatting Tables
Inserting Tables
Exercise 08

PowerPoint 2016: Working with Charts

Adding Charts
Formatting Charts
Inserting Charts from MS Excel
Exercise 09

PowerPoint 2016: Masters

Using Masters
Changing Master Slides
Creating a New Master Design Template
Exercise 10

PowerPoint 2016: Other Working with Media

Adding Video to a Presentation
Adding Audio to a Presentation
Exercise 11

PowerPoint 2016: Transitions

Applying Transitions
Transition Options
Exercise 12

PowerPoint 2016: Animation

Animating an Object
Effect Options
Working with the Animation Pane
Motion Paths
Triggers
Exercise 13

PowerPoint 2016: Hyperlinks and Action Buttons

Working with Action Buttons
Working with Hyperlinks
Exercise 14

PowerPoint 2016: Slideshow Options

Onscreen Presentation Options
Hiding Slides
Changing the order of slides
Copying slides
Slideshow Options
Exercise 15

PowerPoint 2016: Preparing a Presentation for Delivery

Rehearse Timings
Recording a Presentation
Slide Show Settings
Creating a Custom Slide Show
Exercise 16

PowerPoint 2016: Other PowerPoint Features

Exporting options
Working with the Backstage View & Customization Options
Customizing the Ribbon
Printing a presentation
Exercise 17

PowerPoint 2016:Conclusion

Conclusion
PowerPoint 2016 - Quiz

Word 2016: Introduction

Welcome and Overview
Essential Information for a Successful Training Experience
Course exercise files
What's New in Word 2016
Overview of MS Word Screen
Backstage View

Word 2016: Getting Started with Word

Creating a New Blank Document
Working with Non-Printing Characters and Line Spacing Basics
Saving a Document
Opening a Document
Navigating in a Document
Go To, Find, and Replace
Editing a Document
Section 2 Practice Exercise

Word 2016: Character Formatting

AutoCorrect Options
Selecting text
Cut, Copy & Paste
Character Formatting Options
Format Painter
Working with numbers
Working with bullets
Creating an Outline
Section 3 Practice Exercise

Word 2016: Paragraph Formatting

Alignment Options
Line Spacing Options
Working with Indents
Working with Tabs
Section 4 Practice Exercise

Word 2016: Managing Lists

Sorting a List

Word 2016: Tables

Working with Tables
Creating a Table
Adding Rows and Columns to a Table
Formatting Table Data
Borders & Shading
Sorting in a Table
Drawing a Table
Converting Existing Data to a Table
Quick Tables
Using Formula in Tables
Section 6 Practice Exercise

Word 2016: Styles

Working with Styles
Creating Styles
Editing Styles
Section 7 Practice Exercise

Word 2016: Controlling Page Appearance

Working with Page Breaks
Working with Columns
Adding a Watermark
Applying Page Borders
Headers & Footers
Section 8 Practice Exercise

Word 2016: Sectioning

What is Sectioning?
Sectioning a Document
Odd and Even Sections
Section 9 Practice Exercise

Word 2016: Graphics

Inserting Pictures
Inserting Pictures into Existing Documents
Picture Options
Working with Shapes
Other Graphic Options
Section 10 Practice Exercise

Word 2016: Envelopes & Labels

Working with Envelopes
Working with Labels

Word 2016: Mail Merges

What is Mail Merge?
Creating a Mail Merge Document - Part 1
Creating a Mail Merge Document - Part 2
Merging a Document with an Existing Data Source
Sorting and Filtering Images
Merging Envelopes and Labels
Merging a Directory
Section 12 Practice Exercise

Word 2016: Quick Parts

Building Blocks
Creating and Editing Building Blocks
Auto Text
Section 13 Practice Exercise

Word 2016: Indexing and Table of Contents

Creating an Index
Creating a Table of Contents
Section 14 Practice Exercise

Word 2016: Review and Printing

Using the Thesaurus
Spell Check
Comments
Margins
Page Setup Options
Printing
Section 15 Practice Exercise

Word 2016: Other Word Features

Word Options
Protecting a Document
Macros

Word 2016: Wrap Up

Closing
Word 2016 - Quiz

OneNote 2016: Introduction

Course Overview & Structure
Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files

OneNote 2016: Workspace

OneNote Workspace Overview
Backstage View and Options
Adding Content

OneNote 2016: Managing Notes

Managing Notes - Part 1
Exercise 01
Managing Notes - Part 2

OneNote 2016: Backup and Restore

Backup & Restore

OneNote 2016: Printing

Printing Options

OneNote 2016: Using OneDrive

Using OneDrive

OneNote 2016: Working with Text

Typing and Formatting Text
Exercise 02
Laying Out Your Notes

OneNote 2016: Working with Images

Inserting Images
Screen Clipping & OCR

OneNote 2016: Quick Notes

Using Quick Notes

OneNote 2016: Handwriting in OneNote

Handwriting
Exercise 03

OneNote 2016: Drawing in OneNote

Drawing Shapes and Lines
More About Drawing

OneNote 2016: Tables in OneNote

Inserting Table
Formatting Table
Working with Excel

OneNote 2016: Audio and Video Notes

Inserting Audio Notes
Inserting Video Notes
Exercise 04

OneNote 2016: Templates

Using Templates

OneNote 2016: File Attachment

Attaching Files

OneNote 2016: Working with Links

Inserting Links
Different Types of Links

OneNote 2016: Tagging & Searching

Managing Tags
Searching
Exercise 05

OneNote 2016: Protecting & Sharing Notes

Protecting Notes
Sharing Notebook Using OneDrive
Other Sharing Options

OneNote 2016: Authoring & Researching

Spell Checking & AutoCorrect Options
Translating Text and Language Preferences
Using Thesaurus
Research Tools

OneNote 2016: Integrating OneNote with Outlook

Creating Notes to Outlook Tasks

OneNote 2016: Math Tools

Calculator and Equation Editor
Exercise 06

OneNote 2016: Conclusion

OneNote Online & Conclusion
OneNote 2016 - Quiz

Access 2016: Introduction

Introduction to Access 2016 Course
Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Acquiring Access 2016
Structure of the Course
What's New in Access 2016

Access 2016: Using Touch

Using Access in a Touch Device

Access 2016: Getting Started

Using Database Templates
Creating, Saving, and Opening Databases
The Access Workspace and Backstage

Access 2016: Help

Online Help and Tell Me

Access 2016: The Ribbon and Toolbars

The Ribbon
The Quick Access Toolbar
Contextual Menus
The Status Bar

Access 2016: Keyboard Shortcuts and Key Tips

Keyboard Shortcuts
Key Tips

Access 2016: Options

General, Current Databases, and Language Options

Access 2016: Tables

Creating a Table and Fields
Indexed Field
Lookup Wizard
Numeric Fields
Exercise 01

Access 2016: Importing Data

Importing Data from Excel
Exercise 02

Backup, Restore, and Repair

Backing up your Database
Compact and Repair

Access 2016: Datasheet View

Design in the Datasheet View
Sorting and Filtering in Datasheet View
Entering and Modifying Data in Datasheet View

Access 2016: Relationships

Creating a Link Table
Setting up Relationships
Exercise 03

Access 2016: Forms

Creating a Form
Modifying a Form
Exercise 04
Forms in Layout View
Forms in Design View
Form Design
Exercise 05

Access 2016: Subforms

Setting up Subforms - Part 1
Setting up Subforms - Part 2
Setting up Subforms - Part 3
Exercise 06

Access 2016: Queries

Creating a Query
Joins
Query Wizard
Exercise 07

Access 2016: Expressions

Setting up Validations
Calculation using Expressions

Access 2016: Reports

Basic Report
Report Design
Complex Report
Exercise 08

Access 2016: Printing

Printing and Print Properties

Access 2016: More Data Types

Yes/No, OLE Object, and Hyperlink Data Types

Access 2016: More About Forms

Form Controls
Form Themes
Navigation Form

Access 2016: Modal, Dialogs, and Macros

Introduction to Model Dialog and Macros
Model Dialog and Macros Continued
Form Validation
Adding a Command Button to a Form
Exercise 09

Access 2016: Web App Basics

Creating an Access Web App
Importing an Access Database to a Web App
Exercise 10

Access 2016: Exporting

Exporting an Access Database

Access 2016: Application Parts

Adding Application Parts to a Database

Access 2016: More Access Options

Additional Access 2016 Options

Access 2016: Info Tab

View and Edit Database Properties, and Encrypt with Password

Access 2016: Security

Trust Center Settings

Access 2016: Conclusion

Closing
Access 2016 - Quiz

Access 2016 Advanced: Introduction

Course Overview and Content
Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files

Access 2016 Advanced: Primary Keys and Indexes

Primary Keys and Indexing Rules and Guidelines
More About Indexes

Access 2016 Advanced: Using Datasheet View

Setting-up Northwind Database
Working in a Datasheet View
Customizing Datasheet View and Advanced Sorting and Filtering
Subdatasheets
Exercise 01

Access 2016 Advacned: Linking to Other Access Databases

Linking Two Tables to Other Access Databases

Access 2016 Advacned: Using ODBC and SQL Server

Acquiring and Installing SQL Server Express
Setting up SQL Server Database
Exercise 2

Access 2016 Advanced: Splitting an Access Database

Splitting an Access Database into Front-end and Back-end Databases
Converting Shared Table into Local Table; Moving Back-end Database
Exercise 3
Addressing Multi-users Issues When Sharing Data

Access 2016 Advanced: Macros

Basics of Macros
Macros on Events; AutoExec
More About AutoExec; Bypassing AutoExec
Macro Security Settings
Exercise 4

Access 2016 Advanced: The Ribbon and Toolbars

Customizing the Ribbon and Quick Access Tool

Access 2016 Advanced: Visual Basic for Applications in Access 2016

Convert Macros to VBA; VBA Editor and Property Windows
VBA Modules; Running Code and Error Handling
Creating Modules; Subs, Functions, Intellisense and Variables
Scope, Variable Naming and Strings
Standard Functions; Logical, Case and Loop Statements

Access 2016 Advanced: Access Events Model

Adding Events to Assets Database
Exercise 05
Common Events; Form and Report Events
Switchboard and Navigation Form; Error Handling
Exercise 06

Access 2016 Advanced: Forms

Formatting Bound and Control Form
Split Forms; Macro Error Handling
Creating Form with Tab
Go To Combo Box and Its Properties
Exercise 07

Access 2016 Advanced: Advanced Use of Queries

Basic of Queries: Review
Syntax of SQL Statements
Use of Multiple Where Criteria & Select Statements Function
Joins and Its Types
Exercise 08
Action Queries - Part 1
Action Queries - Part 2
Subqueries

Access 2016 Advanced: Packaging your Application

Steps in Packaging Access Application
Exercise 09

Access 2016 Advanced: Conclusion

Online Support and Conclusion
Access 2016 Advanced - Quiz

VBA for Beginners: Introduction

Introduction to the VBA Course
Essential Information for a Successful Training Experience
VBA course exercise and solution files

VBA for Beginners: Getting Started

Getting Started
The VBA Editor
First Coding Manipulations

VBA for Beginners: Code Writing Basics

Keywords, Comments, and Code Syntax
Using VBA Objects and Intellitext
Variables and Code Calls
Defining and Managing Variables
Variables and Constants Intellitext

VBA for Beginners: Specific Code Constructs

Subroutines
Logical Constructs: The Boolean Type
Logical Constructs: If and Switch Statements
Methods for Communicating to the User
Looping: The For and Do While Loops
Looping: Collections and the For Each Loop

VBA for Beginners: Writing Functions

Functions
Returning a Value from VBA
Functions: What Can't They Do?
Defining Function Inputs
Using Worksheet Functions in VBA
Versatile Lookup: First Functional Version
The Range Object
Array Formula

VBA for Beginners: Key Objects and Error Handling

Application Object
Workbook and Worksheet Objects
Error Traps
Names
Pivot Tables
Charts
One Approach To Completing Exercise 8
The PageSetup Object and Print Ranges

VBA for Beginners: Conclusion

Concluding Remarks
VBA for Beginners - Quiz

VBA Intermediate: Introduction

Course Overview
Essential Information for a Successful Training Experience
Course exercise files
Course support files

VBA Intermediate: VBA Language Details

Chapter 2 Preview
Excel File Types
Code Modules
Detailed Memory Management
Code Module Interactions
The VBA Project Model
Advanced Parameter Definitions

VBA Intermediate: Excel Events

What Are Events?
Pre-Defined Events
Event Parameters
A Series Of Example Events
Application Events

VBA Intermediate: Custom Objects

Chapter Overview + New Keyword
Creating A Custom Type
Create a New Class
Defining a Class
Practical Example of a Class
Practice Test of a Class
Special Class Variables and Components
Initialization and Termination
VBA Attributes and Usage
Inheritance - Defining the Bookmarks Support Class
Creating a Userform
Designing a Userform
Coding a Userform

VBA Intermediate: The Excel Interface

Modding the Excel Interface
UI Interface Scope and Range
UI Interface Control Options and Access

VBA Intermediate: External References and Office Interop

What are References? How do they work?
Reference Object
Office Libraries
ADODB Library
The Scripting Library

VBA Intermediate: Conclusion

Course Conclusion
VBA Intermediate Training - Quiz
Downloadable Course Transcripts for Word 2016 Beginner Course

Reviews

Frank
August 18, 2022
Currently I’m looking at the VBA section. However, I also want to look through tips on Excel and Access, maybe other sections as well. I’m not using 2016, but most of this course still applies to 365/2021. There’s more to MS Office than just getting certified.
Kully
January 11, 2021
Yes, it is a good match. I feel that the instructor is doing well at explaining and presenting the information contained in this course.
Steve
November 30, 2020
I'm fairly experienced in Excel so most of the content wasn't new to me. but I did pick up a few items that I hadn't seen before. It was very useful!
Elizabeth
October 30, 2020
I think this course is going to be a good learning experience for me. It will hopefully sharpen my Excel skills.
Timi
June 23, 2018
Honestly, this course is not for someone who wants to learn from scratch, the first at least 30 vids just pumps features at you like crazy, I'm not done watching but the feeling of fustration is already building up, I knew a bit of excel before starting and he has shown me some new stuff but now no practical. I sent to my parents but now, they don't want to touch the course with a ten foot spoon.
Ioannis
June 22, 2018
I have use ms office for many years now, but I had never spent some time to learn in a proper way. It was an "find a solution to my current problem" learning procedure. With this course, i noticed an significant improve to my productivity.
Rochelle
June 5, 2018
have started with WORD first. I am doing OK with learning, but at the same time all the different short cut options , learning at the same time, are a bit overwhelming
Thaddeus
June 1, 2018
So far so good. It's covering the bare bone basics which is what I needed. Looking forward to when it goes more in depth as well.
Sandra
April 30, 2018
I have learned a lot already. I like the way it is presented. As a total beginner, it is easy to follow and I don't feel like I'm being talked down to. Thanks!
Bernard
April 14, 2018
Extremely thorough- answered both broad questions on how to do entire functions and also specific questions which I'd been wondering for years which will inevitably save me hours of time clicking and reformatting. Great course.
Walter
March 28, 2018
The coverage of the thought process behind what you are doing in the course helps you understand how to apply the lessons directly to your own challenges
Diane
February 27, 2018
So far this course is concise and easy to understand. I also like that the instructor shows how to do certain things with a touchscreen. I especially like that they included exercises into this course because I retain more information when I participate rather than just watching. It is everything I wanted in this course.
Karen
February 21, 2018
The instructor was clear and captivating, I thoroughly enjoyed this course. Very helpful to talk about a subject and then show us on the screen.
Geoffrey
January 31, 2018
Clear and concise, good delivery of information. This is based on watching the first Excel video from Toby.
Cecile
January 28, 2018
The course bundle was too voluminous and needed to be broken down more. Plus the explanations were not very clear. As a giant training bundle, it seems like a good deal, but I prefer the shorter training videos that offer easier understanding of course material by the end of the lessons. The only truly negative part was how tiny the Excel spreadsheet was. I have poor eyesight and it was very difficult to see the tiny Excel spreadsheet with materials on the screen. Magnifying it did not make it more accessible. I like to be able use it not just on a pc but also on an ipad mini when I am away from my pc -- dog sitting. What was tiny on a pc is ridiculously tiny on an ipad mini with zoom feature inadequate. All in all however, it is a bargain at being such a complete essential training bundle for Office 2016.

Charts

Price

Microsoft Office 2016 Essential Training: 9 Course Bundle - Price chart

Rating

Microsoft Office 2016 Essential Training: 9 Course Bundle - Ratings chart

Enrollment distribution

Microsoft Office 2016 Essential Training: 9 Course Bundle - Distribution chart

Related Topics

1352400
udemy ID
9/16/2017
course created date
11/7/2019
course indexed date
Bot
course submited by