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,582 students enrolled
25% off
Take This Course
  • Lectures 29
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

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!

What are the requirements?

  • Download a trial version of Microsoft Excel if you do not already have it.
  • Basic Understanding of Keyboard and Mouse
  • Nice Cup of Tea

What am I going to get from this course?

  • Create and Load Spreadsheets
  • Select Tables and Calculate Values
  • Create Multiple Sheets and Access Data from Them

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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Welcome To The Beginners Guide to Excel!
Section 2: The Basics

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


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


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.


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


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


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


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


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


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

Section 3: Charts, Forms and Formulas

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


In this lecture you can learn about cell formatting.


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


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


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


In this lecture you can learn about conditional formatting.


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


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


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


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.


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


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


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


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

Section 4: Modifications

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


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


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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Scott Kaine, 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!

Ready to start learning?
Take This Course