Microsoft Excel 2016 for Beginners: Master the Essentials
3.9 (153 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,817 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 for Beginners: Master the Essentials to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 for Beginners: Master the Essentials

Learn the essentials of Microsoft Excel 2016 in easy to follow steps
3.9 (153 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,817 students enrolled
Created by Simon Sez IT
Last updated 4/2017
English
English
Current price: $10 Original price: $70 Discount: 86% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • 4 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
69 Lectures
09:40:34
+
Introduction
5 Lectures 14:52

Essential Information for a Successful Training Experience
01:36

Course exercise files
00:26

Course demo files
00:26

Downloadable Course Transcripts
00:21

Section 1 Quiz
1 question
+
What's New
1 Lecture 02:55
+
Using Touch
1 Lecture 05:36
+
Getting Started
2 Lectures 25:29

Opening a Workbook
10:13
+
Using Help
1 Lecture 06:27
Online Help and Contextual Help
06:27

Section 5 Quiz
1 question
+
Excel Options
1 Lecture 10:50
Personalizing your use of Excel
10:50

Section 6 Quiz
2 questions
+
The Ribbon and Toolbars
5 Lectures 36:19

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
+
Entering and Editing Data
5 Lectures 43:26
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
+
Backup and Recovery
1 Lecture 07:35
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
07:35

Section 9 Quiz
1 question
+
Fill and Series
2 Lectures 13:13
22 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
10,242 Reviews
293,161 Students
114 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ 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,500+ 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 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.