Course information

Opatel LeercentrumThe Excel Advanced course in the Opatel Learning Center is a combination of self-study and supervised study. At your own pace you will follow video and audio tutorials and do assignments from a coursebook, under the guidance of our MS Office teacher. Once you have mastered the curriculum (subjects) you will take a certified test. Read all about The Opatel Learning Center here.

Het Opatel Leercentrum in Rotterdam

The Opatel Learning Center in Rotterdam

What do you learn during this course?

In the Excel Advanced course you will learn the more advanced functions of Excel. Important features of this course are among other things using Pivot Tables, logical functions and conditional formatting. 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?

If you would like to take this course, a working knowledge or experience of using Excel is a prerequisite. To be sure you are optimally prepared, take the Excel for beginners course beforehand.

For whom is this course intended?

Do you like to study independently whenever you want  then The Opatel Learning Center (OLC) is the ideal solution. For groups of colleagues the OLC is perfect because participants receive the curriculum that fits their skill level  and everyone learns at their own pace. Read all about the OLC here.

What is a logical sequal for this course?

In our webshop you can find the online course Excel Expert, a course for the diehard Excel users. Would you like to become a Microsoft Office Specialist? Then take a MOS exam at Opatel.

Course content
    • Adjusting user interface (duration 30 minutes)
    • Adjusting interface: Quick Access Toolbar
    • Adjusting interface: The Ribbon
    • Working with multiple sheets
    • Working with multiple sheets
    • Calculations on mutliple sheets
    • Disconnecting sheets, connecting files
    • Datavalidation and comments
    • Data validation and drop down lists
    • Editing: using comments
    • Tables and data sheets
    • Pivot tables and charts (duration 2 hours)
    • Pivot tables
    • Pivot chart
    • Macros (duration 30 minutes)
    • Macros
    • Advanced chart options
    • Advanced chart options
    • Using trendlines
    • Sparklines
    • Formula auditing and templates
    • Formula auditing options
    • Creating and using Templates
    • Using Cell names
    • Functions
    • Calculation functions
    • Logical functions
    • Functions: IF, AND, ; Amount.if, Sum.if
    • Vertical look up
    • Conditional Formatting
    • Conditional Formatting
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