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 Demo = just released = already seen
Title of Film
Novelties Excel 2010
In this video we will show you the novelties and improvements of Excel 2010.
Office 2010 User Interface
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
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.