Online-Help: Microsoft Excel 2007

To Online Course:

Excel 2007 Beginner..

Excel 2007 Advanced..

Excel 2007 Expert..

Excel 2007 Upgrader..

= 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.
Using text wrap	Film	5 Min.
In this video we will show you how to use the text wrap to divide a long text into different rows within one cell.
Absolute References	Film	6 Min.
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas.
Acc PT Details	Film	2 Min.
In this video you will learn how to display the detailed information behind your calculations in a Pivot Table.
Accessing databases	Film	10 Min.
We will show you in this video how to access external databases with Excel with the example of a Pivot Analysis. You will learn how to create a connection to a database server, define a query and add calculated fields to this query.
Adding Macros to the Quick Access Toolbar	Film	2 Min.
In this video you will learn how to start your macros using the quick access toolbar.
Add-Ins	Film	3 Min.
This video will show you how to work with add-ins.
Array Operations	Film	7 Min.
We will show you in this video how to work with array formulas in Excel. Array formulas can be used to perform various calculations at once.
Basic Program Settings	Film	6 Min.
This video will show you how to adjust basic excel program settings such as the default saving area, the quick info, the live preview, the display of gridlines and the number of the worksheets.
Basic Terms	Film	8 Min.
This video will introduce you to the basic terms that you need for working with Excel.
Calculating Across Worksheets	Film	3 Min.
This video will show you how to make calculations across several worksheets of your Excel table quickly and easily.
Calculating Capital Value	Film	11 Min.
In this video you will learn how to calculate the capital value of an investment by using the methods NPV (NET PRESENT VALUE) and XNPV (X NET PRESENT VALUE) of financial mathematics.
Calculating Depreciations	Film	9 Min.
Calculate the linear and degressive amortization of assets using the SLN and VDB functions.
Calculating the IRR	Film	11 Min.
In this film we will show you the three possible functions for the calculation of the internal rate of return.
Calculation Across Files	Film	3 Min.
This video will show you how to make calculations across several files and what you have to keep in mind.
Combination Charts	Film	4 Min.
In this video we will show you how to present data in a chart by combining various chart types.
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.
Connectors	Film	6 Min.
In this video you will learn how to connect the objects of a graphic to make their relationship visible and clear.
Consolidation	Film	5 Min.
In this video you will learn how to use the consolidation feature to summarize several worksheets and make calculations across those worksheets. In addition we will show you what you have to keep in mind.
Converting Currency	Film	3 Min.
In this video you will learn how to convert the values from a table into another currency quickly and easily.
Converting Rows to Columns	Film	3 Min.
It is possible to copy information from other Windows programs and paste them into an Excel table. Unfortunately, these copied information are usually organized in rows. This video will show you how to convert rows into columns and vice versa.
Copying the Formatting	Film	2 Min.
This video will show you how to copy formatting in order to apply it to other cells by using the format painter.
Copying_Moving Worksheets	Film	3 Min.
This video will show you how to quickly and easily copy or move one or several tables.
COUNTIF function	Film	9 Min.
You can use the COUNTIF function in order to determine the amount of cells or records that match a certain criterion. The COUNTIF function can be used with various criteria as well.
Creating calenders	Film	11 Min.
Create customizable calenders by using three simple formulas, autofil and conditional formatting.
Creating Charts	Film	3 Min.
In this video you will learn how to create charts.
Creating Formulas	Film	4 Min.
This video will show you how to create your own formulas and what you have to keep in mind.
Creating Macros	Film	8 Min.
This video will show you how to create macros in order to automate a specific task.
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.
Creating Pivot Charts	Film	4 Min.
In this video you will learn how to create Pivot Charts, how to define the evaluation criteria for your diagram and what kind of relationships Pivot Charts and Pivot Tables can have.
Creating PivotTables	Film	8 Min.
In this video you will learn how to create PivotTables and how to define criteria and evaluation fields. Additionally, we will show you how to set functions such as number and sum needed for the calculation.
Custom Chart Types	Film	3 Min.
This video will show you how to create, save and apply custom chart types.
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.
Data Sources PivotTables	Film	4 Min.
This video will show you the various data sources which can be used for PivotTable analysis. You will learn about the advantages, disadvantages and the neccessary conditions.
Date and time functions - Basics	Film	10 Min.
In this video we will explain the calculation basics for date and time functions in Excel.
Date functions DATE	Film	9 Min.
In this video we will explain the date functions DATE, YEAR, MONTH, DAY and DATEVALUE. Additionally we will give you some examples on how to create your own formulas with this functions and how to sort a birthday list by month.
Date functions DATEDIF	Film	6 Min.
We will show you in this video how to use the date function DATEDIF. The function DATEDIF calculates the difference between two dates.
Date functions DAYS360	Film	4 Min.
We will show you in this video how to use the date function DAYS360 and how to use a calculation formula to calculate interests.
Date functions EDATE and EOMONTH	Film	3 Min.
We will show you in this video how to use the function EDATE and EOMONTH. You can use these functions to determine payback dates and due dates.
Date functions NETWORKDAYS and WORKDAY	Film	5 Min.
In this video we explain the date functions NETWORKDAYS and WORKDAY. You will see practical examples in order to see how these functions work and how to easily calculate due dates and the workdays of a whole year.
Date functions WEEKDAY	Film	4 Min.
We will show you in this video how to use the date function WEEKDAY. Additionally you will see how to display the weekday by using a simple formula.
Date functions WEEKNUM	Film	6 Min.
We will show you in this video how to use the date function WEEKNUM and how to determine the week number according to the european norm EN 28601 by using a formula.
Date functions YEARFRAC	Film	4 Min.
We will show you in this video how to use the date function YEARFRAC. You can use this function to display certain time segments as fractions of a year and this way show and determine maturities and other liabilities.
Display the Developer Tools Tab	Film	2 Min.
In this video you will learn how to display the developer tools tab. This tool gives you access to macros, the VBA editor and to several control features such as check boxes, list and drop-down boxes and others.
Drawing Tools	Film	8 Min.
This video will show you how to use the drawing tools to create appealing graphics and charts. You will learn how to create new shapes and how to adjust their size, design and position.
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.
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.
Filtering Data (Advanced Filters)	Film	8 Min.
This video will show you how to filter data even by the most complicated criteria using the advanced filter.
Filtering Data (Autofilter)	Film	5 Min.
This video will show you how to use the autofilter. You will learn how to filter data by certain criteria and what you have to keep in mind when evaluating the filtered data.
Find and Replace	Film	6 Min.
This video will show you how to use the "find and replace" feature in Excel in order to find and modify values and terms quickly and easily.
Formatting Charts	Film	6 Min.
In this video you will learn how to format charts by adjusting the color, shape and design of it.
Formatting Numbers	Film	5 Min.
This video will show you how to format numbers. We will introduce you to the different number formatting options and their typical application.
Formatting Options PivotTables	Film	3 Min.
This video explains how to use the formatting options to display your Pivot Tables with a pleasant design. We will give an introduction to the style templates available for Pivot Tables and show you how to formate numbers.
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.
Formatting Tables (Cells)	Film	6 Min.
This video will show you how to adjust the formatting of the cells to your personal needs.
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.
Formula Auditing	Film	7 Min.
We will show you in this video how to audit, repair and fix calculations by using the formula auditing.
Freeform Shapes	Film	7 Min.
This video will show you how to use the freeform shapes, which are integrated in the drawing tools, to create charts or to adjust the preset shapes to your personal needs.
Generel Information about Functions	Film	5 Min.
This video will show you the options you have for finding suitable functions for your calculations. Additionally you will learn where you can find further detailed information for working with functions.
Grouping Data	Film	2 Min.
This video will give you an introduction to the subtotal function in order to perform calculations such as minimum, maximum, product or sum for groups of data.
Grouping PivotTables Fields	Film	4 Min.
In this video we will show you how to display information with a higher or lower level of detail by using the grouping. Additionally you will, for example, learn how to group daily results to weekly or monthly results.
Grouping Worksheets	Film	4 Min.
This video will show you how to create and edit a series of identical range tables simoultaneously in order to save time.
IF-AND function, IF-OR function	Film	8 Min.
By using the IF-AND function you will get a certain result if all conditions are met. The IF-OR function will get you a certain result if at least one of the conditions is met.
Information on the Course	Film	6 Min.
In this video you will get important information about how to work with our course and which settings you need to apply before starting to work with it. In addition you will learn how to work with the sample files.
Inserting and Editing Comments	Film	3 Min.
This video will show you how to add comments to certain cells in Excel and how to edit them.
Inserting Tables, Rows, Cells	Film	5 Min.
This video will show you how to insert worksheets, columns and rows and what features Excel offers.
Keyboard Shortcuts	Film	3 Min.
This video will make you familiar with the keyboard shortcuts available in Microsoft Office. We will, in particular, introduce you to the shortcuts for the most common commands.
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.
Mod Val Error Pivot Tables	Film	2 Min.
In this video you will learn how to customize and hide the display of value error messages in Pivot Tables.
Modifying Chart Layouts	Film	8 Min.
This video will show you how to modify the layout options of your charts. You will learn how to adjust the data, the title of the axis and the chart and how to modify the legend and the labelling.
Modifying Charts	Film	2 Min.
This video will give you an introduction on the tools and possibilities you have for modifying charts.
Nested IF-Functions	Film	8 Min.
You can use the function IF in order to run a logical test and you can define what happens if a condition is either true or false. By using a nested IF function you can set various criteria.
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.
Picture Tools - Adjusting Size	Film	6 Min.
In this video you will learn how to adjust the size of images, shapes and clip-arts and what you have to keep in mind.
Picture Tools - Compressing Images	Film	5 Min.
This video will show you how to reduce the file size of your images.
Picture Tools - Contrast, Brightness, Color	Film	6 Min.
In this video you will learn how to adjust the brightness, contrast and color for inserted pictures. Additionally we will show you how to recolor pictures.
Picture Tools - Cropping Pictures	Film	6 Min.
This video will show you how to crop and remove unneeded parts from clip-arts, shapes and images.
Picture Tools - Free-From Cropping	Film	2 Min.
This video will show you how to free-form crop a picture. Free-form-cropping means to erase background colors or motives for stand-alone. This feature is useful for operations such as integrating a stand-alone object into a text.
Picture Tools - Using Picture Styles	Film	5 Min.
In this video you will learn how to design visually appealing graphics by using templates. Additionally we will show you how to manually apply picuture styles and effects and how you can make further detailed adjustments.
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.
Printing Large Tables	Film	4 Min.
In this video you will learn how to modify large tables for printing. We show you how to display the headings of the rows and columns on every page and how to optimize the layout.
Program User Interface	Film	5 Min.
This video will introduce you to the user interface. Additionally you will become familiar with the work and command area.
Protecting Worksheets	Film	4 Min.
This video will show you how to protect the cells in your tables for unwanted editing.
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.
Random Numbers	Film	4 Min.
This video will give you an introduction on random numbers. We will explain the two functions "random numbers" and "random range".
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.
Removing duplicates	Film	3 Min.
In this video you will learn how to find and remove duplicate records in your 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.
Select, Move, Copy	Film	5 Min.
In this video you will learn how to mark, copy and move elements by using the mouse.
Selecting Cell Content	Film	3 Min.
This video will show you how to select cells with specific content such as text or formulas by using the go-to function.
Showing Trends in Charts	Film	6 Min.
In this video you will learn how to show trends in charts. We will explain how to set and format trend lines and how to choose between various trend line options.
SmartArt	Film	7 Min.
In this video you will learn how to use SmartArt graphics to visualize information. We will give you an overview of the available graphic layouts and show you how to insert and edit a graphic and how you can enter text to them.
Sorting Tables	Film	4 Min.
This video will show the different options for sorting range tables by its content.
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.
SUMIF-function	Film	7 Min.
This video will show you how to use the SUMIF-function. By using this function, you can add up the contents of the cells if certain search criteria are met.
Time functions	Film	7 Min.
In this video you will learn more about the functions you can use for working with times: TIME, TIMEVALUE, HOUR, MINUTE, SECOND
Time functions Calculating Times	Film	12 Min.
We will show you in this video how to calculate times in Excel by using a few practical examples. Calculate times of more than 24 hours, work with negative times and calculate industrial minutes or the salary per hour.
Use Calculated Fields in PivotTables	Film	8 Min.
In this video you will learn how to use and create calculated fields in Pivot Tables and what you have to keep in mind.
Using Access Keys	Film	5 Min.
This video will show you how to use access keys in Office 2007. By using access keys on your keyboard you can perform all commands from the Ribbon without undertaking long operation sequences with your mouse.
Using Basic Functions	Film	6 Min.
This video will show you how to work with default functions such as minimum and maximum in an easy and pleasant way.
Using Custom Lists	Film	4 Min.
In this video you will learn how to create custom lists to easily add them to your tables at a later time. In addition we will show you how to define you own sorting criterias.
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.
Using Hyperlinks	Film	8 Min.
This video will show you how to create hyperlinks to jump to related information on another file such as another woorkbook or a website with a simple click.
Using Passwords	Film	3 Min.
This video will show you how to restrict the access to your documents by assigning passwords.
Using Range Names	Film	8 Min.
In this video you will learn how to create and delete range names manually. Additionally we will show you how to make calculations using the manually and automatically created range names.
Using ROUND functions	Film	8 Min.
In this video we will show you how to round number values in Excel, when you need the round functions and what to keep in mind when working with these functions.
Using Templates	Film	6 Min.
In this video you will learn how to create your own templates for the creation of new tables. Additionally we will show you how to modify the standard template given by Excel.
Using the AutoFill feature	Film	6 Min.
This video will show you how to use the Excel feature "autofill" which automatically creates a series of data without having to insert all values and terms manually.
Using the Clipboard	Film	5 Min.
This video explains the Office clipboard which is used to copy and insert objects into documents across the different Office programs.
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.
Using the Help Function	Film	6 Min.
This video will show you how to use the help function in Office 2007.
Using the Page Break Preview	Film	4 Min.
This video will show you how to adjust page breaks to optimize the prints of your tables by using the page break preview feature.
Using the Shift Control Keys	Film	8 Min.
This video will show you when to use the shift key and the control key to mark cell groups for working with them.
Using Workspaces	Film	4 Min.
This video will show you how to group several worbooks to one workspace. Additionally you will learn how to add or remove a workbook from a workspace.
Validating Data	Film	9 Min.
In this video you will learn how to protect your tables from incorrect entries by limiting the setting options according to specific criteria.
VLOOKUP funktion	Film	8 Min.
We will show you in this video how to use the function VLOOKUP. With two examples we will explain the uses of approximate and exact searches. You can use the same procedure for the HLOOKUP function.
What are Pivot Tables	Film	4 Min.
In this video you will learn about the use of Pivot Tables and Pivot Charts. Additionally we will show you possible fields of application.
WordArt	Film	6 Min.
This video will show you how to format your text by applying visual effects from the wordart tool.
Working with date and time formats	Film	8 Min.
In this video you will learn how to create the cell formats date and time.
Working with Exponents and Roots	Film	5 Min.
This video will show you how to work with functions for exponents and roots provided by Excel. It is quicker and easier using the keyboard.
Working with Large Tables	Film	6 Min.
In this video you will learn how to work with large tables and how Excel can help you by providing special functions. It is, for instance, possible to compare values or data sets within a single worksheet or between several worksheets.
Working with scenarios	Film	6 Min.
"Best case","Worst case" and "Base case". Use scenarios to run certain calculations within different starting values and to compare the results.
Working with the Goal Seek Function	Film	3 Min.
This video will show you how to work with the goal seek function. You will learn how to find the value that leads to a certain result without manual variation.