Username:  
Password:  

Online Course: Excel 2007 Beginner

In the Excel course for beginners we familiarize you with the basics of Excel. First you will learn the basic concepts. Then you will see how to create illustrative tables and customize these using different formatting techniques with just a few simple steps. We will show how to create your own calculations using functions such as Sum or Average. In addition you will learn how to prepare your tables for printing.

Course Duration: 5 - 8 hours
= free Demo       = just released       = already seen
Title of Film Length Info
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.
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.
Basic Terms 8 Min.
This video will introduce you to the basic terms that you need for working with Excel.
Select, Move, Copy 5 Min.
In this video you will learn how to mark, copy and move elements by using the mouse.
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.
Moving and switching rows 2 Min.
In this video you will learn how to move and switch rows in Excel.
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.
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 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.
Inserting Tables, Rows, Cells 5 Min.
This video will show you how to insert worksheets, columns and rows and what features Excel offers.
Copying and Moving Worksheets 3 Min.
This video will show you how to quickly and easily copy or move one or several tables.
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.
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.
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.
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.
Sorting Tables 4 Min.
This video will show the different options for sorting range tables by its content.
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.
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.
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.
Creating Formulas 4 Min.
This video will show you how to create your own formulas and what you have to keep in mind.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Using the Help Function 6 Min.
This video will show you how to use the help function in Office.
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..