Microsoft Excel 2016 Beginner Level Course

Learn how to use Microsoft Excel 2016 from a beginner level and up with confidence
4.4 (19 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.
713 students enrolled
Free
Start Learning Now
  • Lectures 77
  • Length 3.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 11/2016 English

Course Description

This Microsoft Excel 2016 Beginner Level Course by Hudson is aimed at anyone considering using Excel 2016 for the first time or those that are just wanting to refresh or upgrade their current Excel skills.


At the beginning, this course covers simple topics such as:


  • What can Excel 2016 do for you?
  • Understanding common terms used in Excel and the world of spreadsheets
  • Finding your way around Excel
  • Saving and printing your work
  • Understanding formulas and why people create them; and
  • What’s new in Excel 2016

 

The course then progresses onto more complex subjects such as performing basic calculations and using cell references, understanding how to use Autofill and Flash Fill options, analyzing and editing data, understanding data visualization, working with paste special commands, getting to grips with the view options, and building sparklines, plus much more. The course is presented in logical order starting from the bare basics.


Animations are used during the introductory stages to bring the course to life and help the learner to better absorb information. Lessons are taught with the add of video capture software. You can see exactly what parts of Excel 2016 the tutor is referring to when delivering the lesson, whether it be a spreadsheet or save menu.


This course also includes quizzes and project files to practice your skills and test your knowledge. 

What are the requirements?

  • You must know how to use a PC or Mac desktop computer, or a laptop.
  • Parts of this course require a keyboard and mouse, such as the project work.
  • In order to use the project files, you will need a copy of Microsoft Excel 2016. If you do not have a copy of Excel 2016, free one month trial versions can be found over the Internet.

What am I going to get from this course?

  • Understand common terms used in Excel and spreadsheets
  • Learn how to add, copy and move worksheets
  • Learn how to work with cells, columns and rows
  • Learn how to conduct basic formatting
  • Understand Autofill and Flash Fill options and how to use them
  • Understand workbook view options and how to use them to your advantage
  • Learn how to save workbooks the correct way
  • Perform basic calculations and use cell references
  • Learn how to work with comments
  • Learn how to optimize data using the Autofilter feature
  • Learn how to conduct basic sorting methods
  • Learn how to use the subtotal function to analyze data
  • Learn how to search and edit data effectively
  • Understand data visualization and how best to use it
  • Learn how to build basic charts
  • Understand chart elements
  • Learn how to build sparklines

What is the target audience?

  • This Microsoft Excel 2016 Beginner Level Course by Hudson is aimed at anyone considering using Excel 2016 for the first time or those that are just wanting to refresh or upgrade their current Excel skills.
  • This course can also be taken by individuals who consider themselves as Excel novices

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

Section 1: About this Course
About this course
01:17
Section 2: Course Introduction
1. Introduction to your tutor
00:43
2. Introduction to the course
00:29
3. Who is this course for?
00:56
Section 3: Introduction to Microsoft Excel 2016
4. What can Excel 2016 do for you
01:49
Section 4: Understanding Common Terms used in Excel and Spreadsheets
5. Understanding common terms used in Excel and spreadsheets - Part 1
00:54
5. Understanding common terms used in Excel and spreadsheets - Part 2
00:56
5. Understanding common terms used in Excel and spreadsheets - Part 3
01:08
5. Understanding common terms used in Excel and spreadsheets - Part 4
00:34
5. Understanding common terms used in Excel - Part 5
00:44
5. Understanding common terms used in Excel and spreadsheets - Part 6
00:20
Section 5: Navigating your Way Around Excel
6. Navigating your way around Excel - Part 1
03:39
6. Navigating your way around Excel - Part 3
01:20
6. Navigating your way around Excel - Part 4
02:17
Section 6: Excel General Options
7. Excel general options - Part 1
02:47
7. Excel general options - Part 2
00:57
7. Excel general options - Part 3
02:09
7. Excel general options - Part 4
01:41
7. Excel general options - Part 5
01:20
Section 7: QUIZ: Excel General Options
Excel general options - Question 1
1 question
Excel general options - Question 2
1 question
Excel general options - Question 3
1 question
Excel general options - Question 4
1 question
Section 8: Adding, Copying and Moving Worksheets
8. Adding, copying and moving worksheets - Part 1
01:21
8. Adding, copying and moving worksheets - Part 2
02:29
8. Adding, copying and moving worksheets - Part 3
02:27
8. Adding, copying and moving worksheets - Part 4
01:55
Section 9: QUIZ: Adding, Copying and Moving Worksheets
Adding, copying and moving worksheets - Question 1
1 question
Adding, copying and moving worksheets - Question 2
1 question
Adding, copying and moving worksheets - Question 3
1 question
Adding, copying and moving worksheets - Question 4
1 question
Adding, copying and moving worksheets - Question 5
1 question
Adding, copying and moving worksheets - Question 6
1 question
Section 10: Working with Cells, Columns and Rows
9. Working with cells, columns and rows - Part 1
01:08
9. Working with cells, columns and rows - Part 2
02:07
9. Working with cells, columns and rows - Part 3
02:13
9. Working with cells, columns and rows - Part 4
01:00
9. Working with cells, columns and rows - Part 5
01:51
9. Working with cells, columns and rows - Part 6
01:34
Section 11: QUIZ: Working with Cells, Columns and Rows
Working with cells, columns and rows - Question 1
1 question
Working with cells, columns and rows - Question 2
1 question
Working with cells, columns and rows - Question 3
1 question
Working with cells, columns and rows - Question 4
1 question
Working with cells, columns and rows - Question 5
1 question
Working with cells, columns and rows - Question 6
1 question
Section 12: Excel Basic Formatting
10. Excel basic formatting - Part 1
04:53
10. Excel basic formatting - Part 2
04:19
10. Excel basic formatting - Part 3
02:05
10. Excel basic formatting - Part 4
03:02
10. Excel basic formatting - Part 5
02:34
Section 13: QUIZ: Excel Basic Formatting
Excel basic formatting - Question 1
1 question
Excel basic formatting - Question 2
1 question
Excel basic formatting - Question 3
1 question
Excel basic formatting - Question 4
1 question
Excel basic formatting - Question 5
1 question
Excel basic formatting - Question 6
1 question
Section 14: QUIZ - Basic Formulas and Functions
Basic formulas and functions - Question 1
1 question
Basic formulas and functions - Question 2
1 question
Basic formulas and functions - Question 3
1 question
Basic formulas and functions - Question 4
1 question
Basic formulas and functions - Question 5
1 question
Basic formulas and functions - Question 6
1 question
Section 15: Autofill and Flash Fill Options
11. Autofill and flash fill options - Part 1
06:14
11. Autofill and flash fill options - Part 2
02:27
Section 16: QUIZ: Autofill and Flash Fill Options
Autofill and Flash Fill options - Question 1
1 question
Autofill and Flash Fill options - Question 2
1 question
Autofill and Flash Fill options - Question 3
1 question
Autofill and Flash Fill options - Question 4
1 question
Autofill and Flash Fill options - Question 5
1 question
Section 17: Workbook View Options
12. Workbook view options - Part 1
05:51
12. Workbook view options - Part 2
02:41
Section 18: QUIZ: Workbook View Options
Workbook view options - Question 1
1 question
Workbook view options - Question 2
1 question
Workbook view options - Question 3
1 question
Workbook view options - Question 4
1 question
Workbook view options - Question 5
1 question
Workbook view options - Question 6
1 question
Section 19: Saving Workbooks
13. Saving workbooks
04:47
Section 20: QUIZ: Saving Workbooks
Saving workbooks - Question 1
1 question
Saving workbooks - Question 2
1 question

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Hudson Courses, The Leaders in Learning

Our mission is to provide top quality educational courses and the best possible service. We put our customers’ needs before anything else. If there’s something we can do to help our customers, we’ll climb mountains to do it.


Our customers come from all sorts of backgrounds such as manufacturing, retail, finance, transportation, energy, and technology. We are trusted by some of the biggest brands on the planet.


Our tutors have extensive experience in their subject areas. Giving you the peace of mind that you're being tutored by the best.


Ready to start learning?
Start Learning Now