Ultimate Microsoft Excel 2016 Course - Beginner to Expert

18 Hours of Training. The Most Convenient Way to Boost Your Confidence And Learn MS Excel 2016 Inside And Out—Quickly

4.35 (136 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
2,647
students
24 hours
content
Mar 2024
last update
$74.99
regular price

What you will 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

Description

Learn Microsoft Excel 2016 Inside and Out with This 2-Course Training Bundle  

  • Includes 2 complete courses: The Excel 2016 Beginner Course & The Excel 2016 Advanced Course  

  • Includes 18 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  

  • Learn to Create Charts and Graphs  

This bundle includes:  

  • 2 complete courses  

  • 18 hours of video tutorials  

  • Over 100 individual video lectures  

  • Exercise files to practice what you learned  

  • Demo files used by the trainer  

  • Printable course transcriptions to follow along and take notes

  • Certificate of completion  

Contents and Overview for the 9-Hour Excel 2016 Beginner Course  

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.  

Contents and Overview for the 9-Hour Excel 2016 Advanced Course  

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 in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class.  

Your expert instructor will begin the course by leading you through graph and chart basics. Then, 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. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts and more.  

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 and certificate of completion.

** Updated June 2017. Course transcripts now available.



Here’s what our students are saying…


"I use MS Excel and started this course just to refresh and get out more what I know already and I suprised that on second lesson I learned something I did not know :-) .”
- Tomáš Seiner

"The instructor is very knowledgeable, clear, and concise in his presentation of material and is enjoyable to listen to and learn from. The material being taught is exactly what I was looking for to expand my knowledge and the value of being able to get this through Udemy can't be beat!!"
- Ontavus Thomas

"Thoroughly enjoyed every single lesson...great tutor - clear, precise and to the point. Well done Sir"
-
Jessica Henry


Did you know?


Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!


Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.


Content

Excel 2016: Introduction to Excel 2016 Beginner Course

Introduction
Essential Information for a Successful Training Experience
Course exercise files
Course demo files
Exercise Files
Downloadable Course Transcripts
Section 1 - Quiz

Excel 2016: What's New

New and Improved Features in Excel 2016

Excel 2016: Using Touch

Overview of Principles of Using Touchscreen

Excel 2016: Getting Started

Creating and Saving a Workbook
Opening a Workbook

Excel 2016: Using Help

Online Help and Contextual Help
Section 5 - Quiz

Excel 2016: Excel Options

Personalizing your use of Excel
Section 6 - Quiz

Excel 2016: The Ribbon and Toolbars

Basics of using the Ribbon
Quick Access Toolbar
Tell Me Feature
Mini Toolbars and Contextual Menus
Status Bar
Section 7 - Quiz

Excel 2016: Entering and Editing Data

Basics of Entering and Editing Data in a Workbook
Exercise 01
Formatting Dates
Formatting Numbers
Exercise 02
Section 8 - Quiz

Excel 2016: Backup and Recovery

AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Section 9 - Quiz

Excel 2016: Fill and Series

Working with Fill and Series
Flash Fill
Section 10 - Quiz

Excel 2016: Viewing and Printing

Workbook Views, Zoom, and Freeze
Printing
Exercise 03
Section 11 - Quiz

Excel 2016: Cut, Copy, and Paste

Methods of Cutting, Copying, and Pasting
Section 12 - Quiz

Excel 2016: Formatting a Worksheet

Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Alignment
Themes and Styles
Exercise 04
Section 13 - Quiz

Excel 2016: Formulas and Functions

Course review
Basics of Fomulas and Functions
Complex Examples of Formulas
Exercise 05
Section 14 - Quiz

Excel 2016: Managing Worksheets

Managing Worksheets
Section 15 - Quiz

Excel 2016: Working with Multiple Workbooks

Working with Multiple Workbooks
Section 16 - Quiz

Excel 2016: Saving Workbooks

Saving in Different File Types
Section 17 - Quiz

Excel 2016: Proofing

The Spell Checker

Excel 2016: Inserting Comments

Inserting Comments
Exercise 06

Excel 2016: Basic Functions in Excel

The VLOOKUP Function
Text Functions
Date and Time Functions
Logical Functions
Section 20 - Quiz

Excel 2016: Graphs and Charts

Creating Graphs and Charts
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
Exercise 07
Section 21 - Quiz

Excel 2016: Sorting and Filtering Data

Managing Data by Sorting
Managing Date by Filtering
Customizing Tables
Section 22 - Quiz

Excel 2016: Shapes and Pictures

Inserting Shapes and Pictures
Exercise 08
Section 23 - Quiz

Excel 2016: Formatting Cells Based on Content

Conditional Formatting
Section 24 - Quiz

Excel 2016: Protection and Security

Protecting Worksheets
Protecting Workbooks

Excel 2016: Naming Items

Giving Items Names
Exercise 09

Excel 2016: Finding and Replacing Words

Find and Replace
Section 27 - Quiz

Excel 2016: Borders

Adding Borders
Section 28 - Quiz

Excel 2016: Workbook Inspection

Inspecting a Workbook

Excel 2016: Privacy Options

Trust Center Privacy Options

Excel 2016: Sharing Options

Sharing a Workbook
Section 31 - Quiz

Excel 2016: Wrap Up

Closing

Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

Prerequisites of the Course and Version of Excel
Essential Information for a Successful Training Experience
Course exercise files
Course demo files
Downloadable Course Transcripts
Course Structure

Excel 2016 Advanced: Functions

Functions - Part 1
Functions - Part 2
Autosum
Section 2 - Quiz

Excel 2016 Advanced: Date and Time Functions

How Date and Time Works
Basic Date and Time Functions
Complex Date and Time Functions
Section 3 - Quiz

Excel 2016 Advanced: Text Functions

Using Text Functions - Part 1
Using Text Functions - Part 2
Section 4 - Quiz

Excel 2016 Advanced: Logical Functions

Using Logical Functions
Exercise 01
Section 5 - Quiz

Excel 2016 Advanced: Lookup Functions

HLOOKUP Function
VLOOKUP Function
Exercise 02
Section 6 - Quiz

Excel 2016 Advanced: Financial Functions

Financial Functions and Terminology
Personal Financial Functions
Professional Financial Functions
Depreciation
Exercise 03
Section 7 - Quiz

Excel 2016 Advanced: Statistical Functions

Statistical Functions for Description - Part 1
Statistical Functions for Description - Part 2
Statistical Functions for Forecasting - Part 1
Statistical Functions for Forecasting - Part 2
Exercise 04
One Click Forecasting
Statistical Functions for Inference
Section 8 - Quiz

Excel 2016 Advanced: Connecting to External Data

Connecting to Other Workbooks
Connecting to Access Databases
Connecting to Web Data Sources
Get and Transform
Exercise 05
Section 9 - Quiz

Excel 2016 Advanced: Tables

Introduction to Tables
Working with Tables
Table References
Table Styles
Exercise 06
Section 10 - Quiz

Excel 2016 Advanced: Pivot Tables

Introduction to Pivot Tables
Working with Pivot Tables
Filters and Slicers
Pivot Charts
Exercise 07
Section 11 - Quiz

Excel 2016 Advanced: Data Analysis

What If Analysis
Scenario Manager
Goal Seek
Solver
Exercise 08
Section 12 - Quiz

Excel 2016 Advanced: Graphs and Charts

Area Charts
Surface Charts
Radar Charts
Bubble Charts
Sparklines
Stock Charts
Exercise 09
Section 13 - Quiz

Excel 2016 Advanced: Excel Web App

Web App - Part 1
Web App - Part 2
Section 14 - Quiz

Excel 2016 Advanced: Conclusion

Closing Message

Screenshots

Ultimate Microsoft Excel 2016 Course - Beginner to Expert - Screenshot_01Ultimate Microsoft Excel 2016 Course - Beginner to Expert - Screenshot_02Ultimate Microsoft Excel 2016 Course - Beginner to Expert - Screenshot_03Ultimate Microsoft Excel 2016 Course - Beginner to Expert - Screenshot_04

Reviews

Daniel
February 8, 2020
Easy to follow. The instructor has a clear and understandable style. Does not make any assumptions about your knowledge.
Katarzyna
May 10, 2019
Great course! I enjoy it a lot. Contents are explained in a clear manner and easy to follow. I highly recommend this course to everybody who wants to brush up on their skills in excel.
Karen
May 5, 2019
the screens were confusing as the top one still had the course buying info and it should have been past that.
Constance
August 30, 2018
Just started the course, I do not know anything about Excel but the instructor is a WOW!!! I know I am going to be able to apply what I learned on my new my new job and be successful!!!! upon completing this course!!! Highly recommend this course!!! Thank you Toby :)
Albert
March 30, 2018
Interesante curso, estaria mejor si se impartiera en diferentes idiomas, porque muchas fórmulas cuestan encontrarlas, pero en general está bien.
Scott
February 2, 2018
I left this rating because I am familiar with your classes. I am also in the middle of Access class and so far, it's been a great learning experience. I have reason to believe this will prove just as good.
Manjari
December 24, 2017
Excellent course, very detailed and absolutely perfect for beginners. For more advanced users, just skip to the parts you need to hone your skills!
Kerry
October 16, 2017
The instructor was rubbish as too pedantic and overcomplicating simple ideas. States the obvious, repetitive, and talks way too much, and slowly like his tutorial. It was a waste of my time.
Edward
March 4, 2017
So far, so good. I do wish that the audio was a bit louder - I'm playing this on a laptop, and the volume is quite low.
Kizito
January 23, 2017
...well structured and quite detailed explanations through out the sections that I have already covered.
Pauline
December 3, 2016
Toby's course is excellent. I'm re-learning commands that I'd known about in earlier versions of Excel that, through the various upgrades I'd lost especially when we moved to using ribbons. The pressure of work did not always allow me to have the luxury of finding where the command went and I would either improvise or do without. Most importantly I'm learning about commands I knew nothing about. I have a wide screen and am able to view the videos on one side and have an open Excel spreadsheet on the other to practice. I'm having a blast with this course. Thank you!
Robert
November 13, 2016
I recommend taking this course even if an Excel course has been taken previously, as each one has a different approach. This prevents boredom from setting in as it reinforces what may have already been learned in another course. This presentation is quite thorough.

Charts

Price

Ultimate Microsoft Excel 2016 Course - Beginner to Expert - Price chart

Rating

Ultimate Microsoft Excel 2016 Course - Beginner to Expert - Ratings chart

Enrollment distribution

Ultimate Microsoft Excel 2016 Course - Beginner to Expert - Distribution chart

Related Topics

980134
udemy ID
10/10/2016
course created date
11/20/2019
course indexed date
Bot
course submited by