Instructor for this course
more

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.

 

 

 

12 Reviews (36 ratings)Reviews

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
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
I liked learning how to perform functions, but didn't enjoy the detailed comparison of versions of Excel.
5
Anonymous Author
We are going to be using Office 365 soon, and this course explained a lot of the new features.
4
Member's Profile
Note: Almost all of these new features are only available to 365 subscribers!
5
Member's Profile
Enjoyed listing to the instructor and his teaching methods.
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 .

1 QuestionCourse Questions and Answers

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

Course Syllabus
INTRODUCTION AND OVERVIEW
  1:45Introduction to Excel Efficiency: Excel 2016 Overview
  8:27Overview of Excel 2016
Charts
  10:46Disabling Worksheet Animation and Working with Charts
  10:40Working with Charts
  6:29Funnel Charts
  10:51Worksheet Function Evolution
Formulas and Conclusion
  10:10 Excel 2016 Formula AutoCorrect, working with Formulas and Conclusion
Continuous Play
  59:08Excel Efficiency: Excel 2016 Overview
SUPPORTING MATERIALS
  PDFSlides: Excel Efficiency: Excel 2016 Overview
  PDFExcel Efficiency: Excel 2016 Overview Glossary/Index
  XLSXExcel Efficiency Excel 2016 Overview-Excel 2007-2016
  XLSExcel Efficiency Excel 2016 Overview-Excel 2003
REVIEW and TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM