Microsoft Excel 2016 Training: Beginner to Intermediate
4.5 (71 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.
4,388 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 Training: Beginner to Intermediate to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 Training: Beginner to Intermediate

The Most Convenient Way to Boost Your Confidence And Learn Microsoft Excel 2016 Inside And Out.
4.5 (71 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.
4,388 students enrolled
Created by Simon Sez IT
Last updated 7/2017
English
English
Price: Free
Includes:
  • 16.5 hours on-demand video
  • 4 Articles
  • 2 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
  • Working with dates and times
  • Averages, percentiles, and LINEST functions
  • Calculating depreciation
  • Using financial functions to determine payments
  • Sparklines and data bars
  • How to import and export data to and from Excel
  • Create and effectively use pivot tables
  • How to use Excel for data analysis
  • Discover practical methods for financial & statistical​ Functions
  • Practice what you learned with included exercise files
View Curriculum
Requirements
  • Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.
Description

Learn Microsoft Excel 2016 Inside and Out

  • Includes 16 hours of high-quality training by your professional trainer
  • Practice along using exercise files
  • Watch and learn with demo project files
  • Progresses logically from beginning with an easy intro to advanced topics

This course includes:

  • 16 hours of video tutorials
  • Over 100 individual video lectures
  • Exercise files to practice what you learned
  • Demo files used by the trainer
  • Close captions to follow along
  • Certificate of completion

Contents and Overview

This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user.

It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them.

You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll 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.

Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets.

You'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. 

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

Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course.

* Includes quizzes, exercise files, demo files, close captions and certificate of completion.

Who is the target audience?
  • Users of earlier versions of Excel looking to update their skills.
  • Those new to using Microsoft Excel 2016.
  • Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge.
  • If you want to refresh your memory and understanding of Excel.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
107 Lectures
16:21:12
+
Introduction
4 Lectures 14:43
Acquiring Excel 2016 and Information on Installation and Upgrade
12:02

Essential Information for a Successful Training Experience
01:52

Exercise Files
00:26

Course Demo Files
00:22

Section 1 Quiz
1 question
+
What's New
1 Lecture 02:55
New and Improved Features in Excel 2016
02:55
+
Using Touch
1 Lecture 05:36
Overview of Principles of Using Touchscreen
05:36
+
Getting Started
2 Lectures 25:29
Creating and Saving a Workbook
15:16

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
Basics of using the Ribbon
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
+
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:12
Working with Fill and Series
09:08

Flash Fill
04:04

Section 10 Quiz
2 questions
31 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
11,521 Reviews
303,552 Students
117 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.