Excel 2016 Overview
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Overview to your Wishlist.

Add to Wishlist

Excel 2016 Overview

This course explores the best new features in Excel 2016.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Last updated 7/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 4 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • No advanced preparation or prerequisites are required for this course.
Description

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.
Who is the target audience?
  • Anyone interested in Excel.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:58:24
+
Introduction
8 Lectures 01:58:18


Disabling Worksheet Animation and Working with Charts
10:46

Working with Charts
10:39

Funnel Charts
06:29

Worksheet Function Evolution
10:50

Excel 2016 Formula AutoCorrect, working with Formulas and Conclusion
10:09

Excel Efficiency: Excel 2016 Overview Continuous Play
59:08
+
Supporting Materials
4 Lectures 00:06
Slides: Excel Efficiency: Excel 2016 Overview
00:01

Excel Efficiency: Excel 2016 Overview Glossary/Index
00:01

Excel Efficiency Excel 2016 Overview-Excel 2007-2016
00:01

Excel Efficiency Excel 2016 Overview-Excel 2003
00:01
+
Review and Test
0 Lectures 00:00
Review Questions
3 questions

FINAL EXAM
5 questions
About the Instructor
Illumeo Learning
4.4 Average rating
291 Reviews
1,291 Students
234 Courses
Condensed and Efficient Courses for Busy Professionals

Illumeo, incorporated in 2009, is revolutionizing the hide-bound world of corporate learning. Illumeo works with corporate professionals and organizations of all sizes to build the skills and capabilities that help everyone be an expert at their job.

Based in Silicon Valley, CA, Illumeo serves thousands of corporations and corporate professionals across Finance, Accounting, Human Resources, Sales and Marketing. The platform offers assessments, industry-benchmarked competency analyses, hundreds of expert-developed courses, collaborative tools, and the ability for companies to self-publish internal courses that promote institutional knowledge retention and dissemination.

Illumeo is the place for expertise management and we are dedicated to the proposition that everyone can be an expert at their job.

David Ringstrom (Illumeo)
4.3 Average rating
15 Reviews
84 Students
14 Courses

David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at conferences. He is the co-author of Idiot's Guides: Introductory Accounting, and has served as the technical editor for over 30 books on accounting software. Some of his hundreds of freelance articles on spreadsheets have been published internationally. 

Experience

President : Accounting Advisors, Inc. - [1991-12 to Current]
David offers spreadsheet, database, and accounting software consulting services nationwide. He focuses on streamlining complex business processes via a combination of training, tools, and custom programming. 

Education

Bachelor of Business Administration, Accounting : J. Mack Robinson College of Business (at Georgia State University )