Microsoft Excel, Outlook and Word 2016 for Beginners

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2016 Inside And Out—Quickly, No Travel or Classes.

4.75 (256 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
4,673
students
31.5 hours
content
Mar 2023
last update
$94.99
regular price

What you will learn

Discover new and improved features in Excel 2016.

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.

Discover how to format dates and numbers.

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.

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.

Setting up email accounts.

Creating and sending email messages.

Organizing email.

Calendar appointments and attachments.

Create and manage meetings.

Adding email signatures.

How to archive email.

Spam and junk mail removal.

Creating and managing tasks and reminders.

Using the mail merge feature to import contact information to Microsoft Word.

Adding, managing and searching contacts in the address book.

Creating filters to automate incoming messages.

Practice what you learned with included exercise files.

Description

Master the Ins and Outs of Microsoft Office 2016

  • Spreadsheets with Excel 2016

  • E-mail and calendar management with Outlook 2016

  • Documents with Word 2016

The course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft  Office.     

Through 23 hours of video lectures and 3 quizzes, you'll learn the essentials with these 3 popular courses:

  • Microsoft Excel 2016 for Beginners: Master the Essentials: Create basic spreadsheets and use formulas for tracking expenses.

  • Master Microsoft Outlook 2016 the Easy Way: Introductory course on email efficiencies to help clear the email clutter and gain control of your inbox.

  • Learn Microsoft Word 2016 For Beginners - Basics to Advanced: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.

Details:

Master Excel 2016 For Complete Beginners In This Helpful, Info-Packed Video Course

  • Easily learn Excel 2016 for complete beginners

  • How to get Excel and installation requirements

  • Helpful discussion of new features in 2016

  • Getting started with a Workbook

  • Entering and editing data

  • Creating charts and graphs

  • How to create functions

  • Protecting and securing your data

  • All lessons in easy step-by-step format

  • Practice with included exercise files

Excel 2016 From The Beginning

This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you from the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you're using Excel 2016 like a pro with advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business.

If most Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air.  The videos keep things simple and carefully step you through each process.

Contents and Overview

This course starts with where to find Microsoft Excel and install the program. Then you learn step-by-step, simple 1-2-3 methods for  getting up and running with Excel 2016. Watch just the first few videos  to have a basic knowledge of Excel. Then continue through the detailed  32 chapters of video lessons and 9 exercise files to gradually become a  proficient user.

It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use  Help to get additional answers when you need them.

Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars,  entering and editing data, backup and recovery, fill and series, and printing your projects. We also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

Get Organized, Productive, and Stay on Schedule with Microsoft Outlook 2016!

Topics include:   

  • Create and send messages 

  • Organize mail 

  • Work with email attachments 

  • Create and manage meetings   

  • Adding contacts 

  • Searching for contacts 

  • Setting up and managing accounts 

  • Creating tasks 

  • Archiving email 

  • Using mail merge 

All the Tools You Need to Master Microsoft Outlook 2016    

When you sign up for this course, you’ll gain access to 8 hours of video content – as well as special exercises and quizzes. After absorbing this comprehensive course, you’ll be able to impress your colleagues with your knowledge and productivity. You will of course receive a certificate of completion when you’re finished to let others know of your accomplishment.    

We present all the videos in this course in crisp, easy-to-watch HD for optimal learning speed and clarity. With these tools, you’ll find out what’s new in Microsoft Outlook 2016, the basics of the Outlook interface, and how to work in the user interface. From keyboard shortcuts to using Outlook on a touch device, you’ll discover the pro techniques that save time and effort with this sophisticated software platform.    

You’ll learn to create, reply to and manage email messages, and also organize your messages using folders. Precise meeting setup and management of meetings can turn an amateur into a productivity pro. With this course, you’ll learn to seamlessly integrate new contacts into your address book. You can easily view and share calendars with others in Microsoft Outlook 2016, create a to-do list, and print your calendar to share with others. In addition, this course describes how to create time-saving rules to filter your email based on your own needs and requirements.    

You’ll even find out how to use the mail merge feature to merge your contact information stored in Outlook 2016 to a Microsoft Word document.   

Whether you’re new to this software platform or just need an update on the latest features and pro tips, this course has everything you need to be productive and organized!   


Become a Word 2016 power user. We start at the very beginning progressing with more than 80 helpful videos.
   

All you need for work, hobbies, and running your own business. Feel confident with every aspect of Word 2016.    

  • Practice exercises provided to practice what you learned

  • Designed to help beginners get started

  • Lessons start right at the very beginning

  • Progresses slowly with more than 80 helpful videos

  • A big 6 hours of expert instruction

  • Learn what's new in Word 2016

  • Master the most common uses of Word

  • Learn to create many types of documents

  • Use the full palette of functions

  • Experienced users can fill in gaps in knowledge

  • Work faster with better results and greater confidence

  • Discover how to use mail merge

Now you can learn Word 2016 from the very beginning. Beautifully designed for beginners to get a great start while helping more experienced users fill in any gaps in their knowledge. You enjoy more than 80 expert tutorial videos that clearly show you how to accomplish every aspect of Word.    

Learn what's new in 2016. Now you can be up to date in order to be a true Word power user. With 6 hours of expert instruction, you have an opportunity to cover every inch of Word 2016.   

This course is just what you want for being confident with Word in the workplace. Also gives you everything you need to know for personal use, hobbies, non-profit volunteering, or running your own business.   

The self-learning video format lets you study on your own schedule. Watch videos as you have time, then come back to learn more later.   

Now you can become a master at using one of the world's most popular computer applications – Microsoft Word.  

Contents and Overview   

Learn Microsoft Word 2016 For Beginners starts with what is new in this latest version. If you already know Word, this can help you get up to speed with 2016 right away. Next, we start with a blank document and learn how to create spacing, character choices, save, edit, search and replace, and much more.   

Chapter 3 goes into character formatting including cut, copy and paste, auto-correction options, and format painter. We also learn about working with numbers, bullets, and creating an outline.   

Then the course covers paragraph formatting, managing lists, and all aspects of creating tables. Because you want your pages to look good, we teach how to control page appearance, sectioning, and all about using graphics.   

Learn how to print envelopes, mail merge, along with a practice exercise. These practice opportunities come at the end of each module.   

Finally, the course covers using the Thesaurus, spell check, comments, margins, printing, and much more. You will also learn about time and effort-saving Macros that let you speed through assignments and projects.   

When you complete this course, you'll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft Office 2016.


Here’s what our students are saying…

“This course was the perfect match for me. I would highly recommend anyone to do it be it to brush up on your skill or new beginners.
Thank you.”

– Anesa Daniels

"I'm only 72% through the course, but I had zero experience with most of the applications covered prior. Now I feel like I'm ready to tackle just about any project using the applications I've learned.

– Lauren Bury

"Yes, brilliant. All the details of signes and names, how every task works, etc... Feels like a real teacher is beside you explaining everything."

–  Julia Costa

Content

Learn Microsoft Excel 2016: Introduction

Acquiring Excel 2016 and Information on Installation and Upgrade
Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Downloadable Course Transcripts
Section 1 - Quiz

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
Section 5 - Quiz

Excel 2016: Excel Options

Personalizing your use of Excel
Section 6 - Quiz

Excel 2016: The Ribbon and Toolbars

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

Excel 2016: Entering and Editing Data

Basics of Entering and Editing Data in a Workbook
Exercise 01
Formatting Dates
Formatting Numbers
Exercise 02
Section 8 - Quiz

Excel 2016: Backup and Recovery

AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Section 9 - Quiz

Excel 2016: Fill and Series

Working with Fill and Series
Flash Fill
Section 10 - Quiz

Excel 2016: Viewing and Printing

Workbook Views, Zoom, and Freeze
Printing
Exercise 03
Section 11 - Quiz

Excel 2016: Cut, Copy, and Paste

Methods of Cutting, Copying, and Pasting
Section 12 - Quiz

Excel 2016: Formatting a Worksheet

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

Excel 2016: Formulas and Functions

Basics of Fomulas and Functions
Complex Examples of Formulas
Exercise 05
Section 14 - Quiz

Excel 2016: Managing Worksheets

Rename, Insert, Move, and Reference a Worksheet
Section 15 - Quiz

Excel 2016: Working with Multiple Workbooks

Working with Multiple Workbooks
Section 16 - Quiz

Excel 2016: Saving Workbooks

Saving in Different File Types
Section 17 - Quiz

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
Section 20 - Quiz

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
Section 21 - Quiz

Excel 2016: Sorting and Filtering Data

Managing Data by Sorting
Managing Date by Filtering
Customizing Tables
Section 22 Quiz

Excel 2016: Shapes and Pictures

Inserting Shapes and Pictures
Exercise 08
Section 23 Quiz

Excel 2016: Formatting Cells Based on Content

Conditional Formatting
Section 24 Quiz

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
Section 27- Quiz

Excel 2016: Borders

Adding Borders
Section 28 - Quiz

Excel 2016: Workbook Inspection

Inspecting a Workbook

Excel 2016: Privacy Options

Trust Center Privacy Options

Excel 2016: Sharing Options

Sharing a Workbook
Section 31 - Quiz

Excel 2016: Wrap Up

Closing

Learn Microsoft Outlook 2016: Introduction

Introduction to the Course
Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Acquring Outlook 2016
What's New
Section 35 - Quiz

Outlook 2016: Getting Started

Starting Outlook 2016
Using Touch
Outlook 2016 Interface
Getting Help
Keyboards Shortcuts and Keytips
Outlook Options
Secton 34 - Quiz

Outlook 2016: Basic Tasks

Setting Up an Account
Sending and Receiving Email
Calendar Basics
Exercise 01
People
Task Basics
Notes
Section 35 - Quiz

Outlook 2016: Ribbon and Quick Access Toolbars

Customizing the Ribbon and Quick Access Toolbars
Exercise 02
Section 36 - Quiz

Outlook 2016: Data Files and Account Management

Outlook Data Files and Their Properties
Managing Accounts
Managing Folders
Exercise 03
Backup and Restore a PST file
Section 37 - Quiz

Outlook 2016: Contacts

Contact Records
Maintaning Contact Information
Contact Views
Using Contact Information
Address Books
Contact Groups
Exercise 04
Printing Contact Information
Section 38 - Quiz

Outlook 2016: Email Management

Sending Messages
Receiving Messages
Replying to Messages
Touch Action Bar
Organizing Folder Contents
Junk Email
Security & Trust Center
Exercise 05
Section 39 - Quiz

Outlook 2016: Archiving

Archiving
Section 40 - Quiz

Outlook 2016: Calendar Management

Calendar Setup
Viewing & Sharing Calendars
Calendar Item Management
Managing Meetings
Calendar Events
To-do Bar
Printing Calendar Information
Exercise 06
Section 41 - Quiz

Outlook 2016: Categories

Color Categories
Section 42 - Quiz

Outlook 2016: Tasks Management

Managing Tasks
Viewing Tasks and Recording Progress
Section 43 - Quiz

Outlook 2016: Rules & Quick Steps

Creating & Managing Rules
Quick Steps
Exercise 07
Section 44 - Quiz

Outlook 2016: Other Features

Email Features
Proofing Features
Formatting Themes and Styles
Signatures and Stationery
Saving and Printing an Email
Exercise 08
Section 45 - Quiz

Outlook 2016: Search Features

Searching Contacts and Other Items
Section 46 - Quiz

Outlook 2016: Mail Merge

Mail Merge
Exercise 09
Section 47 - Quiz

Outlook 2016: Conclusion

Office Updates; Conclusion

Learn Microsoft 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
Practice Exercise
Section 50: Quiz

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
Practice Exercise

Word 2016: Paragraph Formatting

Alignment Options
Line Spacing Options
Working with Indents
Working with Tabs
Practice Exercise
Section 52 - Quiz

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
Practice Exercise
Section 54 - Quiz

Word 2016: Styles

Working with Styles
Creating Styles
Editing Styles
Practice Exercise
Section 55 - Quiz

Word 2016: Controlling Page Appearance

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

Word 2016: Sectioning

What is Sectioning?
Sectioning a Document
Odd and Even Sections
Practice Exercise
Section 57 - Quiz

Word 2016: Graphics

Inserting Pictures
Inserting Pictures into Existing Documents
Picture Options
Working with Shapes
Other Graphic Options
Practice Exercise
Section 58 - Quiz

Word 2016: Envelopes & Labels

Working with Envelopes
Working with Labels
Section 59 - Quiz

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
Practice Exercise
Section 60 - Quiz

Word 2016: Quick Parts

Building Blocks
Creating and Editing Building Blocks
Auto Text
Practice Exercise
Section 61 - Quiz

Word 2016: Indexing and Table of Contents

Creating an Index
Creating a Table of Contents
Practice Exercise
Section 62 - Quiz

Word 2016: Review and Printing

Using the Thesaurus
Spell Check
Comments
Margins
Page Setup Options
Printing
Practice Exercise
Section 63 - Quiz

Word 2016: Other Word Features

Word Options
Protecting a Document
Macros

Word 2016: Wrap Up

Closing

Screenshots

Microsoft Excel, Outlook and Word 2016 for Beginners - Screenshot_01Microsoft Excel, Outlook and Word 2016 for Beginners - Screenshot_02Microsoft Excel, Outlook and Word 2016 for Beginners - Screenshot_03Microsoft Excel, Outlook and Word 2016 for Beginners - Screenshot_04

Reviews

Tanya
February 9, 2021
I am confused. But I will continue until I understand something. I believe the computer language is confusing to me, its been a while.
Frank
January 12, 2020
At the end of 2019 I subscribed to Office365. I have noticed that the course EXCEL2016 has some of it's content changed, so I am assuming Microsoft has made changes and is now using EXCEL2019. A bit more challenging to follow along to the instruction but not overwhelming.
Tracey
November 22, 2019
Not even remotely proficient in Excel this is a bit daunting for me I'm hoping this is exactly what I need!
Kelly
November 22, 2018
I already bought Office. Not clear what I'm supposed to do and loaded very slowly. Horrible so far.
Abdul
June 11, 2018
that was good and also interesting i have two chapters in my computer book of excel hope i will learn from here and top there

Charts

Price

Microsoft Excel, Outlook and Word 2016 for Beginners - Price chart

Rating

Microsoft Excel, Outlook and Word 2016 for Beginners - Ratings chart

Enrollment distribution

Microsoft Excel, Outlook and Word 2016 for Beginners - Distribution chart
1561454
udemy ID
2/19/2018
course created date
7/10/2019
course indexed date
Bot
course submited by