Microsoft Excel 2016 for Beginners: Master the Essentials

Learn the essentials of Microsoft Excel 2016 in easy to follow steps
4.2 (118 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.
1,606 students enrolled
$19
$70
73% off
Take This Course
  • Lectures 69
  • Length 9.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/2015 English

Course Description

Master Excel 2016 For Complete Beginners In This Helpful, Info-Packed Video Course

  • Easily learn Excel 2016 for complete beginners
  • How to get Excel and installation requirements
  • Helpful discussion of new features in 2016
  • Getting started with a Workbook
  • Entering and editing data
  • Creating charts and graphs
  • How to create functions
  • Protecting and securing your data
  • All lessons in easy step-by-step format
  • Practice with included exercise files

Excel 2016 From The Beginning

This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you from the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you're using Excel 2016 like a pro with advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business.

If most Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air. The videos keep things simple and carefully step you through each process.

Contents and Overview

This course starts with where to find Microsoft Excel and installing the program. Then you learn step-by-step, simple 1-2-3 methods for getting up and running with Excel 2016. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 32 chapters of video lessons and 9 exercise files to gradually become a proficient user.

It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them.

Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars, entering and editing data, backup and recovery, fill and series, and printing your projects. We also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

*** Updated February 2016. Course transcripts now available.

What are the requirements?

  • Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.

What am I going to get from this course?

  • Discover new and improved features in Excel 2016.
  • How to effectively use Excel 2016 on a touchscreen device.
  • How create, save, and open a workbook.
  • Learn how to personalize your use of Excel using Excel Options.
  • How to use and how to customize the Quick Access Toolbar.
  • Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • The basics of entering and editing data in a workbook.
  • Discover how to format dates and numbers.
  • Learn practical methods in which you can backup and recover your Excel spreadsheets.
  • Effectively use autofill and flashfill so you are more productive.
  • Discover the essentials of using fomulas and functions.
  • How to rename, insert, move, and reference an Excel 2016 worksheet.
  • Discover how to create charts and graphs
  • Learn practical methods to sort and filter your data
  • How to protect and secure your Excel data

What is the target audience?

  • Those new to using Microsoft Excel 2016.
  • No previous knowledge of Excel required. This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel.
  • Users of earlier versions of Excel looking to update their skills.

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: Introduction
Acquiring Excel 2016 and Information on Installation and Upgrade
Preview
12:02
IMPORTANT - Read this to ensure the best video quality!
Article
Course exercise files
Article
Course demo files
Article
Downloadable Course Transcripts
Article
Section 1 Quiz
1 question
Section 2: What's New
New and Improved Features in Excel 2016
Preview
02:55
Section 3: Using Touch
Overview of Principles of Using Touchscreen
Preview
05:36
Section 4: Getting Started
Creating and Saving a Workbook
Preview
15:16
Opening a Workbook
10:13
Section 5: Using Help
Online Help and Contextual Help
06:27
Section 5 Quiz
1 question
Section 6: Excel Options
Personalizing your use of Excel
10:50
Section 6 Quiz
2 questions
Section 7: The Ribbon and Toolbars
Basics of using the Ribbon
Preview
14:56
Quick Access Toolbar
05:45
Tell Me Feature
06:49
Mini Toolbars and Contextual Menus
03:47
Status Bar
05:02
Section 7 Quiz
2 questions
Section 8: Entering and Editing Data
Basics of Entering and Editing Data in a Workbook
13:29
Exercise 01
01:50
Formatting Dates
12:36
Formatting Numbers
13:48
Exercise 02
01:43
Section 8 Quiz
5 questions
Section 9: Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
07:35
Section 9 Quiz
1 question
Section 10: Fill and Series
Working with Fill and Series
Preview
09:09
Flash Fill
Preview
04:04
Section 10 Quiz
2 questions
Section 11: Viewing and Printing
Workbook Views, Zoom, and Freeze
08:41
Printing
14:30
Exercise 03
02:56
Section 11 Quiz
3 questions
Section 12: Cut, Copy, and Paste
Methods of Cutting, Copying, and Pasting
13:32
Section 12 Quiz
1 question
Section 13: Formatting a Worksheet
Delete and Clear
13:45
Insert, Hide, Column Width and Row Height, and Merge
12:46
Alignment
12:05
Themes and Styles
11:19
Exercise 04
01:44
Section 13 Quiz
4 questions
Section 14: Formulas and Functions
Course review
00:43
Basics of Fomulas and Functions
Preview
11:15
Complex Examples of Formulas
13:36
Exercise 05
03:25
Section 14 Quiz
1 question
Section 15: Managing Worksheets
Rename, Insert, Move, and Reference a Worksheet
08:40
Section 15 Quiz
1 question
Section 16: Working with Multiple Workbooks
Working with Multiple Workbooks
Preview
15:48
Section 16 Quiz
1 question
Section 17: Saving Workbooks
Saving in Different File Types
12:59
Section 17 Quiz
2 questions
Section 18: Proofing
The Spell Checker
13:11
Section 19: Inserting Comments
Inserting Comments
04:54
Exercise 06
03:02
Section 20: Basic Functions in Excel
The VLOOKUP Function
Preview
14:07
Text Functions
08:17
Date and Time Functions
06:47
Logical Functions
15:51
Section 20 Quiz
2 questions
Section 21: Graphs and Charts
Creating Graphs and Charts
Preview
12:10
Customizing a Cluster Column Chart
15:42
Customizing a Pie Chart
13:36
New Chart Types in Excel 2016
02:01
Exercise 07
02:28
Section 21 Quiz
2 questions
Section 22: Sorting and Filtering Data
Managing Data by Sorting
Preview
09:39
Managing Date by Filtering
11:59
Customizing Tables
13:23
Section 22 Quiz
3 questions
Section 23: Shapes and Pictures
Inserting Shapes and Pictures
15:00
Exercise 08
00:47
Section 23 Quiz
2 questions
Section 24: Formatting Cells Based on Content
Conditional Formatting
15:32

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course