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.6 (14 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,074 students enrolled
$15
$100
85% off
Take This Course
  • Lectures 129
  • Length 18.5 hours
  • Skill Level All Levels
  • 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/2016 English

Course 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
  • 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.

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.
  • omplete 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

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.

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: Excel 2016: Introduction to Excel 2016 Beginner Course
Introduction
Preview
12:02
Essential Information for a Successful Training Experience
01:36
Course exercise files
00:26
Course demo files
00:26
Exercise Files
02:28
Downloadable Course Transcripts
00:21
Section 1 - Quiz
1 question
Section 2: Excel 2016: What's New
New and Improved Features in Excel 2016
Preview
02:55
Section 3: Excel 2016: Using Touch
Overview of Principles of Using Touchscreen
Preview
05:36
Section 4: Excel 2016: Getting Started
Creating and Saving a Workbook
Preview
15:16
Opening a Workbook
10:13
Section 5: Excel 2016: Using Help
Online Help and Contextual Help
06:27
Section 5 - Quiz
1 question
Section 6: Excel 2016: Excel Options
Personalizing your use of Excel
10:50
Section 6 - Quiz
2 questions
Section 7: Excel 2016: 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: Excel 2016: 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: Excel 2016: Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
07:35
Section 9 - Quiz
1 question
Section 10: Excel 2016: Fill and Series
Working with Fill and Series
09:08
Flash Fill
04:04
Section 10 - Quiz
2 questions
Section 11: Excel 2016: Viewing and Printing
Workbook Views, Zoom, and Freeze
08:41
Printing
14:29
Exercise 03
02:55
Section 11 - Quiz
3 questions
Section 12: Excel 2016: Cut, Copy, and Paste
Methods of Cutting, Copying, and Pasting
13:32
Section 12 - Quiz
1 question
Section 13: Excel 2016: Formatting a Worksheet
Delete and Clear
Preview
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: Excel 2016: Formulas and Functions
Course review
00:43
Basics of Fomulas and Functions
11:15
Complex Examples of Formulas
13:36
Exercise 05
03:25
Section 14 - Quiz
1 question
Section 15: Excel 2016: Managing Worksheets
Managing Worksheets
08:40
Section 15 - Quiz
1 question
Section 16: Excel 2016: Working with Multiple Workbooks
Working with Multiple Workbooks
15:48
Section 16 - Quiz
1 question
Section 17: Excel 2016: Saving Workbooks
Saving in Different File Types
12:58
Section 17 - Quiz
2 questions
Section 18: Excel 2016: Proofing
The Spell Checker
Preview
13:11
Section 19: Excel 2016: Inserting Comments
Inserting Comments
04:54
Exercise 06
03:01
Section 20: Excel 2016: Basic Functions in Excel
The VLOOKUP Function
14:06
Text Functions
08:17
Date and Time Functions
06:47
Logical Functions
15:51
Section 20 - Quiz
2 questions
Section 21: Excel 2016: Graphs and Charts
Creating Graphs and Charts
12:10
Customizing a Cluster Column Chart
15:41
Customizing a Pie Chart
13:35
New Chart Types in Excel 2016
02:01
Exercise 07
02:28
Section 21 - Quiz
2 questions
Section 22: Excel 2016: Sorting and Filtering Data
Managing Data by Sorting
09:39
Managing Date by Filtering
11:59
Customizing Tables
13:23
Section 22 - Quiz
3 questions
Section 23: Excel 2016: Shapes and Pictures
Inserting Shapes and Pictures
15:00
Exercise 08
00:47
Section 23 - Quiz
2 questions
Section 24: Excel 2016: Formatting Cells Based on Content

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