Microsoft Excel 2016 - The Comprehensive Excel 2016 Guide
4.5 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
263 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 - The Comprehensive Excel 2016 Guide to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 - The Comprehensive Excel 2016 Guide

Learn Excel 2016 from scratch or improve your skills and learn new tricks to speed up your work.
4.5 (23 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
263 students enrolled
Last updated 3/2016
Curiosity Sale
Current price: $10 Original price: $55 Discount: 82% off
30-Day Money-Back Guarantee
  • 11.5 hours on-demand video
  • 3 Articles
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • know how to get help in Excel
  • know how to use the many features of Excel 2016 or earlier
  • know how to use Excel in order to solve new problems that arise
  • help out your colleagues in general questions concerning Excel
  • make your work faster, better and more efficient
View Curriculum
  • you will need Excel 2016 (or 2013) installed on your machine
  • you will need a general understanding of maths
  • interest in learning and solving the exercises provided

Do you want to make your work with Excel faster, more efficient and fun?

Do you want to learn more about hidden tricks that make Excel easier to use?

Are you looking for a structured way to get really good with Excel?

If your answer was YES to some of the questions, this course might be of interest to you.

When I created this course I put full emphasis on a structured and didactically sound way to gently show you how Excel 2016 and 2013 works. This course is especially suited towards a beginners and intermediate user group.

The course was shot with Excel 2016, which basically means that you can apply the knowledge from this course also to Excel 2013 (and 2010) since those versions are quite similar.

Excel is such a huge and powerful software so that learning it can be confusing. It is advisable to learn it in a structured way so that you can improvise and find proper solutions to new problems. Many users tend to only know the parts of Excel that are needed for their daily routine. Once a totally new problem arises, they are stuck. Having structured training combined with practice is key to finding solutions faster and without frustration.

In this course you will learn about the general interface, the capabilities and limitations, popular and efficient functions, useful tools, data visualization, database handling, getting help and much more. Take a look at the course content overview to see how extensive the whole product is.

At the end of this beginners and intermediate course you should be confident in using for your daily tasks. You will know

how to use Excel's functions and other tools

what the capabilities of Excel are

where to find the appropriate features

how to get help

and how to work more efficiently with Excel.

Excel is one of the key software products of today’s professional world. You will use it extensively in your work life, and of course your colleagues will be thankful if you can show them some tricks they did not know before!

Who is the target audience?
  • people already using Excel but wanting to get more out of the software
  • beginners to Excel 2016 or earlier versions
  • users of earlier versions looking to update their skills
  • everybody interested in the Excel software
Students Who Viewed This Course Also Viewed
Curriculum For This Course
122 Lectures
2 Lectures 02:53

Download these files before you start
The Basics of Excel
10 Lectures 01:03:35

A short introduction on Excel's file types and on the different attributes.

We are going to create our first Excel workbook.

File Types

The Quick Access Toolbar is a very useful feature of Microsoft Office products. In this lecture we are going to take a look at its default tools, and we are also going to learn how to customize it in order the make our daily work quicker.

The Quick Access Toolbar

This lecture contains core information on finding your way within Excel. We are going to take a look at the ribbons, as well as at columns and rows.

Navigation within a Workbook

However Excel is like a huge calculator it makes a great job handling not only number values, but texts, dates, currencies and other types of data. In this lecture we are going to learn how Excel differentiates between those types of data, and how you, the user, can do it.

Entering Different Types of Data

In this lecture we are going to dive deeper into different cell format types. Did you know that Excel can handle the very same data differently depending on the actual cell format type? This lecture could save you some headache, if you are struggling with Excel's auto-formatting feature.

Cell Format Types

A single Excel workbook can contain several worksheets which can help you keeping things tidy and organized. In this lecture we are going to learn

  • how to manage those worksheets;
  • how to create new ones;
  • how to delete the unnecessary ones;
  • how to rename them;
  • how to move them within a workbook or between different workbooks;
  • how to organize and even color code them.
Managing Worksheets

This lecture will teach you how to manage the rows and columns in Excel.

You will learn

  • how to insert new rows and columns - even multiple rows and columns - and what are the rules of creation;
  • how to delete unwanted rows and columns, and what are the rules of removing;
  • how to hide parts temporary, how to discover hidden rows and columns, and how to reveal them if needed;
  • about the rules and dangers of deleting single cells;
  • about the difference between deleting a cell and deleting its content.

Rows and Columns in Detail

In this lecture we are going to learn how to copy and paste data within an Excel worksheet and between worksheets as well. We are also going to learn on the specific rules of those actions.

Copy and Paste Data

In this tutorial you will get familiar with one of most useful and most frequently used tools of Excel. The Fill Handle tool is perfect for copying data or filling cells with series. This tool is one of the biggest times savers as well, and we are going to use it a lot through this course.

Topics of the lecture:

  • how to find the Fill Handle tool;
  • rules of usage;
  • creating custom lists.
Preview 08:06

In the last lecture of the section we are going to take a closer look at Excel's file menu. We are going to discover the old features as well as the new ones which Excel 2016 provides.


  • workbook information;
  • new document creation;
  • saving - file types and places;
  • share, export and publish feature.

Please note, that printing has its own section in this Excel curse.

The File Menu

The Basics of Excel
10 questions
Content Formatting
3 Lectures 15:10

Like other products in the Microsoft Office family, Excel also provides the user content formatting tools. They can be used very easily and intuitively. In this lecture we are going to walk through them together.


  • font types, styles, size and color;
  • using the theme color set and finding new colors;
  • setting borders;
  • background colors.
Content Formatting

In this video we are going to take a closer look at the cell alignment features of Excel.


- vertical and horizontal alignment;

- custom alignment;

- merging cells.

Cell Alignment

  • After completing this lecture you will understand the concept of themes in Excel.
  • You will be able to change the actual theme as well as composing a custom one.
3 Lectures 20:40

Printing in Excel might not be so obvious as e.g. in Microsoft World. Therefore, this course dedicates a whole section for printing. In this lecture we are focusing on the Print Dialog Box.


  • orientation within the dialog box;
  • print preview setting;
  • page orientation;
  • margins;
  • scaling;
  • paper sizes.
The Print Dialog Box

We are going further with the topic of printing.

In this lecture you will learn

  • about the different print areas and their settings;
  • about different views offered by Excel;
  • about some further tools offered by the Page Layout ribbon.
Printing Options

In the final lecture of the section we are going to learn more on headers and footers.


  • how to get the column letters and row numbers printed;
  • how to get particular rows and columns printed on every single page;
  • how to set custom headers and footer for your pages;
  • how to set different headers for the front page, even and odd pages.
Headers and Footers
Basic Mathematics
7 Lectures 37:11

In this lecture I'm going to show you how to do mathematical operations in Excel.


  • building simple formulas;
  • using mathematical operators;
  • using cell references for formulas.
Basic mathematical formulas

The order of operations is a core element in mathematics, therefore it is crucial to learn it properly. In this lecture I'm going to explain those rules and also we are going do a simple exercise in order to understand those rules better.

Things you should know about mathematical operations

SUM is probably the most used function of them all in Excel. In this lecture you will learn how to use it for consecutive cells, and also how to combine it with the Fill Handle tool. We are going to solve some exercises together for better understanding.

Preview 08:51

This lecture contains an exercise which will teach you how to use the SUM function with non-consecutive cells.

The SUM function - working with non-consecutive cells

Using formulas like SUM and the Fill Handle tool together might cause cell reference shifting. We can take advantage of it, like we did in the previous two lectures, but sometimes this phenomenon is undesirable. In such cases absolute referencing comes handy. In this lecture we are going to learn on this feature of Microsoft Excel.

Absolute referencing

Basic Math with Excel
5 questions

Basic Mathematics - Exercises

Basic Mathematics - Solutions
Functions in Excel
10 Lectures 01:10:30

In this lecture we are going to learn about the counting functions of Excel through a couple of examples.


  • COUNT, COUNTA and COUNBLANK functions;
  • the syntax of those functions;
  • the usage of those functions.
Functions for counting cells

In this lecture you will learn about Excel's statistical functions.


  • the syntax and the usage of those functions.
Statistical functions

The following two lectures are on Excel's most used logical function, called IF. In this tutorial we are focusing on the numeric value based logical test. Example exercises is provided for better understanding.


  • syntax and usage of the IF function;
  • available logical operators for that function;
  • how to produce Boolean output data.
Logical functions I - IF with numeric value based logical test

In this lecture we are going to try Excel's IF function with text based logical test.

Logical functions II - IF with text based logical test

Not properly built formulas result error messages. In this lecture we are going to take a closer look at common error messages. We are also going to learn what causes them and how to fix them.


  • common error messages and their background;
  • fixing error messages;
  • finding error messages;
  • #DIV/0!
  • #NAME?
  • #NULL!
  • #NUM!
  • #REF!
  • #VALUE!
How to fix the most frequent errors

In this lecture you will learn

  • what a circular reference is;
  • how to find it;
  • how to fix it.
Finding errors

However the SUM function is very useful on its own, Excel provides some extensions for it as well. This extensions are the SUMIF and SUMIFS functions.

In this lecture you will learn the syntax and usage of those extensions through the provided example.

Preview 09:41

Not only SUM, but the functions COUNT and AVERAGE also have extensions. In this lecture we are going to take a closer look at them, we are going to learn their syntax as well as their usage.

Extensions of the functions COUNT and AVERAGE

Making calculation with dates can be a confusing business. Fortunately Excel provides useful date functions like DATEDIF, DATEVALUE or TODAY which can make our work better. This tutorials shows you how to use them for various purposes.

Functions concerning dates

Copying and pasting formulas can be different from copying and pasting other cell content. This lecture summarizes the available methods and highlights the points you should pay attention to. Furthermore you will learn how to display formulas on different ways, which skill might also come useful in some situations.

Copying and displaying formulas

Excel's functions
10 questions
Working with multiple sheets
6 Lectures 36:33

Name facilities can really make our work quicker and more precise whether we build multiple sheet formulas or just use them for absolute referencing.

In this lecture we are going to learn how to create named ranges and cells, and I'm also going to show you how to use them in formulas.

Name facilities

Till then we built formulas using cells from a single Excel worksheet, but it might happen that we need to connect multiple sheets together. In this video you will learn the exact method of creating such formulas, and we are also going to discuss some rules you should keep in mind.

Cross sheet operations and functions

Excel worksheets can not only be connected within formulas, but we are able to format them simultaneously. This method is a great time-saver.

Modifying multiple sheets

Multiple-sheet Tasks: Exercises

Multiple-sheet Tasks: Solutions 1-5

Multiple-sheet Tasks: Solutions 6
1 Lecture 11:00

This lecture will guide you through the different levels of protection Excel offers.


  • protecting single cells;
  • limiting the allowed actions;
  • protecting single worksheets within a workbook;
  • protecting the structure of the workbook;
  • setting a password for opening the document;
  • adding a 'Read Only' warning to your document;
  • setting a different password for editing the workbook.
Different security levels in Excel
Data Visualization in Excel
7 Lectures 57:47

This lecture is an introduction to data visualization. We are talking about the advantages of visualizing data, and you will also going to learn how to use Excel's Recommended Charts features. This one is really useful especially if you are not familiar with the different charts types yet.

Introduction to Data Visualization

This tutorial will guide you through the process of creating a chart from scratch.


  • choosing a suitable chart type;
  • how to define a data set;
  • how to add categories;
  • how to add series;
  • how to customize the chart to fit your purposes.
Graph Customization

In this tutorial I'm going to show you

  • how to format your chart (style, color, size etc.);
  • how to customize it in order to make it more legible and understandable for your audience;
  • how to add (and remove) useful chart elements.

Graph Formatting

So far we learned how to work with multiple worksheets concerning functions and formatting. Creating diagrams which draws data from multiple sheets is further powerful feature of Excel. In this lecture I'm going to teach you how to build those kind of charts from scratch.

Creating Graphs Featuring Multiple Worksheets

Creating graphs is not the only way of data visualization in Excel. In this video we are going to take a closer look at those options.


  • creating a customizing sparklines;
  • using conditional formatting rules for highlighting data.

Please note, that this course has another lecture on conditional formatting where you can find more information on that topic (Section: Database).

Further options for data visualization

The next two lectures are taken from another Excel course of mine. They are discussing the usage of various chart types which you might find helpful.

BONUS: Data visualization - which chart type to use - p1

BONUS: Data visualization - which chart type to use - p2
Illustrations in Excel
4 Lectures 20:27

In this lecture I'm going to show you the main types of illustrations Excel provides.

Illustrations in Excel

Illustrations can be formatted similarly to graphs. In this lecture we are going to walk through the different options, and I'm also going to show you specialities.

Formatting illustrations

In this lecture we are going to get familiar with the way Excel layers the illustration. We are going to learn how to alter that order, and also how to group those items for better control.

Order of illustrations

Caption boxes are a really fun feature of Excel. We can communicate data through them, and this data can be controlled by functions in the background. Really cool add-ons for questionnaires and informal forms.

Display Formulas with a Caption Box
8 More Sections
About the Instructor
R-Tutorials Training
4.4 Average rating
5,449 Reviews
60,168 Students
17 Courses
Data Science Education

R-Tutorials is your provider of choice when it comes to analytics training courses! Try it out – our 50,000+ students love it.

We focus on Data Science tutorials. Offering several R courses for every skill level, we are among Udemy's top R training provider. On top of that courses on Tableau, Excel and a Data Science career guide are available.

All of our courses contain exercises to give you the opportunity to try out the material on your own. You will also get downloadable script pdfs to recap the lessons.

The courses are taught by our main instructor Martin – trained biostatistician and enthusiastic data scientist / R user.

Should you have any questions, you are invited to check out our website, you can open a discussion in the course or you can simply drop us a pm.

We are here to help you boost your career with analytics training – Just learn and enjoy.