Excel 2016 - Top Beginners Guide - Start Now

Great Excel skills lead to more money, better opportunities and greater success.
4.8 (2 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.
868 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 40
  • 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 8/2015 English

Course Description

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.

What are the requirements?

  • 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.

What am I going to get from this course?

  • 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

What is the target audience?

  • 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.

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.

Curriculum

Introduction Video - Welcome, Welcome, Welcome
Preview
03:25
Section 1: Assumptions
Key assumptions
Preview
Article
Article

Website to download Excel 2016.

Section 2: Proof that Excel Skills are crucial for getting a better job and more income
4 pages

These are just two articles that highlight the importance of Excel skills for job-seekers and promotion-seekers.

Section 3: Gettting Started Right and Fast so you have a good foundation
02:18

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

04:43

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.

03:18

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.
1 page

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

03:23

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.
02:38

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

01:31

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.

01:10

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.
01:32

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
00:42

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

  • Select a Row;
  • Select a Column.
Quiz
3 questions
Section 3 Summary Slide
1 page
Section 4: The Ribbon
04:18

Get a basic overview of the Ribbon

04:45

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.
Section 5: Solving Problems Like an Excel Pro
02:19

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.
03:10

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.
00:46

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.
03:49

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.
01:31

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.
03:35

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.
02:56

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.
Quiz 2
3 questions
03:21

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;
02:37

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..


01:43

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.
01:33

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.
03:07

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

02:09

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.
02:02

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.
Article

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.


Section 4 Summary Slide
1 page
Section 6: Real World Example
Introduction to Section 5
Preview
00:55
04:35

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.
03:33

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.
01:54

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.
Section 5 Summary Slide
1 page
Final Word
Article
Section 7: Bonus Lectures
02:35

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Reginald Reglus, 30 year Entrepreneur, Business owner and Technology Trainer

I have been training people on Microsoft products for over 25 years. I have always been an independent trainer. In the days of CompUSA - a computer store from way back - I was one of the top computer trainers and requested throughout the CompUSA system. After performing so well, I decided to open my own training and computer consulting firm in the Wall Street area of NYC. I continued to successfully train and consult. I did so well I created a train-the-trainer program in which I trained up-and-coming trainers how to successful train others to use Microsoft products.

I love training others and giving them insight that makes them better at their jobs and their lives. I have taught at many levels and for varying size audiences. I have taught adults and young people. I have taught one-on-one and for audiences of over 400 people. I have taught in the classroom and online. All I need is an interested student and I become the consummate teacher.

Education: BA- Bowdoin College, MBA- The Wharton School of Business of the University of Penn.

Profession:Technology-Trainer, Business-Owner, Entrepreneur, Real Estate Agent.

Ready to start learning?
Take This Course