Online Course: Microsoft Excel 2007 Upgrader

In this Excel course for upgraders we help you get used to the new Excel 2007. 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: 4 - 8 hours

switch to Online-Help..

= free Demo

= just released

= already seen

Title	Type	Lenth
New features	Film	6 Min.
In this video we explain the new features of Excel 2007.
Office 2007 User Interface	Film	7 Min.
In this video we explain the new User Interface in Office 2007 and show you the basic differences to older versions.
File Formats and Compatibility	Film	4 Min.
This video will introduce you to the new file types used in Excel 2007. 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.
Customizing the User´s Interface	Film	4 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.
Creating New Tables	Film	5 Min.
This video will give you an introduction on the basic rules for the creation of new Excel tables. Using these rules will help you to save time and to facilitate your work.
Using Data Tables	Film	7 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	Film	2 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 Tables	Film	3 Min.
This video will show you how to format Excel tables by using the predefined table styles from the quick styles gallery.
Conditional Formatting	Film	5 Min.
This video will show you how to work with conditional formatting. You will learn how to highlight cells by customized rules.
Modifying Charts	Film	2 Min.
This video will give you an introduction on the tools and possibilities you have for modifying charts.
Printing in Excel	Film	6 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	Film	6 Min.
Created files often contain hidden data as well as personal and confidential information, that are not directly visible. This video will show you how to find and remove the hidden information.
Publishing PDF Documents	Film	3 Min.
In this video you will learn how to create pdf documents. The pdf format is cross-platform available because the document information and the layout are fixed and cannot be edited at a later time.
Publishing XPS Documents	Film	4 Min.
This video will show you how to save documents as XPS documents. The XPS format is similar to the PDF format because the documents are slim held and, as the layout is fixed, cannot be edited at a later time.
Reference Guide	Film	3 Min.
In this video you will learn how to work with the interactive Office 2007 Reference Guide in order to comfortably and quickly find familiar commands from older versions in the new interface of Office 2007.
Using the data form	Film	2 Min.
We will show you in this video how to access the data form from older versions of Excel in Excel 2007.
Specifying Security Settings	Film	9 Min.
This video will show you how to adjust the security settings in Office 2007 by using the trust center. We will explain how you can block macros and Active X controls and how to find the optimal setting.
Mapping Workbook	Film	3 Min.
In this film we introduce an Excel table containing a list of commands from older versions showing where to find comparative commands in Office 2007.
Using the Help Function	Film	6 Min.
This video will show you how to use the help function in Office 2007.
Files in preVersions	Film	3 Min.
Microsoft offers a compatibility pack for all versions from Office 2000 which you can use to read and edit files that have been created with Word, Excel or PowerPoint 2007.