Skip to content
UdemyOffice ProductivityPaid courseBeginner levelCertificate

Microsoft Excel, Outlook and Word 2016 for Beginners (Udemy.com)

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

Created by: Simon Sez IT

Last updated March 2023

icon
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 it compares

Against the other 459 rated Udemy courses in Office Productivity on CourseDuck:

  • Rating4.6 out of 5higher than 67% of them
  • Reviews269#294 of 460 by number of reviews
  • Length31.6 hourslonger than 96% of them
  • Last updatedMarch 2023earlier than 75% of them

icon
Course 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

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Simon Sez IT

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 12,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 1 million Udemy students in over 190 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

icon
More courses by Simon Sez IT

$19.99

$14.99

$109.99

$174.99

$84.99

$84.99

icon
More Office Productivity courses

$19.99

$10.99

$39.99

$64.99

$12.99

$19.99

icon
Reviews

4.6

269 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Onuachalla juliet on 6/30/2021

Very clear and easy to understand

By Tracey on 11/22/2019

Not even remotely proficient in Excel this is a bit daunting for me I'm hoping this is exactly what I need!

By Thomas M. Foran on 7/9/2019

This course has been good and very thorough up to now lots of good info

By Shirley on 4/25/2019

I had no experience He explained everthing very well. I love his explantations.

By Michele Rashbaum on 3/5/2019

I like how everything is explained and the quizzes

By Nestor Ortiz on 1/9/2019

Very Detail info with regards of MS Office environments that are available

By Maha Alshehri on 11/25/2018

Thank you for good teaching

By Wilson Freddy Chique Velasquez on 8/4/2018

As usual Simon Saez is awesome I could watch his vids all time! good job,

By Michelle Gamblin on 7/15/2018

This is a very detailed course. I think that is important for most learners.

By Saber BOUZIANI on 6/4/2018

I want to become an expert like you

Showing all 10 reviews on CourseDuck

Read all 269 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100