Excel 2016 - The Complete Excel Mastery Course for Beginners
4.6 (717 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.
6,263 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 - The Complete Excel Mastery Course for Beginners to your Wishlist.

Add to Wishlist

Excel 2016 - The Complete Excel Mastery Course for Beginners

Learn Excel 2016 (works for 2010 and 2013, too). Training in spreadsheets, formulas and functions, tables, pivot charts.
4.6 (717 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.
6,263 students enrolled
Created by Steve McDonald
Last updated 11/2016
English
English
Price: $100
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 5 Articles
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Become comfortable and familiar with the entire Excel dashboard, tabs and ribbons.
  • Learn all of the basics of opening an Excel document, creating a spreadsheet and saving your document to your computer.
  • Create a spreadsheet from scratch in Excel.
  • Use the most commonly used Excel functions to make powerful calculations.
  • Create your own Excel charts, graphs and tables.
  • Learn to use several of the new Excel 2016 features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature.
  • Create pivot tables and charts for lightening fast sorting and organizing.
  • Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016.
View Curriculum
Requirements
  • All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning.
Description

"Your Excel skills could land your next job."

- Fortune Magazine

A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't.

Are you ready to land your next job and increase your pay by 13%?

This course is designed to teach you the basics and beyond of Excel 2016. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.

Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine.

You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to:

  1. Create a basic Kitchen Remodel Costs worksheet.
  2. Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.
  3. Create professional looking pie charts, bar charts, column charts and more.
  4. Create a table and a range and sort your data.
  5. Create pivot charts and tables to do lightening fast analysis of your data.
  6. Learn to use new features of Excel 2016 including 1-click forecasting and 3D maps.
  7. Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve.

Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions, which you'll learn in this course:

  1. VLOOKUP
  2. COUNT & COUNTA
  3. COUNTIF & COUNTIFS
  4. AVERAGE & AVERAGEA
  5. SUM, SUMIF & SUMIFS
  6. IF
  7. LEFT, RIGHT & MID

Here are more of the most sought after skills in Excel that are included in this course:

  1. Spreadsheets
  2. Tables
  3. Ranges
  4. Pie, Column, Bar and Line charts
  5. Pivot tables
  6. Pivot charts
  7. Tons of tips and tricks to make using Excel 2016 easier every day.

So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the TAKE THIS COURSE button or check out one of the free preview lectures to see if it's the perfect fit for you.

Who is the target audience?
  • This course is perfect for a first time beginner who needs to learn much more than just the basics.
  • This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more.
  • This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job.
  • This course would not be useful for an Excel user who has already reached the advanced or expert stage.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 54 Lectures Collapse All 54 Lectures 05:22:57
+
Introduction to Excel 2016
4 Lectures 27:58

In this course you'll start out at the very beginning, opening an Excel document and saving it onto your computer. Then, you'll create your first Excel spreadsheet including data entry, formatting and even using simple formulas.

Once you've created your first spreadsheet you'll learn how to use the most popular Excel functions for powerful calculations. Next, you'll learn how to use some of the new features of Excel 2016, such as 3D Mapping and 1-Click Forecasting. Finally you'll learn how to create tables, charts, and graphs as well as pivot tables and charts.

When you are finished with this course you will have a solid working knowledge of the most commonly used features in Excel. The course includes Excel file downloads that you can use to follow along with the lectures. It also includes practical assignments along the way so you can put what you learn to use right away.

Preview 02:31

There are 3 things you can do to get more out of this course.

  1. Use the speed control to speed up or slow down lectures so you can best understand the audio
  2. Beginners, go through the whole course start to finish. Experienced Excel users should skip to the parts they need to learn.
  3. Download and use the Excel workbook provided. Practice with them as you go through the lectures.
Preview 06:44

This lecture is a complete tour of the various Excel dashboards and interfaces. It will show you how to use the tabs and ribbons at the top of an Excel workbook, how to navigate the file menu to save, print and customize documents in Excel. And it gives you a tour of the many features and tools available to you in Excel 2016.

Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
09:47

Templates are an often overlooked aspect of Excel. Using the right template can save you tons of time creating and formatting your own spreadsheets. It also allows you to take advantage of Excel tools and features that you wouldn't otherwise learn to use.

Even though templates are ready to use, they still require an understanding of the way Excel works. After you complete this course you'll not only be able to create and use many Excel functions and features, you'll also be able to better utilize templates because you'll have the understanding to use them correctly and even to modify them to best suit your needs.

Using Excel Templates to Save Time and Effort
08:56
+
Creating Your First Excel Document
5 Lectures 21:43

The first step to successfully creating your first spreadsheet is opening and saving a document. This lecture will show you how to do that and how to save it to a place where you can find it later.

Preview 02:42

Quickly learn how to enter data into cells in your worksheet and move from cell to cell.

Preview 02:52

Learn how to create simple but powerful addition and multiplication formulas. These will prepare you to do the calculations neccessary for the Kitchen Remodeling Cost worksheet later in the course.

Creating Simple Formulas to Do Powerful Calculations
07:03

In this lecture I'll show you the difference between a workbook and a worksheet. I'll also teach you various ways of moving, copying, renaming and managing your worksheets within, and between different workbooks.

Working with Workbooks and Worksheets
08:42

Activity. Now it's time to put what you have learned into practice.

Put Your Knowledge to Work - Create Your First Excel Document
00:24
+
Create a Kitchen Remodel Cost Worksheet
5 Lectures 19:20

First, in this lecture I'll give you a quick tour of the finished product of the Kitchen Remodel Costs Worksheet. Then I'll show you how to create and format your heading.

Note: You can download the finished worksheet here so you can practice creating and changing the formatting and formulas used in this section.

Preview 03:24

In this lecture, first, you'll learn how to add subheadings to your columns and format them. Then you'll learn how to enter your list of materials into your first column and sort the list alphabetically.

Formatting Subheadings and Columns and Alphabetizings Lists
03:28

Now it's time to enter your quantities and costs and format them to look like numbers and dollar amounts.

Entering and Formatting Numbers
02:55

In this lecture I'll show you how to use the multiplication and addition formulas that we learned earlier to calculate your total costs for each of your materials, as well as a grand total for the entire remodeling project.

Create Formulas to Quickly Calculate Your Costs
06:08

In this lecture I'll show you how to do some final formatting to your worksheet. I'll show you how to add a few more colors and add grid lines to your worksheet to define your data a little bit more.

Formatting - Grids and Spacing
03:25
+
Introduction to Excel Formulas and Functions
3 Lectures 14:32

There is a lot to learn in this section. This lecture gives you an overview of all of the different functions you are going to learn including:

  • AVERAGE & AVERAGEA
  • COUNT & COUNTA
  • IF
  • SUMIF & SUMIFS
  • COUNTIF & COUNTIFS
  • VLOOKUP
  • LEFT, RIGHT & MID
Preview 04:00

This lecture defines a formula and shows you how a formula can help you do calculations in Excel.

What is a Formula and What Can It DO for You?
02:00

A function is a piece of pre-defined code that you can use as part of your formula to increase the power of your calculations. This lecture shows you the power that a function has over simple formulas. It also shows you where to find functions and how to use them.

What is a Function and What Does IT Do?
08:32
+
3 Things to Know Before You Start Using Functions
3 Lectures 17:13

In this lecture I break down a basic formula into 6 main parts and show you how each part behaves as part of a formula.

The anatomy of an Excel formula is all of the numbers, words and symbols that make up a formula. These are all very important to understand because it enables you to create, modify or correct formulas to do the big calculations for you, saving you lots of time and effort.

This lecture will answer these questions:

  • What is the equals sign for in an Excel formula?
  • What do the parentheses do in an Excel formula?
  • How do you write the cell reference as a range of cells?
  • What is an operator?
  • What order of operations does Excel follow?
Preview 06:35

This lecture will show you some strategies and shortcuts to quickly and easily select cells for use in your formulas.

Preview 03:46

Most formulas that you create in Excel reference relative cells by default. However, by creating absolute cell references you can incorporate a fixed cell into your equation while still being able to copy the formula to other cells. This lecture will show you the difference between absolute and relative cell references, and it will show you

useful ways to use them in formulas.

Absolute vs. Relative Cell References
06:52
+
How to Use the 7 Most Popular Excel Functions
8 Lectures 53:16

You will learn so much faster and remember what you learn longer if you use the downloads in this course to follow along with the lectures. By using the downloads you'll have the same Excel file open that I'm using in the lecture, so you can enter formulas and do calculations right along with me.

How to Use the Downloads to Learn Functions Faster
04:14

The average of a list of numbers is the the total of the list, divided by the number of numbers in the list. This lecture shows you how to use the AVERAGE function as well as how to use the AVERAGEA function when you have a non-numerical value in the list.

Preview 03:04

The COUNT and COUNTA functions will tell you how many cells in your selected range have data in them. COUNT tells you how many cells have a number in them. And COUNTA tells you how many cells have any entry, whether it is a number or text. In this lecture I'll show you how these functions would be useful for determining the active number of sales reps in a list.

COUNT, COUNTA and COUNTBLANK Functions
04:05

The IF function is a simple but powerful calculating tool. Essentially the IF function says, "If ____ is true, display this result. If _____ is not true, display this other result."

The result could be a number, text or a complex calculation.

This lecture will show you how to use the IF function in Excel using both text and a numerical calculation.

IF Functions
09:36

Just like the SUM function, the SUMIF and SUMIFS functions are adding numbers in a range of cells. The difference is that these functions can be set up to only add up the numbers that meet certain criteria in another selected range of cells.

SUMIF works with one other range of cells and SUMIFS works with multiple conditions and multiple ranges of cells.

SUMIF and SUMIFS Functions
06:22

In Excel, the COUNTIF and COUNTIFS functions are similar to the SUMIF and SUMIFS functions in that they allow you to do a calculation that takes additional criteria into account.
COUNTIF and COUNTIFS Functions
04:26

The VLOOKUP function is one of the most popular functions in Excel. It takes a little bit of getting used to, but once you master this function you can do powerful searches and sort through massive amounts of data in vertical lists. This lesson will show you:

  • The rules you need to follow to successfully create a VLOOKUP function.
  • How to create a table so you can add rows to your data and your VLOOKUP will still find your new data.
  • How to use the VLOOKUP function to pull data from a vertical list.
VLOOKUP Function
12:35

The LEFT, RIGHT and MID functions in Excel, allow you to sort data quickly and easily from a fixed width string. A fixed width string is a set of numbers in a list that all contain the same number of characters and that all follow the same format.

For example, in the rep ID Code 1JEA from our lesson:

  • The 1 is the rep ID number
  • The J is the rep's first initial
  • The E stands for East region
  • The A is the rep's sales group

You'll see in the lecture that all of the rep ID codes follow the same format and have the same number of characters. That allows us to use the LEFT, RIGHT and MID functions to sort that code into a number of other columns that make the data easier to read and to use.


LEFT, RIGHT and MID Functions
08:54
+
Other Popular Excel Functions
7 Lectures 44:46

Many students of Excel have told me that Concatenate is their number one favorite function. Concatenate basically just combines text from different cells into one cell. This can save you a ton of time doing monotonous data entry.

For example, if you have a column of first names and a column of last names, you can quickly and easily combine them into a third column using the Concatenate function.

You can take Bob and Smith and combine them to say Bob Smith.

CONCATENATE - Combining Text
04:36

The LEN function in Excel basically just counts the number of characters in a string of text. LEN is not used on it's own very often, but when used in conjunction with other functions it can be a huge time saver.

LEN - Length of Text
03:04

The FIND and SEARCH functions in Excel are very similar to each other. Both are designed to search for any given character or string of characters within a given string and return a number indicating where it begins within that string. The main difference between the two is that SEARCH is not case sensitive and FIND is case sensitive.

For example, if you want to find the word "West", the SEARCH function will find it even if you are searching for "west", while the FIND function will not unless you look for the word "West".

FIND and SEARCH
03:52

Min and Max will bring back the minimum or maximum number from a selected range of cells. In this lecture I show you how to use them. I also show you how to create an array formula that does calculations on multiple columns of cells. We'll combine the Min and Max functions with an IF function to search first by a sales rep's name and then bring back the Min and Max of that rep's sales.

MIN and MAX
04:54

The AND and OR functions are simple functions that compare two logical arguments. Alone, they are pretty basic, but nested within an IF function they can be quite powerful.

In this lecture I'll show you how to use both the AND and OR functions. Then I'll show you how to next an AND function within an IF function to bring back more relevant and intuitive results in your spreadsheet.

AND and OR
06:10

In this lecture I'll teach you how to use 5 different rounding functions:

  1. ROUND
  2. ROUNDUP
  3. ROUNDDOWN
  4. CEILING
  5. FLOOR

These are very powerful functions that can be used not only to round numbers, but to catch and fix math errors when working with dollars and cents, and to calculate prices quickly and easily.

ROUND, CEILING and FLOOR
13:24

Conditional formatting is amazing. It applies simple formatting such as colors or icons to your cells based on the values in your cells. It can apply colors based on which cells are greater than or less than a number. It can even apply different colors based on formulas that you create. And that's not all it does. Once you've added conditional formatting to a range of cells you can then sort the entire range according to your formatting for quick analysis and organization of your data.

In this lecture I'll show you how to use conditional formatting in Excel and how to use conditional formatting within a table to quickly sort and analyze your data.

Conditional Formatting
08:46
+
Creating Charts From Your Spreadsheet
6 Lectures 37:20
Charts Download
00:09

Charts take boring data and turn it into a visual story. In this lecture I'll show you some of the possibilities of what you can do with charts and then we'll dive right into creating a chart from our Kitchen Remodel Costs worksheet.

Preview 07:14

Now that you've created a chart, let's do some formatting to make it look awesome!

In this lecture I'll show you how to resize your chart, change the color and width of your columns, add and delete different elements from your chart and how to change the title. At the end of this lecture you'll be able to create a beautiful, professional looking chart from your spreadsheet.

Format Your Chart
07:13

A bar chart in Excel is basically a column chart turned on it's side. The benefit of a bar chart is that it adds emphasis to differences in values because the bars stretch farther across the page.

In this lecture we'll create a bar chart and we'll do some additional formatting to it to make the data really stand out.

Create a Bar Chart
05:54

Pie charts are great for showing percentages and how each individual part relates to the whole. In this lecture I'll show you how to create a pie chart in Excel from scratch. I'll also show you how you can easily convert an existing chart, such as the bar chart we created in the previous lecture, into a pie chart to save on formatting.

Create a Pie Chart
11:36

Line charts are best used to represent the change in a value over time. A good example of this is monthly sales numbers for a whole year. In this lecture I'll first show you how to quickly change our existing bar chart into a line chart. Then I'll show you how to use a new spreadsheet containing dates and sales numbers so you can see the best use of a line chart in Excel.

Create a Line Chart
05:14
+
Pivot Tables and Pivot Charts
6 Lectures 44:05
Pivot Tables Download
00:04

Preparing your data is very important to the success of your pivot tables. In this lecture I'll show you how to clean up your data, put it in the proper format and organize it so that it will work well in a pivot table or pivot chart. Then we'll create a simple pivot table using the recommended pivot tables tool in Excel 2016.

Introduction to Pivot Tables - Preparing Your Data
11:07

Pivot tables can be intimidating, and the reason is that many people don't understand the 4 main parts of a pivot table and how they work. In this lecture I'll show you exactly where those parts are in the pivot table and what they do.

In the process I'll show you how to test and build a pivot table using all 4 parts. In the next lecture we'll really get to work using pivot tables to create quick calculations.

How to Create a Pivot Table
12:13

Now we're ready to put our pivot tables to work to do some fast calculations. In this lecture I'll show you a bunch of different ways that you can use your pivot table to quickly sort and organize your data. I'll also show you some formatting tips and general tips to make using pivot tables quicker and easier.

Put Your Pivot Table to Work
13:37

Attached is a pivot table download that you can use to follow along with the lectures.

Pivot Charts Download
00:07

With Pivot Charts you can take the data from your pivot table and make it visually appealing. The awesome thing about Pivot Charts is that when you make changes to your pivot table it instantly changes your chart as well.

In this lecture I'll show you how to quickly create a Pivot Chart in Excel 2016 and I'll demonstrate how it changes as you change your pivot table.

Pivot Charts
06:57
+
New Features for Excel 2016
5 Lectures 38:19

There are lots of new features in Excel 2016. Among them are 3D Maps, 1-Click Forecasting, Share and Get and Transform. In this lecture I'll show you where to find each one and what it does. Later in the course I'll go into more detail with a few of the more important and interesting new features.

Preview 05:24

This lecture introduces you to the 6 new chart types for Excel 2016. These include:

  1. Histogram
  2. Pareto
  3. Treemap
  4. Sunburst
  5. Waterfall
  6. Box and Whisker

You'll see a preview of each of the charts as well as a detailed understanding of what each chart can be used for in a practical application.

6 New Chart Types for 2016
10:36

Essentially, the "Tell me what you want to do" feature is where you go for help in Excel 2016. Depending on what you type in, it will bring up functions and features of Excel that you can access directly, or it will bring up a list of help topics for further reading.

This lecture will show you the in's and out's of this feature and will help you to use it effectively.

"Tell Me What You Want To Do" - The New Help Feature
03:23

The new 1-click forecasting button allows you to create forecast sheets and charts quickly and easily. Once you click the button, it will also bring up a convenient dialogue box that allows you to change these options in your chart: seasonality, confidence intervals and forecast starting and ending dates.

1-Click Forecasting
06:23

Learn about some of the best new features of Excel 2016. This lecture shows you how to use the newly integrated 3D maps feature in Excel 2016. This feature is fun and easy to use. I'll show you a 3D maps tour that I created and then take you step by step through how I created it so you can create one for yourself. 3D maps is a graphically exciting feature, but it isn't just for fun. It has power data visualization and computing power build in, too.

3D Maps
12:33
1 More Section
About the Instructor
Steve McDonald
4.4 Average rating
2,579 Reviews
40,277 Students
16 Courses
Dedicated Instructor Will Show You How | 40,000 Students

Learning is easier if you are given the right tools and instruction. In every one of my courses I take my students step-by-step through the tools and knowledge they need to accomplish their goals.

Whether I am teaching How to Publishing Kindle eBooks, How to Learn Excel, or How to Create Killer Content for the Web I always share an inside view of my knowledge about the subject. You get access to all of my secrets.

For over 10 years I have studied strategies to create passive income and how to use passive income to vastly improve the quality of your life.

I have tested many different strategies from investing in rental real estate to building niche websites about my hobbies to publishing Kindle eBooks. I have studied what works and what doesn't work, and I have narrowed my research down to the strategies that work the best for creating financial freedom and an improved quality of life.

Each of my courses is designed to share my hard-earned secrets with you. 

I hold nothing back. I won't bore you with all of the strategies that didn't work. I'll get right into the exact steps that I have taken to be successful so that you have the opportunity to replicate them.

Of course, it's no secret that one of my favorite ways to generate truly passive income is through publishing Kindle eBooks. I have published over 100 eBooks and published five of those in print. Many of my books have been bestsellers including my own pottery book The Despicable Five.

Once I developed my Kindle publishing system, learned some formatting secrets, and learned how to use some simple SEO skills, publishing eBooks became remarkably simple.

Even hiring writers, which would seem scary at first, is really easy and even fun when you follow my system. 

Using my system, you can publish one or two books and then roll the profits from them into hiring people to write more books for you, so you aren't taking any money out of your pocket.

It starts out as a little passive income snowball and as you add the profits back into the snowball it grows and grows until you are seeing a surprising and exciting amount of passive income.

I retired in 2014 thanks to my eBook publishing success. Now, I'm using my spare time to find the best ways to create passive income. As I find great ways to make money from home I'm more than happy to share what I learn with you.

You'll notice that my new favorite way to create passive income is teaching courses on Udemy. Check out my Udemy Course Creation course to see why I love it so much!

I am here to guide you on your way to success. You can contact me at any step of the way for assistance, even if you're unsure whether my course is the perfect fit for you. Let me know your concerns and I'll point you in the right direction, even if it's to someone else's course.

I'm always happy to help.

Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy for you.

Sign up for a course today! I'll see you in there.