In this online course for upgraders we support you in your transition to Excel 2013. 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: 3 - 4 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.
Office 2013 User Interface
In this video we will familiarize you with the new user interface of Office 2013. You will learn how to work with the ribbon and all the other important new features.
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.
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.
Novelties Excel 2010
In this video we will show you the novelties and improvements of Excel 2010.
Customizing the Command Area
In this video we will show you how to add frequently used commands, or commands which are non-existent on the Ribbon, to the Quick Access toolbar. Additionally, you will learn how to minimize the Ribbon.
File Types and Compatibility
This video will introduce you to the new file types used in Excel 2010. We will explain the compatibility mode and show you how to create documents using old file formats. In addition you will learn where to find the settings for saving documents.
Using Data Tables
This video will show you how to convert a normal range of data into an Excel table. We will show you which functions Excel offers for data tables and how you can use them.
Formatting Tables Overview
This video will introduce you to the different formatting options in Excel. We will explain the difference between table formatting and cell formatting. Additionally you will learn when to use which method.
In this video you will learn how to format charts by adjusting the color, shape and design.
This video will show you how to work with conditional formatting. You will learn how to highlight cells by customized rules.
In this video you will learn how to create Sparklines in Excel. Sparklines are miniature charts that can be inserted into a cell.
Filtering in PivotTables
In this video you will learn how to filter data from Pivot Tables quickly and easily in Excel using the Slicer tool.
Saving PDF Documents
In this video you will learn how to create a PDF document. The PDF format's main advantages are that it takes up little space, that the document's information cannot be edited and that it can be used on various platforms.
Printing in Excel
This video will show you how to add a header and a footer and how to set other options before printing Excel tables.
Removing Sensitive Data from Documents
Documents created with the Office programs often contain personal or sensitive data which are not immediately visible. We will show you how to clean-up your file before passing it on to others.
Create Your Own Tabs
In this video we will show you how to create your own tabs in the Office programs. You can thereby integrate your own macros and frequently used commands into the user interface.
Interactive Command Guide
In this video you will learn how to work with Microsofts Interactive Guide in order to comfortably and quickly find familiar commands from older versions in the new interface of Office 2010.