Ultimate Microsoft Excel 2016 Course - Beginner to Expert

Learn all the tools you'll need to become a Microsoft Excel power user with this effective MS Excel 2016 training bundle

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

  • Includes 3 complete courses: The Excel 2016 Beginner Course, Learn Excel 2016 Intermediate Level - Beyond the Basics & The Excel 2016 Advanced Course
  • Includes over 22 hours of high-quality, video 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:

  • 3 complete courses
  • 22 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

What You'll Learn:

Microsoft Excel for Beginners

  • Step-by-step, simple 1-2-3 methods for getting started with Excel 2016.
  • The ribbon and how to personalise Excel in the options tab
  • What's new in Excel 2016
  • Working with a touchscreen in Excel
  • Entering data in Excel
  • Backing up, recovering and saving your workbooks
  • How to print (the thing you want!) in Excel
  • How formulas work and the basic formulas you need to know
  • How to sort and filter data to see what you want
  • Creating Tables
  • Creating graphs and charts to bring your data to life

Microsoft Excel - Intermediate

  • Starts where the beginning Excel course concluded.
  • Tips and tricks to make the most of the ribbon
  • Hotkeys and different views in Excel
  • INDEX, MATCH
  • VLOOKUP, HLOOKUP
  • INDIRECT and OFFSET
  • Named Ranges
  • Dynamic functions and how they work
  • More advanced charts like Waterfall and Sunburst
  • Detailed chart formatting
  • PivotTables, Pivot Charts, slicers and Power Query

Advanced Microsoft Excel:

  • How to create amazing looking charts and graphs
  • Complex Time and Date functions
  • VLOOKUP, HLOOKUP
  • Statistical functions
  • Using Excel for forecasting
  • Connecting to external databases including Access and live web sources
  • Advanced Tables, including Styles and References
  • Advanced PivotTable uses including using filters, slicers and Pivot Charts
  • Goal Seek, Scenario Manager and Solver
  • Advanced charts such as Stock charts, Bubble Charts, Radar Charts and Sparklines
  • Using the Excel web app

Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course.


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.

Courses Included with Purchase



Microsoft Excel 2016 for Beginners: Learn the Essentials
Learn the essentials of Microsoft Excel 2016 in easy to follow steps
Simon Sez IT
$100
Microsoft Excel 2016 Advanced Training Master Class
The ultimate next step for anyone interested in supercharging their MS Excel and data analysis skills
Simon Sez IT
$100
Learn Excel 2016 Intermediate Level - Beyond the Basics
If you already know the basics of Excel, this is the intermediate knowledge that will help you become an Excel power user.
Simon Sez IT
$50

Original Price: $250


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 StreamSkill.com courses including new courses released while your subscription is active. Click here http://streamskill.com/course/streamskill-membership/ 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!