training

Microsoft Excel: Working with large tables

This training is held in German.
Working in Microsoft Office: Almost all areas of a company have large tables or lists that need to be entered, evaluated, changed or processed quickly. This practical seminar provides you with the content and techniques you need to work efficiently with large, multiple or complex Excel files. Benefit from professional tips and tricks from practice for practice.

Contents

  • Fast movement and marking in large amounts of data.
  • Format large amounts of data as a table.
  • Group, sort and filter tables.
  • Working with partial results.
  • Working with database functions.
  • Create user-defined views.
  • Use data slices to filter data.
  • Introduction to pivot tables.
  • Tips and tricks for using Microsoft Copilot.

Learning environment

In your online learning environment, you will find useful information, downloads and extra services for this qualification measure after you have registered.

Methods

experts, practical tasks and exercises. 

Please use a notebook with the Microsoft Office program installed (version 2016/2019/2021/O365).

We recommend that you work with two screens so that you can participate in the training in the best possible way.

Recommended for

Anyone who works with Microsoft Excel 2016/2019/2021/O365 or the corresponding Microsoft Office versions for Windows.

This training is suitable for anyone who already has basic knowledge of Microsoft Excel and would like to expand their skills.

Open Badges - Show what you can do digitally too.

Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

Read more

Seminar evaluation for "Microsoft Excel: Working with large tables"

4.6 from 5
with 7 ratings
training content:
4.6
Content comprehensibility:
5
Practical relevance:
3.7
Trainer expertise:
5
Participant orientation:
5
Method variety:
5
Joint online training
Booking number
31224
€ 660,- plus VAT
1 day
Online
2 Events
German
Events
Train several employees internally
Pricing upon request
  • Customized training courses according to your needs
  • Directly at your premises or online
  • Cost advantage from 5 participants
  • We contact you within 24 hours (Mon-Fri)
1 day
In-person or Online

Start dates and details

  Select time period
0 events
10.07.2025
Live-Online
Booking number: 31224
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
1 day
Limited number of participants

Thursday, 10.07.2025

09:00 am - 5:00 pm

13.11.2025
Live-Online
Booking number: 31224
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
1 day
Limited number of participants

Thursday, 13.11.2025

09:00 am - 5:00 pm

Sufficient places are still free.
Don't wait too long to book.
Fully booked.
Booking number: 31224
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Details
1 day
Limited number of participants
Booking number: 31224
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Details
1 day
Limited number of participants
Book later
You are welcome to make a non-binding advance reservation.
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
Also bookable as in-house training
demand-oriented adaptations possible
on-site or live online for multiple employees
save time and traveling expenses
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

About us – The Haufe Akademie

Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.

Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.

A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.

Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.

2,500+ further training
600,000+ apprentices per year
Over 95% positive reviews
2,500 trainers and coaches
17,500+ training courses held per year
Call us or send an email

Do you have any questions?

We are there for you Mon - Fri 8 a.m. - 5:00 p.m.

Stephanie Göpfert

Head of Customer Service

*Mandatory fields
FAQs

Questions & Answers

In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.