Microsoft Excel Foundation («ME1»)

• Learning the basic techniques of working with Excel workbooks
• Creating simple tables with calculations on your own
• Understanding the most common formatting options in Excel and how to use them effectively
• Knowing how to open, save, manage and print workbooks

In this course, you will learn the functional principle of Microsoft Excel. Using practical examples, our trainers will introduce you to the basics of the spreadsheet program. The course enables you to use Excel in a fundamental way.

1 Overview

• Definition
• Workspace
• Arranging workbooks

2 First steps

• Texts and figures
• Moving and marking in the table
• Edit and delete cells
• Copying, moving and insert cells

3 Table structure

• Insert, delete and change columns and cells

4 Excel workbooks

• Insert and delete, move and copy workbooks

5 Formatting cells

• Formatting headlines
• Border
• Number format
• Delete and adopt formats

6 Formula, cell reference and basic functions

• Basic principles of formula
• Calculation with percentages
• Calculating work schedule 
• Relative and absolute cell references
• Summation

7 Helpful Features

• Formatting as table
• Arranging cells
• Simple re-sorting
• Filter dates
• Screening data

8 Page layout and printing

• Page setup
• Headers and footers
• Setting the print area
• Printing

This course is aimed at users who have not yet or hardly ever worked with Excel and now want to learn the basic handling of this software.

There are no formal prerequisites for this course. However, basic computer skills are recommended to maximise the benefits of the course.

This course is also suitable for users of Excel 2016, 2013 and 2010.