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: 2 - 3 hours
= free Demo = just released = already seen
Title of Film
Novelties Excel 2007
In this video we explain the new features of Excel 2007.
Office 2007 User Interface
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
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
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
This video will give you an introduction on the basic rules for the creation of new Excel tables. Using these rules will help you save time and help facilitate your work.
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.
This video will show you how to format Excel tables by using the predefined table styles from the quick styles gallery.
This video will show you how to work with conditional formatting. You will learn how to highlight cells by customized rules.
This video will give you an introduction to the tools and possibilities for modifying charts.
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
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
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
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.
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
We will show you in this video how to access the data form from older versions of Excel in Excel 2007.
Specifying Security Settings
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.
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
This video will show you how to use the help function in Office.
Using the new filetypes in older Office-Versions
Microsoft offers a compatibility pack for all versions from Office 2000 onwards which you can use to read and edit files that have been created with Word, Excel or PowerPoint 2007.