Course information

Each course in the Opatel Learning Center (OLC) is a combination of self-study and supervised study. You will study and make assignments at your own pace in a multimedia learning environment. A teacher will be present to answer your questions and help you when necessary. This course can always be taken at short notice. Read all about the Opatel Learning Center.

Het Opatel Leercentrum in Rotterdam

The Opatel Learning Center in Rotterdam

What do you learn during this course?

In this Excel course for beginners you will learn how to make spreadsheets using calculations and formulas. We will cover the look and design of the worksheet and teach you how to make captivating charts to represent your data. Once you have mastered the material, you will sit a certified exam. The average course duration is 14 hours.

Plan your own days

On the first day the trainer will give you access to an online calendar in which you can plan your following sessions.

What are the prerequisites to follow this course?

This beginners course is for those with little or no Excel experience. Not sure which Excel course to take? Call or email for non-binding advice.

For whom is this course intended?

The Opatel Learning Center (OLC) offers efficient courses at short notice. You are not dependant on tight schedules. The OLC is the ideal solution for groups of participants with mixed skill levels.

What is a logical sequal for this course?

Do you like this method of learning? The Excel Advanced course in the OLC seamlessly continues on from this Basics course.

Course content
    • Excel basics
    • Starting Excel and viewing the program window
    • The Ribbon and the Quick Access Toolbar
    • Opening and closing files
    • Worksheets
    • Navigating through a worksheet
    • Exercises
    • Creating a new file
    • Entering data
    • Save a file
    • Entering data and creating simple formulas
    • Cutting, copying and pasting
    • Calculate with simple formulas
    • Copying formulas
    • Create a simple invoice
    • Exercises
    • AutoSum
    • Using a template
    • Close Excel
    • The help function
    • Set options
    • Save files as a different type
    • Exercises
    • Formatting numbers, text and cells
    • Selecting
    • ont options
    • Options for Alignment
    • Options for number
    • Column width and row height
    • Cell Styles
    • Inserting columns, rows or separate cells
    • Erase formatting and copying formatting
    • Fill handle
    • Exercises
    • Sorting, Searching (duration 30 minutes)
    • Sorting
    • Find and Replace
    • Freeze Panes
    • Charts (duration 2 hours)
    • Insert and design charts
    • Edit chart
    • Edit chart parts
    • Copy chart
    • Exercises
    • Page settings and printing
    • Page settings
    • Scale to page
    • Sheet options
    • Header and footer
    • Printing
    • Exercises
    • Calculation functions
    • Calculation functions (Extra material/ECDL)
    • Absolute and relative cell references
    • Absolute en relative cell references (Extra material/ECDL)
Dates and Locations

1Location and starting date

Choose your starting date. You can plan the next course dates with the trainer at the first course date.

2Data of the participant(s)

Participant 2

Participant 3

Participant 4

Participant 5

If you would like to add more participants, you'll be able to refill in the forms again.

Billing information


3Billing information

Complete your enrollment

4Rond uw inschrijving af

Important! If you enroll for a course, you'll get a confirmation by e-mail. If you did not get this within an hour, please contact us via 010 - 297 30 73 or info@opatel.nl

Bezig met versturen