Username:  
Password:  

Online Course: Excel 2010 Advanced

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.

Course Duration: 7 - 11 hours
= free Demo       = just released       = already seen
Title of Film Length Info
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.
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.
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.
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.
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.
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.
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.
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 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 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.
Calculating Across Worksheets 3 Min.
This video will show you how to make calculations across several worksheets of your Excel table quickly and easily.
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.
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 Data (Advanced Filters) 8 Min.
This video will show you how to filter data even by the most complicated criteria using the advanced filter.
Removing Duplicates 3 Min.
In this video you will learn how to find and remove duplicate records in your tables.
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.
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.
Converting Currency 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 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 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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Accessing PivotTable Details 2 Min.
In this video you will learn how to display the detailed information behind your calculations in a Pivot Table.
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 Charts 3 Min.
In this video you will learn how to create charts.
Modifying Charts 2 Min.
This video will give you an introduction to the tools and possibilities for modifying charts.
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.
Formatting Charts 6 Min.
In this video you will learn how to format charts by adjusting the color, shape and design.
Custom Chart Types 3 Min.
This video will show you how to create, save and apply custom chart types.
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.
Combination Charts 4 Min.
In this video we will show you how to present data in a chart by combining various chart types.
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.
Using Passwords 4 Min.
In this video you will learn how to limit access to your documents by setting passwords.
back to top
 

 

switch to Online-Help..



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
Confirm

This site uses cookies. By visiting this website you agree to the use of cookies. More on this..