To Access This Course:
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: June 04, 2018
16 Reviews (53 ratings)Reviews
Paul Whatley
(Sr. Financial Analyst at American Cancer Society)
Excellent explanation of 2016 features and which are not available except for Office 365. Also a good recap of new formulas and features.
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.
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.
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.
Wendi Finn
View Instructor Profile
I liked learning how to perform functions, but didn't enjoy the detailed comparison of versions of Excel.
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.
Pamela LaPlaca, CPA
(Controller at EG USA)
Note: Almost all of these new features are only available to 365 subscribers!
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
(None at none)
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 .
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