In our seminar rooms or comfortably from home!

Professional Compositing, Animation, and Motion Design: Understand and Apply

Adobe After Effects is the industry standard for professional animation, motion graphics, and compositing. In film, advertising, social media, and corporate communications, visual effects, animated titles, and dynamic graphics have long been essential. After Effects opens up creative possibilities that go far beyond simple video editing programs.

In this hands-on introductory seminar, you will learn how to animate clips, design layers, use masks, combine effects, and precisely edit video elements. Through numerous examples and exercises, you will develop an understanding of the creative workflow—from animation and keyframes to final output.

Our experienced trainers will show you:

• How to build animations using keyframes
• How to effectively use layers, masks, and effects
• How After Effects integrates with Photoshop and Premiere Pro
• How to create professional titles, lower thirds, and visual effects

Your benefits at a glance

• Practice-oriented training with plenty of exercises and real-world examples

• Clear introduction to animation, keyframes, and compositing

• Professional tips for motion graphics and video effects

• A structured workflow from concept to rendering

• Ideal for social media, marketing, film projects & corporate videos

• Participation possible on-site or live online

Seminar Contents

The After Effects Interface

• Workspace, panels & layouts
• Project settings and basic controls

Animation & Keyframes – The Basics

• Step-by-step keyframe animation
• Understanding and applying keyframe interpolation
• Animation speed & Graph Editor

Media Import & File Formats

• Importing footage
• File formats for video, graphics, and animation

Integration in the Creative Cloud Workflow

• Working with Photoshop, Illustrator, and Premiere Pro
• Adobe Dynamic Link: seamless workflow between After Effects & Premiere Pro

Compositions and Layers

• Creating compositions
• Layer types and layer controls
• Text animations (titles, credits, lower thirds)

Shapes & Graphic Animation

• Working with shape layers
• Trimming paths
• Creating an animated lower third

Visual Effects & Masking Techniques

• Filters, effects, and visual adjustments
• Layer masks and animated masks
• Keying, greenscreen, and the Roto Brush tool

Motion Tracking & Stabilization

• Motion tracking
• Stabilizing shaky footage

Output & Rendering

• Formats for web, social media, and film
• Rendering options & best practices
• Tips & tricks for optimal quality

Target Audience

This After Effects seminar is designed for:

• Beginners in video production
• Employees in marketing, social media, communications & design
• Content creators, video editors & graphic designers
• Anyone who wants to create professional animations and motion graphics

Prerequisites

• Basic knowledge of Adobe programs is helpful but not required
• For online participants: Adobe After Effects must be installed

Learn Excel basics in a practical way: create tables, calculate data, and analyze information.

In this two-day fundamentals workshop, participants will learn the most important features of Microsoft Excel.
The course teaches how to efficiently enter, format, calculate, and evaluate data.

A special focus is placed on analyzing large data sets, creating clear reports and charts, and using basic formulas and functions.

Your Benefits at a Glance

• Efficient work with tables and lists
• Basic data analysis, calculations, and chart creation
• Tips and tricks for fast navigation and efficient work in Excel
• Participation possible in person or online

Seminar Contents

Basic Program Operation

• Use and customize tabs and ribbons
• Personalize the workspace including the Quick Access Toolbar
• Create, save, and organize workbooks

Creating and Editing Tables

• Enter numbers and text
• Move, copy, and use paste options
• Delete or insert rows and columns
• Tips for fast navigation in tables
• Use AutoFill features

Formatting Tables

• Apply text and number formats
• Create borders and background formats
• Add headers and footers
• Use table styles

Working with Large Lists

• Freeze rows and columns, split tables
• Sort and filter lists
• Analyze data in dynamic tables
• Create subtotals

Printing Tables and Print Preparation

• Adjust page margins, print areas, and print titles
• Optimize page breaks

Performing Basic Calculations

• Basics of formulas and functions
• Add, multiply, divide, and subtract values
• Use functions: SUM, MAX, MIN
• Understand relative and absolute references

Creating Charts

• Chart types and their use
• Create simple charts
• Customize chart options

Prerequisites

• Basic knowledge of Office or any earlier Office version is an advantage

Target Audience

• Users who work with Excel to create tables, calculate values, and analyze data
• Beginners and employees who need a solid foundation for further Excel training

In this two-day training course, participants will learn the fundamental features of Excel 365, both locally and online.
The course provides hands-on instruction on how to enter, format, calculate, and analyze data.

A special focus is placed on analyzing large data sets, creating charts, and working with dynamic tables.
Participants will also learn how to effectively use Excel Online and shared workbooks.

This course is ideal for beginners and for anyone who wants to build a solid foundation for the professional use of Excel 365.

Your Benefits at a Glance

• Confident use of Excel 365 locally and online
• Efficient data entry, formatting, and analysis
• Creation of dynamic tables and charts
• Tips and tricks for fast navigation in Excel
• Participation possible in person or online

Seminar Contents

Basic Program Operation

• Start Excel locally or online
• Create, save, and organize workbooks

Creating and Editing Tables

• Enter numbers and text
• Move, copy, and use paste options
• Delete or insert rows and columns
• Tips for fast navigation within tables
• Use AutoFill features

Formatting Tables

• Apply text and number formats
• Create borders and background formats
• Add headers and footers
• Use table and cell styles

Working with Large Lists

• Freeze rows and columns, split tables
• Sort and filter lists
• Analyze data in dynamic tables
• Use slicers in dynamic tables
• Create subtotals

Printing Tables and Print Preparation

• Set page margins
• Define print areas and print titles
• Adjust page breaks

Performing Basic Calculations

• Basics of formulas and functions
• Add, multiply, divide, and subtract values
• Use functions: SUM, MAX, MIN
• Understand relative and absolute references

Creating Charts

• Chart types and their uses
• Create simple charts
• Customize chart options

Collaborating on Workbooks

• Share workbooks
• Edit workbooks in Excel Online

Prerequisites

• Basic knowledge of Office 365 or any earlier Office version is an advantage

Target Audience

• Users who work with Excel 365 locally or online to create spreadsheets, perform calculations, and analyze data
• Beginners who want to build a solid foundation for advanced Excel courses

Advanced techniques for data formatting, analysis, pivot tables and automation with Excel 365.

In this two-day training course, participants will learn advanced techniques for entering, formatting and evaluating Excel data. The focus is on professional data analysis, the use of logic and reference functions, and the efficient use of pivot tables.

In addition, participants will be introduced to macros for automating recurring tasks and significantly speeding up workflows.

Ideal for anyone who wants to bring their Excel skills up to a professional level and evaluate complex data with confidence.

Your advantages at a glance

• Advanced data analysis and function application
• Creating, customising and graphically evaluating pivot tables
• Protecting data in a targeted manner and securing workbooks
• Introduction to macros for automation
• Participation in person or online possible

Seminar Contents

Working with Tables

• Edit and format tables
  • Apply conditional formatting
  • Create drop-down lists
  • Define and use named ranges

Data Analysis with Functions

• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• IFERROR

Logical Functions

• Create simple IF() formulas
• Combine functions (AND(), OR(), etc.)
• IFS(), LAMBDA()

Array and Dynamic Array Functions (New in Excel 365)

• VLOOKUP(), XLOOKUP()
• CHOOSECOLS(), FILTER(), UNIQUE(), SORT()

Date and Time Calculations

• Basic date calculations
• Formatting date and time values

Data Analysis with Pivot Tables

• Create PivotTables from Excel data
• Modify rows and columns
• Use table layouts and PivotTable options
• Create PivotCharts

Data Protection

• Protect workbooks
• Protect worksheets
• Protect cells and ranges

Macros and Automation (Introduction)

• Record and save macros
• Automate routine tasks

Prerequisites

• Participation in an Excel fundamentals course or equivalent solid knowledge
• Basic experience working with Excel spreadsheets

Target Audience

• Users with good basic Excel skills who want to deepen and expand their knowledge
• Professionals who want to efficiently analyze, visualize, and automate data
• Employees in controlling, administration, project management, or commercial/business roles