1 CPE 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: May 7, 2022
30 Reviews (101 ratings)
Reviews
Anonymous
(Associate Accountant)
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!
Anonymous
(Affiliate)
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
Anonymous
()
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.
Lilian Dendrinos
(consultant at DLC Group)
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.
Anonymous
(Sr. Accountant)
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.
Anonymous
(Senior Manager)
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.
Anonymous
()
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.
Anonymous
(Sr. Manager, Transformation - ERP)
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.
Grant Brannum
(Agent at Treasury)
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.
Paul Whatley
(Lead IT Auditor at Gulfport Energy)
Excellent explanation of 2016 features and which are not available except for Office 365. Also a good recap of new formulas and features.
Rick Beutel
(Senior Accountant at Charter Communications)
Very informative, I think I have a better understanding of the new features and can easily reproduce the results on my own. thanks
Anonymous
(Controller)
As always, David delivers a very clear and concise overview of the features that affect accountants the most. Much appreciated.
Anonymous
(Bookkeeper)
Great overview on the new features of Excel 2016. Liked the supporting spreadsheet files to practice the work being taught.
Joseph Ennis
( at Dillon Supply Company)
Very good intro into Excel 2016. Information given is relative to grasping an understanding of the new features in 2016.
Wendi Finn
View Instructor Profile
I liked learning how to perform functions, but didn't enjoy the detailed comparison of versions of Excel.
Anonymous
()
Useful description of new features chock full of interesting tips. These are very worthwhile courses.
Anonymous
(Senior Accountant)
Well explained and examples well laid out for easy understanding. Presenter spoke rather quickly.
Anonymous
(Staff Accountant)
We are going to be using Office 365 soon, and this course explained a lot of the new features.
Karin Williams
(None at self)
Excellent review of the changes to Excel version 2016. I would highly recommend this course.
Anonymous
(Tax Staff)
Good overview of new functions in excel 2016 - one time purchasers and office subscribers.
Anonymous
(Associate Accountant)
This course was pretty good. Explanatory, and there are great resource materials provided.
Anonymous
(Sr AP Specialist)
I liked the course. Very informative as far as learning basics of new 2016 version.
Pamela LaPlaca, CPA
(Controller at EG USA)
Note: Almost all of these new features are only available to 365 subscribers!
Kenneth Hopkins
(Senior Financial Analyst at The University of Texas Health Science C..)
Great class. Very informative. Instructor gave good instructions.
Dan Gormley
( at Houston Airport System)
Enjoyed listing to the instructor and his teaching methods.
Anonymous
(Collections Analyst II)
Instructor was effective and detailed.
Anonymous
(Accountant)
Learn a lot. Many thanks.
Anonymous
(VP, Finance)
Easy to understand
Anonymous
(-)
Excellent!
Charles Elwis
(Insurance Broker at Health Guys)
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
David RingstromCPA, author, Microsoft Excel trainer and consultant
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 75 East Santa Clara St.
- Suite 1215, San Jose, CA 95113
© 2023 Illumeo, Inc.
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