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.
Auto Recovery
5 Min.
In this video we will show you how to recover documents or earlier file versions in the Office Programs that have not been saved.
Avoiding the Protected View
2 Min.
In this video we will show you how to avoid the Protected View when opening the example files downloaded from our website.
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
10 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
10 Min.
Calculate the linear and degressive amortization of assets using the SLN and VDB functions.
Calculating the IRR
10 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.
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
5 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.
Create Your Own Tabs
8 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.
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.
Creating Screenshots
4 Min.
In this video we will show you how to take a screenshot in Office programs and then insert it into your document.
Custom Chart Types
3 Min.
This video will show you how to create, save and apply custom chart types.
Customizing the Command Area
5 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
9 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.
Displaying the Developer Tools
2 Min.
In this video you will learn how to display the Developer Tools tab. There you have access to macros, to the VBA editor, and you can apply various controls such as checkboxes, list boxes and drop-down menus.
Editing Pictures - Adjusting Size
4 Min.
In this video you will learn how to adjust the size of images, shapes and clip-arts and we will tell you what to keep in mind when doing so.
Editing Pictures - Adjustments and Effects
5 Min.
In this video you will learn how to adjust the brightness, contrast and color of inserted pictures. Additionally, we will show you how to re-color pictures.
Editing Pictures - Compressing Images
4 Min.
This video will show you how to reduce the file size of your images.
Editing Pictures - Cropping Pictures
4 Min.
This video will show you how to crop and remove unneeded parts from clip-arts, shapes and images.
Editing Pictures - Free-Form Cropping
4 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.
Editing Pictures - Using Picture Styles
4 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 picture styles and effects and how you can make further detailed adjustments.
File Types and Compatibility
5 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.
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.
Filtering in PivotTables
6 Min.
In this video you will learn how to filter data from Pivot Tables quickly and easily in Excel using the Slicer tool.
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.
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.
Interactive Command Guide
3 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.
Keyboard Shortcuts
4 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.
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 2010
8 Min.
In this video we will show you the novelties and improvements of Excel 2010.
Office 2010 User Interface
8 Min.
In this video we explain the new User Interface in Office 2010 and show you the basic differences to older versions.
Printing in Excel
7 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
5 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.
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".
Removing Duplicates
3 Min.
In this video you will learn how to find and remove duplicate records in your tables.
Removing Sensitive Data from Documents
5 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.
Saving PDF Documents
2 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.
Saving XPS Documents
3 Min.
In this video we will show you how to save files in the Microsoft format XPS. The XPS format is comparable to the PDF format, as the documents don't take up much space and cannot be edited further.
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.
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 2010 by using the trust center. We will explain how you can block macros and Active X controls and how to define the optimal settings.
SUMIF-Function
6 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
5 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.
Using Access Keys
4 Min.
This video will show you how to use access keys in Office 2010. 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 Calculated Fields in PivotTables
10 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 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
4 Min.
In this video you will learn how to limit access to your documents by setting 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 Sparklines
5 Min.
In this video you will learn how to create Sparklines in Excel. Sparklines are miniature charts that can be inserted into a cell.
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
7 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 will introduce you to the Office clipboard which is used to copy and insert objects into documents across the different programs.
Using the Help Function
6 Min.
This video will show you how to use the help function in Office.
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.
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.
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!
You would like to use our Online-Service in your business?
Home
Online Help
