Excel 2016 - Top Beginners Guide - Start Now
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.
869 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 - Top Beginners Guide - Start Now to your Wishlist.

Add to Wishlist

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.
869 students enrolled
Last updated 10/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 4 Articles
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
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.
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.
Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 40 Lectures Collapse All 40 Lectures 01:31:17
+
Introduction Video - Welcome, Welcome, Welcome
1 Lecture 03:25
+
Assumptions
2 Lectures 00:53
+
Proof that Excel Skills are crucial for getting a better job and more income
1 Lecture 00:00

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

Preview 4 pages
+
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
02:18

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
04:43

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
03:18

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

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
01:10

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

Quiz
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
04:45
+
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
00:46

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

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

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

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

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
03:21

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

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

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

Highlighting Cells
03:07

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

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

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

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
04:35

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

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

Section 5 Summary Slide
1 page

Final Word
00:08
+
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
02:35
About the Instructor
Reginald Reglus
4.8 Average rating
2 Reviews
869 Students
1 Course
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.