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
Novelties Excel 2010 | |
16-24 Min. |
|
In this video we will show you the novelties and improvements of Excel 2010. | |
Office 2010 User Interface | |
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 | |
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 | |
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 | |
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 | |
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 | |
18-30 Min. |
|
In this video you will learn how to format charts by adjusting the color, shape and design. | |
Conditional Formatting | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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. | |
You would like to use our Online-Service in your business?
Go to Corporate Orders..