Instructor Tom

"Have you ever wondered what your documents should look like? Take matters into your own hands and become the layout expert! Cerm delivers a wide range of standard layouts, created in List & Label. But in order to adapt and convert them into the corporate identity of your company, you need both Cerm's and List & Label's knowledge."

Pricing options

Choose one of the pricing options below

    • Access to videos
    • Extended manual
    • Support = Helpdesk
    • € 250

    • Access to videos
    • Extended manual
    • Access to environment
    • Certificate
    • Assistance
    • 2 free hours helpdesk
    • € 1000 / € 500

Social proof: reviews

5 star rating

Your training was very clear

Neacsu Grita

Tom manages to explain seemingly complicated things and knowledge in a very simple and clear manner.

Tom manages to explain seemingly complicated things and knowledge in a very simple and clear manner.

Read Less
5 star rating

A great training course

Pip Horsman

A great training course, even for beginners with no SQL knowledge

A great training course, even for beginners with no SQL knowledge

Read Less
Watch Intro Video

Result?

An example of what you can do after this course

Still not convinced?

Reflect on all the times you or your co-workers needed help to make adjustments to your document layouts.
You had to schedule an appointment with your consultant or file a ticket at the Cerm Helpdesk and wait for a response.
By resolving these layout issues yourself, you will not only gain time, but this will save you valuable consultancy hours!
Watch Intro Video

Introduction to the Document Layouts course

See what we have in store for you!

Course curriculum

  • 1

    Welcome to the course!

    • Introduction Document Layouts
  • 2

    Course 1

    • Getting started

    • Create a new layout from scratch

    • Copy of an existing layout

    • Import a layout from the Cerm database

    • Delete a layout

    • Replacing layouts

    • Properties of a layout

    • Defining the printer choice per layout/user

    • Translations in layouts

    • Object list

    • Layers

    • Include logo layout

    • Variables

    • User variables

    • Preview

    • Insert text/line/rectangle/picture

    • Insert barcode

    • Insert PDF

    • How to test

    • Course 1: Cases
  • 3

    Course 2

    • String functions

    • Numerical/Mathematical functions

    • Date functions

    • Concatenate

    • Appearance condition in a formula

    • Replacing a hardcoded text

    • Table contents

    • Line properties

    • Column properties

    • Group lines

    • Page number

    • Comment in a formula

    • Pre-printed stationary

    • Printing an additional packing label

    • Adding sales conditions

    • Case together - Logo of reseller

    • Course 2: Cases
  • 4

    Course 3

    • Database explorer

    • SQL statements

    • Adding a new query

    • Adding variable to an existing query

    • Troubleshooting tips

    • Case together - Representative keyword on invoice

    • Course 3: Cases
  • 5

    Additional cases

    • Display all the SKU's in a box on the box label
  • 6

    Other

    • Feedback

    • Multi-table layouts

Training environment

During the course you get to see all training videos. You get the full documentation on Cerm List & Label. Our layout expert is available to assist you. And you also get access to the fully functional Cerm training environment. There you can solve the practical cases on the prepared layouts!

Access to this training environment is possible during one of the following weeks:
  • Week 8: 22/02/2021 - 28/02/2021
  • Week 12: 22/03/2021 - 28/03/2021
  • Week 16: 19/04/2021 - 25/04/2021
  • ... more will be announced later