Microsoft Excel 2016 Advanced Training Master Class

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

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

What you’ll 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.

Course Content

  • Introduction to Excel 2016 Advanced Course –> 6 lectures • 17min.
  • Functions –> 3 lectures • 33min.
  • Date and Time Functions –> 3 lectures • 38min.
  • Text Functions –> 2 lectures • 30min.
  • Logical Functions –> 2 lectures • 14min.
  • Lookup Functions –> 3 lectures • 30min.
  • Financial Functions –> 5 lectures • 37min.
  • Statistical Functions –> 7 lectures • 1hr 17min.
  • Connecting to External Data –> 5 lectures • 1hr 2min.
  • Tables –> 5 lectures • 37min.
  • Pivot Tables –> 5 lectures • 52min.
  • Data Analysis –> 5 lectures • 45min.
  • Graphs and Charts –> 7 lectures • 48min.
  • Excel Web App –> 2 lectures • 22min.
  • Conclusion –> 1 lecture • 1min.
  • Extras –> 2 lectures • 1hr 2min.

Microsoft Excel 2016 Advanced Training Master Class


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.


Get Tutorial