Introduction to Excel 2016

Productivity - David Ringstrom

In this course Excel master David Ringstrom, CPA covers what he regards to be the best new highlights in Microsoft Productivity Tool Excel 2016. A few highlights were presented in Excel 2013, so you'll have the capacity to make up for lost time on the off chance that you sat that form out.

You'll see new graph writes, for example, the Waterfall outline for delineating monetary explanations, and in addition subtleties, for example, the channel diagram and a modest bunch of new worksheet capacities accessible to Office 365 supporters, however not clients who have acquired ceaseless licenses for Excel 2016. You'll get a feeling of the new Forecast include, a modest bunch of new outline composes, and perceive how to keep away from incidentally closing Excel 2016 down until the point when you're prepared.

  • 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 options.
  • Use Box and Whisker charts in Excel 2016 to show data by quartiles and identify outliers.
  • Use Excel 2016 Sunburst chart for displaying hierarchical data in a circular chart.
  • Use Excel 2016 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.

 

Career Opportunities

There is an imbalance between the proportions of supply i.e. ms excel talent available amongst all youth WORLD and demand, i.e. total current job opportunities for MS EXCEL, MS EXCEL in WORLD 
There are 367 (1.38%) MS EXCEL jobs out of total 43843 job opportunities as compared to 41457 (1.38%) youth out of total 3003121 having that talent.

Check out the Excel jobs here, https://www.naukri.com/excel-jobs

Instructor

David Ringstrom

Founder: Accounting Advisors, Inc.

David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at…

Training 5 or more people?

Get your team access to WIISE top 2,000 courses anytime, anywhere.

Try WIISE for Business

What will you cover?

  •   Introduction to Excel Efficiency 00:01:45
  •   Overview of Excel 2016 00:08:27

Instructor

David Ringstrom

Founder: Accounting Advisors, Inc.

David teaches 180 live webinars annually on Microsoft Excel, along with occasionally speaking at…

Training 5 or more people?

Get your team access to WIISE top 2,000 courses anytime, anywhere.

Try WIISE for Business
Course Projects Not found ! in this Course
Attachments
No Attachments found ! in this Course

Related Courses

David Ringstrom
Introduction to Excel 2016
  59m           9,038 Views
David Ringstrom
Tricks for Efficiency in Excel
  48m           10,927 Views
David Ringstrom
Macros in Excel: Part I
  52m           8,626 Views