Microsoft Excel 2016 Advanced Training Master Class

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

  Get Started Now

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

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.

What People Are Saying:

★★★★★ “Greatly explained and great zoom in of the working area.” -Jorge Tech

★★★★★ “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

Your Instructor

Simon Sez IT
Simon Sez IT
Simon Sez IT makes business and technical software simple to learn.

Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.

This is why more than a million learners have relied on Simon Sez IT since 2008.

Course Curriculum

  Chapter 4: Text Functions
Available in days
days after you enroll
  Chapter 5: Logical Functions
Available in days
days after you enroll
  Chapter 6: Lookup Functions
Available in days
days after you enroll
  Chapter 14: Excel Web App
Available in days
days after you enroll
  Chapter 15: Course Conclusion
Available in days
days after you enroll

Frequently Asked Questions

What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.
How long do I have access to the course?
How does lifetime access sound? After purchasing a course, you have unlimited access to this course for as long as you like - across any and all devices you own. Active memberships have access to all courses while they membership is active.
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
Will your videos work with iPhone, iPads, and Android devices?

All of our courses are compatible with iPhones and iPads and most Android devices. If you are looking to confirm that it works for you, feel free to view the free preview videos offered for each course.

Will your videos work with Mac computers?

All of our courses are compatible with both Windows (PC) and Mac computers.

What if I have questions or problems while I am watching my tutorial?

Should you have any problems using the system, we offer free technical support to customers. Just send an email to [email protected] and we will respond promptly.

Do you offer Certificates of Completion?

We offer Certificates of Completion for courses that offer an online quiz (currently over 50% of our courses). The Certificates of Completion are offered as part of the online test/quiz, which accompanies the course. You will need a passing grade of 70% in order to receive a Certificate. The quizzes are based solely on course content.

Do you offer a subscription option?

Yes, we offer a monthly or annual membership. Any monthly or annual subscription includes unlimited access to all courses including new courses released while your subscription is active. Click here to get additional details about the Ultimate Training Library membership.

Do you provide any group discounts?

Yes, we offer group discounts or multiple users. Contact [email protected] for more information.

Do you offer discounts for non-profits or educational institutions?

Yes, we offer 20% off discounts to non-profit, educational, and government agencies. Contact [email protected] for more information.

Can I interact with others who are taking the same course?

Yes, you can interact with others by using the discussion section offered for each course.

How long have you been in business?

We started our company in 2008 with our first course for Excel 2007. Since that time, our company has published over 80 courses, with tens of thousands of satisfied customers in over 100 countries.

Get started now!