Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 Beginner Level Course to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 Beginner Level Course

Learn how to use Microsoft Excel 2016 from a beginner level and up with confidence
4.5 (155 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,019 students enrolled
Created by Hudson Courses
Last updated 2/2017
English
$10 $20 50% off
14 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 5 Articles
  • 10 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
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.
Description

This Microsoft Excel 2016 Beginner Level Course by Hudson is aimed at anyone considering using Excel 2016 for the first time or those 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. 

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 77 Lectures Collapse All 77 Lectures 03:25:23
+
About this Course
1 Lecture 01:17
+
Introduction to Microsoft Excel 2016
1 Lecture 01:49
+
Navigating your Way Around Excel
3 Lectures 07:16

6. Navigating your way around Excel - Part 3
01:20

6. Navigating your way around Excel - Part 4
02:17
+
Excel General Options
5 Lectures 08:54
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
+
QUIZ: Excel General Options
0 Lectures 00:00
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
+
Adding, Copying and Moving Worksheets
4 Lectures 08:12
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
+
QUIZ: Adding, Copying and Moving Worksheets
0 Lectures 00:00
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
+
Working with Cells, Columns and Rows
6 Lectures 09:53
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
41 More Sections
About the Instructor
4.5 Average rating
155 Reviews
2,019 Students
1 Course
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.


Report Abuse