Learn your way! Get started

Microsoft Excel 2016, Part 6 of 6: New Features

with expert Leeanne McManus

Watch trailer

Course at a glance

Release date 4/7/2017
Level Beginner
Runtime 1h 3m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code N/A
Exams Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

Discover the enhancements in the newest version of Excel, including an examination of smart look-up, stress-free sharing, and enhanced inking which enables more drawing capabilities. In addition, managing Office 365 accounts as well as icons, calendar and email insights will be discussed.


This course assumes that students are familiar with the basic use of Windows and common use of the mouse and keyboard. No prior experience with Excel is assumed.

Learning Paths

This course is part of the following LearnNowOnline SuccessPaths™:
Microsoft Office Advanced

Meet the expert

Leeanne McManus is a nationally renowned trainer, facilitator, and productivity expert who has conducted thousands of sessions over the past decade. While widely recognized for helping end-users, departments, and organizations learn how to maximize their software products, most notably Office 365 and Adobe, Leeanne also facilitates sessions to enhance productivity and performance through soft skills development. Her professional background includes Human Resources, Operations, and Talent and Development.

Course outline

New Features

Interface and Smart Lookup (10:43)
  • Introduction (00:16)
  • Additions to the Interface: Excel 2016 (01:16)
  • Demo: Tell Me (02:47)
  • Smart Lookup (01:15)
  • Demo: Smart Lookup (04:42)
  • Summary (00:25)
Enhanced Inking and Improved Open File (15:22)
  • Introduction (00:21)
  • Enhanced Inking Features (01:30)
  • Demo: Enhanced Inking (06:04)
  • Improved Open File Features (01:25)
  • Demo: Open File (05:28)
  • Summary (00:32)
Sharing and Managing an O365 Account (17:10)
  • Introduction (00:19)
  • Manage Your Office 365 Account (01:33)
  • Demo: Managing an O365 Account (05:17)
  • Stress-Free Sharing (01:30)
  • Demo: Sharing (02:37)
  • Demo: Activity (05:23)
  • Summary (00:29)
Icons, Calendars, and Email Insights (20:08)
  • Introduction (00:25)
  • Add Icons to Our Workbooks (01:19)
  • Demo: Icons (05:11)
  • Demo: Icons Continued (01:49)
  • Calendar and Email Insights (01:12)
  • Demo: Insights Setup (04:37)
  • Demo: Email Insights (03:30)
  • Demo: Calendar Insights (01:38)
  • Summary (00:22)