Online Course: Excel 2010 Upgrader

In this Excel course for upgraders we help you get used to the new Excel 2010. We familiarize you with the user interface and show you the new functions and how to use them. This course is mainly for users that want to have an overview of the new version and are going to work with our Online Help to learn how to work with certain functions.

Course Duration: 2-3 hours

=free      =new      =seen
Novelties Excel 2010
LernFilm starten

16-24 Min.  
In this video we will show you the novelties and improvements of Excel 2010.
Office 2010 User Interface
LernFilm starten
16-24 Min.  
In this video we explain the new User Interface in Office 2010 and show you the basic differences to older versions.
Customizing the Command Area
LernFilm starten
10-15 Min.  
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
LernFilm starten
10-15 Min.  
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
LernFilm starten
21-35 Min.  
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
LernFilm starten
4-6 Min.  
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.
Formatting Charts
LernFilm starten
18-30 Min.  
In this video you will learn how to format charts by adjusting the color, shape and design.
Conditional Formatting
LernFilm starten

15-25 Min.  
This video will show you how to work with conditional formatting. You will learn how to highlight cells by customized rules.
Using Sparklines
LernFilm starten
15-25 Min.  
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
LernFilm starten
18-30 Min.  
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
LernFilm starten
4-6 Min.  
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
LernFilm starten
21-35 Min.  
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
LernFilm starten
10-15 Min.  
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
LernFilm starten
16-24 Min.  
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
LernFilm starten

6-9 Min.  
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.
back to top
Confirm

This site uses cookies. By visiting this website you agree to the use of cookies. More on this..