Microsoft Excel, PowerPoint 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.80 (797 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Microsoft Excel, PowerPoint and Word 2016 for Beginners
6,671
students
29.5 hours
content
Mar 2023
last update
$99.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

Practice what you learned with included exercise files

Discover new features in PowerPoint 2016

Learn presentation tips for an effective presentation

Discover how to format text on a PowerPoint slide

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

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

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.

Why take this course?

Master the Ins and Outs of Microsoft Office 2016

  • Spreadsheets with Excel 2016
  • Documents with Word 2016
  • Presentations with PowerPoint 2016

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

Through 21 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.
  • 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.
  • Master Microsoft PowerPoint 2016 the Easy Way: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools.

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 installing 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.

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, editing, 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.

Discover the Powerful Features of PowerPoint 2016

  • Have complete control over your presentation's information
  • Now have professional presentations for job or project
  • Quickly create top-notch visuals for your audiences
  • Feel confident and show off your new powerful slides
  • Get all of the new tools to master presentation management
  • Effortlessly add text, graphics, audio, video, charts, tables and SmartArt to your slides
  • 6 hours of professional video with over 70 individual lessons that make everything clearer and easy to remember
  • Practice what you learned with included exercise files

Use This New Course to Easily Create Beautiful Presentations

PowerPoint 2016 is by far the most popular presentation program in the world as it allows users to create, edit, and show illustrative presentations with the help of attention-grabbing slides. This crash course explains how you can combine the text, 3-D graphics, and multi-media to support your presentation-making needs. Using PowerPoint as a presentation tool is the way to go.

Do you need some visual impact? Well, look no further. Because this course can show you how to take this program and make it do just that. In fact, making your presentation more interesting through the use of multi-media can only help improve your audience's focus. PowerPoint 2016 allows you to use your choice of images, audio clips, and videos to help you get your points across. These important sound effects and visual cues can also help a presenter like yourself, be more improvisational, and interactive, all of which is a very beneficial thing. This course essentially shows you why PowerPoint 2016 is the best and most complete presentation package available. It gives you 80 individual video tutorials that are quite in-depth. It also has exercise files so that you can practice the lessons you've learned.

Everything you need is here so that you can learn how to produce a nice and professional-looking presentation. Once everything is finished, you can begin to prepare your talk. In fact, even if it went well but someone missed your presentation, you could still have them view it online at a time that's convenient for them. Simply upload your presentation to YouTube with everything featured in your work, including all of the slides, commentary, and transitions.

So, whether you need processing, outlining, drawing, graphing, or more elaborate presentation management tools - it's all covered in this easy-to-understand course. You can not only create and modify your own presentations, but gain mastery on it eventually, too. All that is needed on your part is a little practice.

Overview and Contents

PowerPoint 2016 can be used in a number of different yet effective ways to communicate with your audience. Slides are completely customizable. Depending on your approach, you may want to have a presentation that's text-heavy, image-heavy, or some combination of both. Combining the two tends to give your listeners the benefit of both visual aids and notes all at the same time.

PowerPoint 2016 also comes with many new features such as the brand-new transition type, Morph, that can help users make animations, transitions, and object movements across your slides. Pretty neat, right? This course covers that and so much more. It also shows you how to make presentations with alternative forms, styles, and custom layouts which are used by working professionals, teachers, students, medical practitioners, politicians, and countless others. They see the value in this unique course on PowerPoint 2016 as they want to know how to use it to quickly showcase their information and data.

Perfect for those who are looking for a comprehensive and organized method to presentations. Great for those that want to add value to lectures, make more compelling speeches, or enhance studies and reports. So, what are you waiting for now? If you want to learn how to use the latest version of PowerPoint, then this is for you. At the completion of this course, you will have more knowledge, better skills, and be fully prepared to use PowerPoint 2016 for every single one of your complex presentation needs.

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.

** Updated June 2017. Course transcripts now available.

What People Are Saying:

★★★★★ “The instructor speaks very clearly and is super easy to follow. Her voice is instructive at a good pace and pleasant to listen to. She appears to be very knowledgeable and is very helpful in sharing shortcuts to help speed up the work process.” –Elizabeth Eisley

★★★★★ First time ever taking online classes. The teachers are explaining everything in details. I think it will be very helpful course. Excited to listen the rest of them.” -Violeta Yordanova

★★★★★ “Very clear, concise and easy to follow. The topics are covered systematically and comprehensively. So far I am very impressed.” –John Lawton

★★★★★ “Very informative. I am familiar with WP, and some of WP is similar. However, Word seems to have a lot of stuff hidden in the drop boxes that nobody would ever think of without this training.” –David Kelly

★★★★★ The instructor is clear and speaks slow enough that you are able to follow her guidance. pleasant voice and doesn't rush goes to the basic step by step and is easy to follow. I highly recommend her and her course to anyone that is wanting to learn the basics of at least PowerPoint. I have a certificate in Microsoft Office but its outdated and just wanted to freshen up my knowledge and get the cobwebs out of the closet that has used this software in many years. Thank you!!” -Victoria J. SCHALLER

Screenshots

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

Reviews

Wendy
November 17, 2020
Very detailed and organized. Easy to follow along and love the sample of formatting I am creating my own worksheet and following along.
Sarah
September 3, 2020
I have learned many things I did not know or expect to learn, some of which were quite surprising. Thank you for making this as easy to follow along with as it is.
Sarah
August 14, 2020
This course was very informative with clear instructions. Fairly easy to follow, even for a beginner like myself.
Madhavi
July 8, 2020
Hello, This is Madhavi I know very well in EXCEL and word but i don't know powerpoint presentation. In this presentations i learned many things. Thank you so much all
Sunny
April 30, 2020
Good to know.... what we can do on Excel/ Powerpoint... practice is the key Extra lesson 239 and 240 is same ...
Lorie
April 18, 2020
This course was a good match for me because the instructor went step by step to explain the modules in detail.
Alix-Jay
October 30, 2018
yes thank you! am enjoying it! just didnt know where my worksheets are that i should fill in and where to send them off to/submit them too
Mahmoud
March 20, 2018
This is a very comprehensive course of excel, PowerPoint and word 2016. The course starts from the basics and works up to relatively advanced level. The presentation is very clear. The course is relatively long and requires self-discipline, but it worth it.
Troy
January 30, 2018
Very slow moving long winded instructor If I wanted a slow story that rambles on and on I would search for stories that make me fall asleep and waist time to get to the point of the story. Very boring and on section 4 learned very little which could have been done via a 5 minute video. So far learned more using the Take A Tour in excel in 5 minutes. Wasted my valuable time. Going to find a course that get to the point and teaches something. Could have found a better course on a public video site.
Kanimba
January 20, 2018
The quality of the course is very good. The examples used in the course were very simple but very clear and helped a lot to understand the message.
Pha
January 17, 2018
The exercise 01 require to dig information that is not available. The idea is just learn how to use Excel not solving a problem. Also, the date format took too long and doesn't make sense. For example, change 7.2 to time.
Richard
January 14, 2018
This is great for me because it treats me as if I've never had one lesson on Word which of course, I haven't. Very easy to follow along for us newbies.
Michael
November 30, 2017
Lots of gteat information and i am really looking forward to this course im gibing it a 4.5 becausw i am using an iPad and k cqnt access the training documents
Elizabeth
November 25, 2017
The instructor speaks very clearly and is super easy to follow. Her voice is instructive at a good pace and pleasant to listen to. She appears to be very knowledgeable and is very helpful in sharing shortcuts to help speed up the work process.
al
November 10, 2017
Refreshing for a self taught office user to see the extent of features available in word that I wasn't familiar with and as such never used them to be more productive. Great material and delivery

Charts

Price

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

Rating

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

Enrollment distribution

Microsoft Excel, PowerPoint and Word 2016 for Beginners - Distribution chart
871270
udemy ID
6/7/2016
course created date
11/20/2019
course indexed date
Bot
course submited by