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
Information on the Course
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.
Avoiding the Protected View
In this video we will show you how to avoid the Protected View when opening the example files downloaded from our website.
Program User Interface
This video will introduce you to the user interface. Additionally you will become familiar with the work and command area.
This video will introduce you to the basic terms that you need for working with Excel.
Select, Move, Copy
In this video you will learn how to mark, copy and move elements by using the mouse.
Using the Shift and Control Keys
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
In this video you will learn how to move and switch rows in Excel.
Creating New Tables
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
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
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
This video will show you how to insert worksheets, columns and rows and what features Excel offers.
Copying and Moving Worksheets
This video will show you how to quickly and easily copy or move one or several tables.
Formatting Tables Overview
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.
This video will show you how to format Excel tables by using the predefined table styles from the quick styles gallery.
Formatting Tables (Cells)
This video will show you how to adjust the formatting of the cells to your personal needs.
Copying the Formatting
This video will show you how to copy formatting in order to apply it to other cells by using the format painter.
This video will show you how to format numbers. We will introduce you to the different number formatting options and their typical application.
This video will show the different options for sorting range tables by its content.
Generel Information about Functions
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
This video will show you how to work with default functions such as minimum and maximum in an easy and pleasant way.
This video will show you how to create your own formulas and what you have to keep in mind.
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
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
This video will show you how to add comments to certain cells in Excel and how to edit them.
Printing in Excel
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
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.
This video will show you how to create and edit a series of identical range tables simoultaneously in order to save time.
The Status Bar
In this video we will give you a brief overview of the different indicators and tools on the Status Bar in Microsoft Excel.
Saving PDF Documents
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
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.
Using the Clipboard
This video will introduce you to the Office clipboard which is used to copy and insert objects into documents across the different programs.
Specifying Security Settings
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.
Using the Help Function
This video will show you how to use the help function in Office.