Excel 2016 - Top Beginners Guide - Start Now
4.6 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
875 students enrolled

Excel 2016 - Top Beginners Guide - Start Now

Great Excel skills lead to more money, better opportunities and greater success.
4.6 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
875 students enrolled
Created by Reginald Reglus
Last updated 10/2015
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 4 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Feel confident that they understand some Excel fundamentals
  • Add, delete, hide and resize columns and rows manually and using autofit.
  • Understand and add to sparklines to a spreadsheet to enchance its value
  • Sort and filter data to make it useable
  • Take raw data and turn it into a business ready presentable file
  • Apply common formatting to a worksheet
  • Effectively use autofill and flashfill so you are more productive
  • Students should have the Excel 2016. While some things of very similiar in older versions of Excel, to get the best results download the latest version. While you can learn some things from just watching the videos, to get the highest results you really need to follow along.

Course Description

Learn key concepts and skills that you will need to build proficiency in Microsoft Excel so you will be prepared to get a job, secure a promotion or just be a better entrepreneur.

Build a strong foundation in Excel (which is proven to be an important job and business skill) with this tutorial specifically designed for beginners. Learn about:

  • Entering and Editing Data Fast;
  • Selecting Ranges Wisely;
  • Using Key Formatting Tools Efficiently;
  • Inserting Charts and Sparklines Quickly;
  • Solving A Common Business Assignment Effectively;
  • And Much More

A Powerful Skill at Your Fingertips Learning the fundamentals of Excel puts a powerful and very useful job securing tool at your fingertips. Excel is easy to learn and is essential to many jobs in this knowledge-based economy.

Knowing how to use Excel can be a key factor in determining whether you get a job or secure a promotion. You can learn Excel and I make it easy for your by giving you job relevant skills and using real world scenarios to keep it interesting for you.

Content and Overview Designed specifically for beginners who want a to get right to the important material. Through this course you'll learn some of the fundamentals and establish a strong understanding of the how to work smart in Microsoft Excel.

Starting with identifying the elements on a worksheet, this course will take you through some basic Excel Skills like inserting columns and entering data quickly to completing a real world business assignment using Excel. By working with these lessons, you'll a establish a strong understanding of the basics of Excel.

Students completing the course will have the knowledge to create and manipulate a basic Excel spreadsheet quickly and with ease.

It is important that you work alongside the author as you work through each concept as this will give you the confidence and knowledge to move on to the next level.

What am I going to get from this course?

  • Learn some of the fundamentals of Microsoft Excel 2016.
  • Short videos that each deal with only a few concepts to make it easy to digest.
  • Suitable for beginners in Excel and ideal for users who learn faster when shown.
  • Visual training method, offering users increased retention and accelerated learning.
  • Real World assignment to increase retention in adult students.
Who this course is for:
  • The Excel 2016 course is for absolute beginners in Excel who really want to take the first step to learning how to become effective and efficient at using Excel 2016. You will understand not just what to do by why you do it. This is not for intermediate or advanced users of any version of Excel. It is also not for those who want to compare this version of Excel with previous versions.
Course content
Expand all 40 lectures 01:31:17
+ Gettting Started Right and Fast so you have a good foundation
11 lectures 21:15

Here you will learn how to open a blank workbook. You will also see that there are multiple templates available for you.

Opening A Blank Workbook

Here you will get a tour of the spreadsheet window so you can discover where different tools and commands are located. Tools and commands help you get the most from Excel.

Understand the Excel Window - Locate your tools

Learn the different parts of an Excel Worksheet. Here you will learn:

  • The definition a cell
  • How to navigate to the very bottom of a Worksheet
  • How to navigate to the far right of a worksheet
  • The definition and use of the name box and the formula bar
  • How to create more worksheets to your spreadsheet file.
Understand Worksheet Layout

Learn the three broad categories of data you can enter into Excel: Text, Numbers, Data and Time.

Master Excel Data Types Now
1 page

Learn how to enter data into a worksheet and how to identify different data types. You will learn:

  • How to open a previously saved spreadsheet;
  • Using the autocomplete feature;
  • The difference between using the enter key and the arrow keys to enter data.
Preview 03:23

Learn different ways of editing data if you want to change it quickly.

Correct Mistakes - Learn How To Edit Data Fast

Learn how to safely remove information from your worksheet. Learn how to remove the data after it is entered or while you are entering it.

Preview 01:31

Learn how to select the specific set of data on which you desire to work. This is key in Excel as you may not want to apply the same commands and formats to all the data on the worksheet.

In this video you will learn:

  • How to select a range;
  • Why there is always one cell that looks like it is not selected.
Selecting a Range- So you can work on the intended data

Learn how to select non-contiguous ranges. In this video you will learn how to:

  • Why you may need to select non-contiguous ranges
  • How to select a non-contiguous ranges
Preview 01:32

Learn how to select a whole column or row quickly. In this video you will learn how to:

  • Select a Row;
  • Select a Column.
Selecting a Column or a Row
3 questions
Section 3 Summary Slide
1 page
+ The Ribbon
2 lectures 09:03

Get a basic overview of the Ribbon

Preview 04:18

In this video you will learn:

  • How to customize the quick access window;
  • How to show all or parts of the Ribbon;
  • How to auto-hide the Ribbon.
Customizine the Quick Access Toolbar
+ Solving Problems Like an Excel Pro
16 lectures 35:05

Learn a key secret to using Excel quickly. Many people overlook the power of this feature.

In this video you will learn:

  • Why I think the context sensitive menu can be the key to solving many Excel problems;
  • How to use the context sensitive effectively;
  • What the term "context-sensitive menu" means when you are working with Excel.
Preview 02:19

Learn how to insert a column in Excel and when this can be useful.

In this video you will learn how to:

  • Insert a column using the context sensitive menu;
  • Insert a column using the Insert command on the Ribbon;
  • What to look out for if you insert a column using the Ribbon command.
Preview 03:10

Learn how to insert a row in Excel and when this can be useful.

In this video you will learn how to:

  • Insert a row using the context sensitive menu.
Inserting A Row

Autofit and Autofill are key productivity tools in Excel and using them effectively is critical to become a proficient Excel user.

In this video you will learn how to:

  • Use autofit to quickly change the size of a column;
  • Use autofill to quickly fill in a range of data;
  • Review functions to make sure they update.
Using AutoFit and AutoFill

We all make mistakes. Know the different ways to edit data in Excel can be helpful.

In this video you will learn how to:

  • Edit data by double-clicking;
  • Edit data using a keyboard command;
  • Edit a large string of data.
Editing data When You Have Made a Mistake

Learn how to add functions to a worksheet.

In this video you will learn:

  • How to insert a function using the Fx button;
  • How to create a sum;
  • How to create an average;
  • How to tell Excel which data to use in a function.
Using the Sum and Average Function

Learn about deleting and hiding columns of data. Please note that this also works on rows.

In this video learn:

  • How to delete a row of data;
  • What happens to calculated data when you delete some input;
  • How to delete a column of data;
  • What happens to adjacent columns and rows when you delete a column or row;
  • How to hide or unhide a column or a row.
Deleting and Hiding Columns
Quiz 2
3 questions

Learn how to format your worksheet:

In this video you will learn:

  • How to select a range using the keyboard;
  • How to change the font size of your data;
  • How to make your text bold;
Making your file Presentable

Learn how to move data from one place on your worksheet to another.

In this video you will learn:

  • How to cut data;
  • How to paste data to another location;
  • If hidden columns and rows receive formatting..

Moving data using cut and paste

Learn how to change the width of multiple columns quickly using autofit.

You will learn:

  • How to properly select columns that you want to autofit;
  • How you mouse pointer must look to get autofit to work.
Preview 01:43

Learn how to successfully use the text wrap feature when the data is too long for the column.

In this video you will learn:

  • How to manually change the width of a column;
  • How to use the text wrap feature.
Using the text wrap feature

Learn how to add color to cells to make them stand out from the rest of the worksheet.

Highlighting Cells

Learn how to put the power of flash fill to work for you when entering data.

In this video you will:

  • Review how to insert a column;
  • How to start the flash fill function;
  • How to end the flash fill function.
Using the flash fill feature

Learn how to insert and move a chart to your worksheet.

In this video you will learn;

  • How to select the data for your chart;
  • How to access the chart functions;
  • How to insert a chart;
  • How to re-position a chart.
Inserting a chart so you can display your data visually.

It is very important that you have followed along and performed each task in each lecture. If you have not done so, please go back and listen to each of the previous lessons and perform each skill learned on the downloadable file in lecture 8. For your convenience I have provided a copy for the finished file in lecture 26.

If you want to have the richest experience and gain the most from this course, please do not proceed to the next section until you have mastered the tasks in all the proceeding lectures.

Thank you! I sincerely believe in you and want you to succeed.

Important: Please read
Section 4 Summary Slide
1 page
+ Real World Example
6 lectures 11:05

In this video you will learn:

  • How to create a new worksheet;
  • How to add a name to a worksheet;
  • How to copy data from one worksheet to another;
  • The importance of keeping your original set of data intact;
  • How to sort data alphabetically;
  • How to create a custom sort.
Solution Step 1

In this video you will learn:

  • Why use a second level sort;
  • How to do a second level sort;
  • How to add totals to a worksheet;
  • How to add subtotals to a worksheet.
Solution Step 2

In this video you will learn:

  • Why sparklines are an important tool for visually displaying data;
  • How to insert a sparkline;
  • How to read a sparkline;
  • How to use autofill to quickly create other sparklines.
Solution Step 3
Section 5 Summary Slide
1 page
Final Word
+ Bonus Lectures
1 lecture 02:35

Learn how to put you spreadsheet in audit mode so you can make sure your formulas are correct.

Bonus Lecture 1 - Auditing Formulas