Username:  
Password:  

Online-Help: Microsoft Excel 2007

Your Search:    
     
= free Demo       = just released       = already seen
Title of Film Length Info
Absolute References 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.
Accessing Databases 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.
Accessing PivotTable Details 2 Min.
In this video you will learn how to display the detailed information behind your calculations in a Pivot Table.
Adding Macros to the Quick Access Toolbar 2 Min.
In this video you will learn how to start your macros using the quick access toolbar.
Add-Ins 3 Min.
This video will show you how to work with add-ins.
Array Operations 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 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 8 Min.
This video will introduce you to the basic terms that you need for working with Excel.
Calculating Across Worksheets 3 Min.
This video will show you how to make calculations across several worksheets of your Excel table quickly and easily.
Calculating Capital Value 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 9 Min.
Calculate the linear and degressive amortization of assets using the SLN and VDB functions.
Calculating the IRR 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 3 Min.
This video will show you how to make calculations across several files and what you have to keep in mind.
Combination Charts 4 Min.
In this video we will show you how to present data in a chart by combining various chart types.
Conditional Formatting 5 Min.
This video will show you how to work with conditional formatting. You will learn how to highlight cells by customized rules.
Connectors 6 Min.
In this video you will learn how to connect the objects of a graphic to make their relationship visible and clear.
Consolidation 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 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 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 and Moving Worksheets 3 Min.
This video will show you how to quickly and easily copy or move one or several tables.
Copying the Formatting 2 Min.
This video will show you how to copy formatting in order to apply it to other cells by using the format painter.
COUNTIF Function 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 11 Min.
Create customizable calenders by using three simple formulas, autofil and conditional formatting.
Creating Charts 3 Min.
In this video you will learn how to create charts.
Creating Formulas 4 Min.
This video will show you how to create your own formulas and what you have to keep in mind.
Creating Macros 8 Min.
This video will show you how to create macros in order to automate a specific task.
Creating New Tables 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 save time and help facilitate your work.
Creating Pivot Charts 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 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 3 Min.
This video will show you how to create, save and apply custom chart types.
Customizing the Userīs Interface 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 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 10 Min.
In this video we will explain the calculation basics for date and time functions in Excel.
Date Functions DATE 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 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 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 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 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 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 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 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 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 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 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.
Filtering Data (Advanced Filters) 8 Min.
This video will show you how to filter data even by the most complicated criteria using the advanced filter.
Filtering Data (Autofilter) 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 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 6 Min.
In this video you will learn how to format charts by adjusting the color, shape and design.
Formatting Numbers 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 3 Min.
This video explains how to use the formatting options to display your PivotTables with a pleasant design. We will give an introduction to the style templates available for PivotTables and show you how to format numbers.
Formatting Tables 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) 6 Min.
This video will show you how to adjust the formatting of the cells to your personal needs.
Formatting Tables Overview 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 7 Min.
We will show you in this video how to audit, repair and fix calculations by using the formula auditing.
Freeform Shapes 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 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 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 4 Min.
In this video we will show you how to display information with a higher or lower level of detail by grouping data. Additionally you will, for example, learn how to group daily results into weekly or monthly results.
Grouping Worksheets 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 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 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 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 5 Min.
This video will show you how to insert worksheets, columns and rows and what features Excel offers.
Keyboard Shortcuts 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 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 PivotTables 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 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 also how to modify the legend and the labelling.
Modifying Charts 2 Min.
This video will give you an introduction to the tools and possibilities for modifying charts.
Moving and switching rows 2 Min.
In this video you will learn how to move and switch rows in Excel.
Nested IF-Functions 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.
Novelties Excel 2007 6 Min.
In this video we explain the new features of Excel 2007.
Office 2007 User Interface 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 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 5 Min.
This video will show you how to reduce the file size of your images.
Picture Tools - Contrast, Brightness, Color 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 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 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 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 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 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 5 Min.
This video will introduce you to the user interface. Additionally you will become familiar with the work and command area.
Protecting Worksheets 4 Min.
This video will show you how to protect the cells in your tables for unwanted editing.
Publishing PDF Documents 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 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 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 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 3 Min.
In this video you will learn how to find and remove duplicate records in your tables.
Removing Sensitive Data 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 5 Min.
In this video you will learn how to mark, copy and move elements by using the mouse.
Selecting Cell Content 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 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 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, show you how to insert and edit a graphic and how to add text to them.
Sorting Tables 4 Min.
This video will show the different options for sorting range tables by its content.
Specifying Security Settings 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 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.
The Status Bar 4 Min.
In this video we will give you a brief overview of the different indicators and tools on the Status Bar in Microsoft Excel.
Time Functions 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 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 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 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 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 4 Min.
In this video you will learn how to create custom lists which you can easily add to your tables at a later time. In addition we will show you how to define your own sorting criterias.
Using Data Tables 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 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 3 Min.
This video will show you how to restrict the access to your documents by assigning passwords.
Using Range Names 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 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 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 Text Wrap 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.
Using the AutoFill feature 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 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 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 6 Min.
This video will show you how to use the help function in Office.
Using the new filetypes in older Office-Versions 3 Min.
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.
Using the Page Break Preview 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 and Control Keys 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 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 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 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 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 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 8 Min.
In this video you will learn how to create the cell formats date and time.
Working with Exponents and Roots 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 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 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 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.
back to top
 

To Online Course:

Excel 2007 Beginner..
Excel 2007 Advanced..
Excel 2007 Expert..
Excel 2007 Upgrader..


Watch Sample Movie




One year
excellent support
eg. Excel:

all Online Courses,
(from Beginner to Expert)
Online-Help,
Special Topics
only 59.90 EUR
Buy now..   



Subscription Range:
A subscription incorporates all the versions and course levels available for the product!

Subscription Term/Cancellation:
Your subscription ends automatically at the end of 12 months so cancellation is not necessary.

Subscription Extension:
An extension for a further year costs only 50% of the initial license fee.

Payment and Access:
On payment by the payment methods listed below the login data is sent to you immediately. On payment via normal bank transfer the login data is sent to you upon receipt of payment.


Use these payment methods
and start immediately!
Secure Payment Processing with Worldpay Secure Payment Processing with Worldpay
Secure Payment Processing with Worldpay Secure Payment Processing with Worldpay Secure Payment Processing with Worldpay
Secure Payment Processing with Worldpay
Secure Payments by PayPal SOFORT Banking - Fast & Secure.


You would like to use our Online-Service in your business?

Go to Corporate Orders..

    Feedback/Suggestions