In this course Excel expert David Ringstrom, CPA, covers what he deems to be the best new features in Excel 2016. Some features were introduced in Excel 2013, so you'll be able to catch up if you sat that version out.

You'll see new chart types, such as the Waterfall chart for illustrating financial statements, as well as nuances such as the funnel chart and a handful of new worksheet functions available to Office 365 subscribers, but not users who have purchased perpetual licenses for Excel 2016. You'll get a sense of the new Forecast feature, a handful of new chart types, and see how to avoid accidentally shutting Excel 2016 down until you're ready.

  • Discover how to disable worksheet animation.
  • Discover new worksheet functions available in Excel 2016.
  • Explore the Recommended Charts feature in Excel 2013 and later.
  • Illustrate financial statements in Excel 2016 with the new Waterfall chart feature.
  • Overcome user interface annoyances by making simple adjustments to Excel’s options.
  • Use Box and Whisker charts in Excel 2016 to show data by quartiles and identify outliers.
  • Use Excel 2016’s Sunburst chart for displaying hierarchical data in a circular chart.
  • Use Excel 2016’s Treemap chart to visualize data based on relative size.
Learning Objectives
  • Identify keyboard shortcuts that discretely close workbooks or Excel itself.
  • Discover the new chart type best suited for illustrating financial statements.
  • Identify the new chart type that allows you to spatially compare amounts.
  • Explore new worksheet functions available to certain Excel 2016 users.

 

 

 

Last updated/reviewed: March 24, 2024
32 Reviews (106 ratings)

Reviews

5
Anonymous Author
I love all of David's courses. The only thing I would love is if the excel data was available for us to open, so we can make the charts with him. I always attempt to recreate the data but sometimes there is too much to replicate. Having the data readily available would be a bonus!

5
Anonymous Author
This was very informative. Even though it has been sometime since Excel 2016 came about, and there are later versions, this knowledge is helpful for those Organizations that have not upgraded. It is also interesting to review the evolution of change as each version occurs. Thanks

4
Anonymous Author
David is a great presenter. I like his use of numbering steps to show what he is explaining. However, if you do not use the scriber version of Excel, it has less use. However, as an Excel 2016 non-subscriber is it still beneficial.

5
Member's Profile
Great overview of the new features in Excel 2013 & 2016. Also explained the differences between licensed and 365 version which I did not know about. I recommend this class to those upgrading to the new version of Excel.

4
Anonymous Author
LOTS of new features explained. Instructor is very good at showing what he is doing and explaining it as he goes. Might want to slow down the clicking a little bit, though, so students can follow his actions a easier.

4
Anonymous Author
The course was informative but I could have done without so much time spent on charts. The course title indicates that it covers Excel efficiency topics so I would have liked more time devoted to formulas.

5
Anonymous Author
It's amazing how many differences there are between different versions of Excel. The teacher did a good job of identifying the nuances between the different versions and the functions each has.

5
Anonymous Author
Really clear and concisely presented. I like going over the steps, shown step by step, and then showing it being done. I think that will make it easier to remember.

5
Member's Profile
Material covered several things I was not aware of including all the new types of charts in Excel 2016 some of which could be useful in the future.

5
Member's Profile
Excellent explanation of 2016 features and which are not available except for Office 365. Also a good recap of new formulas and features.

5
Member's Profile
Very informative, I think I have a better understanding of the new features and can easily reproduce the results on my own. thanks

5
Anonymous Author
As always, David delivers a very clear and concise overview of the features that affect accountants the most. Much appreciated.

Anonymous Author
Great overview on the new features of Excel 2016. Liked the supporting spreadsheet files to practice the work being taught.

4
Member's Profile
Very good intro into Excel 2016. Information given is relative to grasping an understanding of the new features in 2016.

4
I liked learning how to perform functions, but didn't enjoy the detailed comparison of versions of Excel.

5
Anonymous Author
Useful description of new features chock full of interesting tips. These are very worthwhile courses.

5
Anonymous Author
Well explained and examples well laid out for easy understanding. Presenter spoke rather quickly.

5
Anonymous Author
We are going to be using Office 365 soon, and this course explained a lot of the new features.

5
Member's Profile
Excellent review of the changes to Excel version 2016. I would highly recommend this course.

4
Anonymous Author
Good overview of new functions in excel 2016 - one time purchasers and office subscribers.

5
Anonymous Author
This course was pretty good. Explanatory, and there are great resource materials provided.

5
Anonymous Author
I liked the course. Very informative as far as learning basics of new 2016 version.

5
Anonymous Author
Wonderful intro to Excel 2016. Great presentation skills and very dynamic course.

4
Member's Profile
Note: Almost all of these new features are only available to 365 subscribers!

5
Member's Profile
Great class. Very informative. Instructor gave good instructions.

5
Member's Profile
Enjoyed listing to the instructor and his teaching methods.

4
Member's Profile
good contents, I like it. I learned a lot from this lesson,

3
Anonymous Author
Instructor was effective and detailed.

5
Anonymous Author
Learn a lot. Many thanks.

4
Anonymous Author
Easy to understand

5
Anonymous Author
Excellent!

5
Member's Profile
Well done

Prerequisites
Course Complexity: Foundational

No advanced preparation or prerequisites are required for this course.

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Questions and Answers1 Question
Member's Profile

I enjoyed learning some new excel tricks...will take this again once I sharpen up on my formulas. this was a bit over my head but I still learned

Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Excel Efficiency: Excel 2016 Overview1:45
  Overview of Excel 2016 8:27
Charts
  Disabling Worksheet Animation and Working with Charts 10:46
  Working with Charts 10:40
  Funnel Charts 6:29
  Worksheet Function Evolution 10:51
Formulas and Conclusion
  Excel 2016 Formula AutoCorrect, working with Formulas and Conclusion 10:10
Continuous Play
  Excel Efficiency: Excel 2016 Overview59:08
SUPPORTING MATERIALS
  Slides: Excel Efficiency: Excel 2016 OverviewPDF
  Excel Efficiency: Excel 2016 Overview Glossary/IndexPDF
  Excel Efficiency Excel 2016 Overview-Excel 2007-2016XLSX
  Excel Efficiency Excel 2016 Overview-Excel 2003XLS
REVIEW and TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam