Microsoft Excel 2016 Advanced Training Master Class

The ultimate next step for anyone interested in supercharging their MS Excel and data analysis skills

4.40 (64 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
889
students
10 hours
content
Mar 2024
last update
$19.99
regular price

What you will learn

Working with dates and times

Averages, percentiles, and LINEST functions

Calculating depreciation

Inserting and formatting tables

Sparklines and data bars

Pivot charts

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

Using financial functions to determine payments

Practice what you learned with included exercise files

Description

Become a Microsoft Excel expert with this easy to follow course featuring 9-hours of  professionally produced videos. Exercise and demo files included.

  • Practice what you learned with included exercise files

  • Detailed easy instruction to master Microsoft Excel 2016

  • A full 9 hours of professional video instruction

  • 60+ easy to follow how-to videos

  • Everything explained step-by-step for quick comprehension

  • The next step after completing Microsoft Excel 2016 for      Beginners

  • Learn how to import and export data to and from Excel

  • Learn how to create various charts and graphs

  • Effectively create and use functions and formulas

  • Import and export data 

  • Create and effectively use Pivot Tables

  • How to use Excel for data analysis

  • Discover practical methods for financial  & statistical functions

  This course includes: 

  1. 9-hours of video tutorials

  2. Over 50 individual video lectures

  3. Exercise files to practice what you learned

  4. Demo files used by the trainer

  5. Printable course transcriptions to follow along and take notes

  6. Certificate of completion


This course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2016 and learn how to reach the next level of database tracking and reporting.

Contents and Overview

Through 57 lectures and over 9-hours of content, this course will take you through learning how to use functions in everyday work environments. Professional financial functions are covered including payments, future value and depreciation. Students will learn statistical functions like averages, percentiles, and regression.

In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment.

For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs.

Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.


** Updated July 2017. English close captions added

** Updated June 2017. Course transcripts now available.

Here’s what our students are saying…


"This is an excellently pieced together information. Beautifully explained with lots of examples and external resource areas for the nerds. I highly recommend this course for anyone whose intention is to learn Excel.”
-
Frank Uchegbu

"Greatly explained and great zoom in of the working area."
-
Jorge Tech

"Very detail and advance. The exercise and solution sheets help greatly in understanding and familiarisation of the lessons. Highly recommended for users getting to know Excel in details."
-
John Chan


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

Introduction to Excel 2016 Advanced Course

Prerequisites of the Course and Version of Excel
Essential Information for a Successful Training Experience
Excel 2016 Advanced Course Exercise Files
Excel 2016 Advanced Course Demo Files
Downloadable Course Transcripts
Course Structure

Functions

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

Date and Time Functions

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

Text Functions

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

Logical Functions

Using Logical Functions
Exercise 01
Section 5 - Quiz

Lookup Functions

HLOOKUP Function
VLOOKUP Function
Exercise 02
Section 6 - Quiz

Financial Functions

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

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

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

Tables

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

Pivot Tables

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

Data Analysis

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

Graphs and Charts

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

Excel Web App

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

Conclusion

Closing Message

Screenshots

Microsoft Excel 2016 Advanced Training Master Class - Screenshot_01Microsoft Excel 2016 Advanced Training Master Class - Screenshot_02Microsoft Excel 2016 Advanced Training Master Class - Screenshot_03Microsoft Excel 2016 Advanced Training Master Class - Screenshot_04

Reviews

Mario
March 1, 2023
Yes great training. I was using excel for a very long time but never take the proper time to do it better.
Kevin
March 15, 2019
For me, his teaching style is hard to follow. I am not even10% into this class and am no longer going to try an finish it. I will look for a similar class with the instructor Chris Dutton, he is a fabulous instructor.
Frank
October 29, 2017
This is an excellently pieced together information. Beautifully explained with lots of examples and external resource areas for the nerds. I highly recommend this course for anyone whose intention is to learn Excel.

Charts

Price

Microsoft Excel 2016 Advanced Training Master Class - Price chart

Rating

Microsoft Excel 2016 Advanced Training Master Class - Ratings chart

Enrollment distribution

Microsoft Excel 2016 Advanced Training Master Class - Distribution chart

Related Topics

997410
udemy ID
10/29/2016
course created date
4/27/2019
course indexed date
Bot
course submited by