This Excel course for advanced learners explains tasks for working with Excel on a daily basis. Learn how to adjust the users interface according to your needs and how to use key combinations to access the most common commands quickly and easily. You will also learn how to work with advanced evaluation functions such as Consolidation and Pivot Tables which can be used to analyze large amounts of data quickly and comfortably.
In this video we will show you how to use the text wrap to divide a long text into different rows within one cell.
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.
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.
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.
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.
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.
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.
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 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 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.
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.
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.
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.
Removing duplicates
Film
3 Min.
In this video you will learn how to find and remove duplicate records in your tables.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 Charts
Film
3 Min.
In this video you will learn how to create charts.
Modifying Charts
Film
2 Min.
This video will give you an introduction on the tools and possibilities you have for modifying charts.
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.
Formatting Charts
Film
6 Min.
In this video you will learn how to format charts by adjusting the color, shape and design of it.
Custom Chart Types
Film
3 Min.
This video will show you how to create, save and apply custom chart types.
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.
Combination Charts
Film
4 Min.
In this video we will show you how to present data in a chart by combining various chart types.
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.
Using Passwords
Film
3 Min.
This video will show you how to restrict the access to your documents by assigning passwords.
Home
Online Courses
= free Demo 
= just released 
= already seen
