Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 - The ABSOLUTE BEGINNERS Guide to your Wishlist.

Add to Wishlist

Excel 2016 - The ABSOLUTE BEGINNERS Guide

Learning Excel Made Easy - Even Your Kids Can Do It!
4.3 (40 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.
2,581 students enrolled
Created by Scott Kaine
Last updated 3/2016
$10 $20 50% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

Hello and Welcome to the ABSOLUTE BEGINNERS Guide to Excel 2016!

For the duration of this course I will instruct you in learning Excel with step-by-step bite sized lectures that will slowly improve your understanding of this powerful program. The focus of this course is tailored to the user whom has had little or no experience within the excel spreadsheet environment.

The version of Excel used in this training course is 2016 for the Windows 7 operating system. Other operating systems such as Windows 8 and Windows 10 are also applicable for this course should you be using those instead. You will be following along with me during this course so you will need a copy of Excel or at the very least a trial version to follow along.

The course structure is designed to be followed quite easily and all materials being presented are also available in their completed form at the end of each section for your later reference. No prior experience in Excel from any version is required to start this course as the novice level is the intended audience, so start today!
Who is the target audience?
  • You are and absolute beginner at Microsoft Excel!
  • You wish to learn how to navigate around in Excel easier.
  • You want to be able to create simple spreadsheet calculations.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Create and Load Spreadsheets
Select Tables and Calculate Values
Create Multiple Sheets and Access Data from Them
View Curriculum
  • Download a trial version of Microsoft Excel if you do not already have it.
  • Basic Understanding of Keyboard and Mouse
  • Nice Cup of Tea
Curriculum For This Course
Expand All 29 Lectures Collapse All 29 Lectures 01:16:58
Welcome To The Beginners Guide to Excel!
1 Lecture 00:50
The Basics
10 Lectures 18:32

In this lecture you will discover what the function of the ribbon bar is along the top of Excel.

Preview 03:23

in this lecture you're going to learn about the quick access toolbar and how easy it is to use.

Preview 01:52

In this lecture you learn about the many different shapes and styles of the cursor.


In this lecture you will learn about how to use the help menu and the context menus.

Help Menu

In this lecture you can learn about the status bar and what its function is.

Preview 02:20

In this lecture you can learn the difference between a workbook and a worksheet.

Workbooks and Worksheets

In this lecture you can learn how to change the style of a border, fill and color.

Preview 02:00

In this lecture you're going to learn what the formula bar is.

The Formula Bar

In this lecture you can learn about how to enter data into a cell.

Preview 01:59

In this lecture you learn about the redo and the undo function of Excel.

Fixing Mistakes with Undo and Redo
Charts, Forms and Formulas
14 Lectures 47:55

In this lecture you learn about charts, their usefulness and their variety.


In this lecture you can learn about cell formatting.

Cell Formating

In this lecture you're going to learn about what formulas are and how they are used to calculate and sort data.

What are Formulas?

In this lecture you can learn how to copy formulas that you've already created and move them to different cells.

Copying Those Formulas

In this lecture you're going to learn how to change the format of the data that's in your cells.

Data Formating

In this lecture you can learn about conditional formatting.

Conditional Formating

In this lecture you going to learn how to place images or take desktop images and place them inside of your Excel worksheet.

Working With Images

In this lecture you're going to learn the difference between the static and a non static reference self.

Reference Cells - Static and Other

In this lecture you going to learn what a pivot table is and how it can be used.

Working with Pivot Tables

In this lecture you're going to learn about our fill and how it can be used to save you an enormous amount of time when creating worksheets.

Using Autofill

In this lecture you going to learn how to insert columns and rows within your worksheet.

Inserting Columns and Rows

In this lecture you going to learn how to use the sort function with your data.

Using the Sort Function

In this lecture you going to learn how to use a slicer table and discover its usefulness with varying types of data.

What is a Slicer Table?

In this lecture you going to learn how to use find and replace within the context of your worksheet or workbook.

Using Find and Replace
4 Lectures 09:41

In this lecture you going to learn how to add comments to your worksheet.

Adding Comments

In this lecture you want to learn how to password protect your worksheets and your workbooks, rows and columns.

Password Protecting Worksheets and Workbooks

In this lecture you going to learn how to print your pages.


In this workbook you're going to learn different things save and save as in regards to your worksheet and workbooks.

Saving Worksheets and Workbooks
About the Instructor
4.1 Average rating
95 Reviews
6,821 Students
5 Courses
Udemy Teacher 6,000+ Students, Performance Marketer

My name is Scott Beowulf Kaine and my steadfast commitment to learning has earned me not only a Bachelors Degree in Computer Science, but also two Masters' Degrees in both Psychology and Marketing. I have combined these skills in the corporate arena into building a path to success that has been highly rewarding and very lucrative. The methods that I am able to share here, I feel, are the blueprints of self sufficiency and financial security.

As a Corporate marketing business consultant, I have over 10 years experience in training sales leaders in making their mark in their respected industry; furthering not only their personal careers but enhancing personal growth in the process. My forte is not only limited to the area of traditional marketing however; I have been a part of many online and training programs along with graphic design and film production companies across the nation.

My exposure to training of both students and professionals alike, spans across the United States from California to Nevada to New York to Oklahoma. I’ve worked with talents in London to New Zealand and have trained sales leaders and scholars who are trailblazers in their firms to this very day. Allow me to help you in developing your visionary talents and dreams into an exceptional skill for your future!

I look forward to teaching you everything I have learned, and with time, hope to pass onto you all the skills and inspiration you need to become a successful and independent entrepreneur or simply just more informed then you were yesterday! The path to financial or personal success starts with a single step, as with anything, we all start somewhere and I would be honored if you started with me!

Report Abuse