In this online course for upgraders we support you in your transition to Excel 2016. We explain the new user interface and tell you what new program features are available and how to use them. This course is intended for users who want to gain an overview quickly and are planning to use our online help to get targeted solutions for specific program features. To learn how to work with Excel in general, please refer to our online courses for Excel 2010.
Course Duration: 2 - 3 hours
= free Demo = just released = already seen
Title of Film
Information on the Course
In this video you will get important information about how to work with this upgrader course.
Novelties Excel 2016
In this video we will show you the novelties and improvements of Excel 2016. It includes only novelties introduced since the version 2013.
Based on given data, Excel can calculate trends and developments and create a forecast sheet including a visualisation as a column chart or a line chart, an adjustable confidence interval and further options. This is done with just a few clicks.
Time Grouping in Pivot Tables and Charts
In Pivot Table Analyses Excel recognizes time-based fields and groups according data automatically. This video explains how to work with the automatic grouping in Pivot Tables and Charts and familiiarizes you with the Drill Down Button.
3D Maps are a powerfull tool for visualizing geographic and time-based data. In this video we show you how to integrate your data in a 3D Map, how to customize it, and how to save your visualization either as a static image or as an animated video tour.
Searching Features and Functions
In this video you will learn about the Tell Me-feature, a specific search for functions and commands integrated in Microsoft Office. If you can't find a certain command on the ribbon, the Tell Me-feature will assist you.
Using Smart Lookup
In this video we show you how to use the Smart Lookup feature in order to instantly look up additional information, definitions and images related to terms and phrases in your document.
One-Click document sharing
Office documents that are saved to an online location can be shared with co-workers for collaboration. Since Office 2016 this sharing feature is integrated in the Office Application so you can invite colleagues via Email directly from within the document.
Using the Ink Equation Feature
Equations are often difficult to enter using the ribbon. In this video we will show you how to manually ink equations using your mouse, a touch pen or your fingertips. Learn how to ink, revise and correct equations before inserting them in your document.
Novelties Excel 2013
In this video we will explain the most important novelties of Excel 2013. It includes only novelties introduced since the version 2010.
Opening and Saving Files quickly
With the implementation of touch devices and cloud services, simple procedures like opening and saving files have changed a lot in the Office 2013 programs. We show you how to set up your Office program in order to handle these tasks much faster.
In this video we will introduce you to the Protected View, a new security feature of the Office 2013 programs. Depending on your environment, the basic settings are more or less useful. We will show you how to adjust them without compromising your safety.