Excel Gevorderd - Databases en draaitabellen Add to favorites

Want to create analyses and reports in Excel using databases and pivot tables? Learn how in this one-day course , Excel Advanced | Databases and Pivot Tables .

Do you have data about inventory, items, locations, or personnel in Excel? In this advanced Excel course, you'll learn how to find answers to questions like "How much...", "Which...", "Where...", and "Who..." and how to spot trends and patterns in your data.

Our experienced trainer will guide you through the world of Excel tables, databases, and pivot tables through numerous exercises and practical examples. This will help you easily extract financial and statistical information from all kinds of data files. You'll learn how to navigate your data more effectively, create reliable analyses, and generate informative reports. Knowing how to shorten routine tasks with macros will save you a significant amount of time.

Your participation is flexible; you choose how you participate: in person in the classroom or online from your own space. With a maximum of 8 participants, we guarantee personalized attention and space for your specific questions. All course materials, hands-on tips, and techniques are immediately applicable in your work!

Is Excel Advanced | Databases and Pivot Tables right for you?
You want to learn and apply the capabilities of Excel databases, pivot tables, and macros so you can easily summarize, analyze, research, and present data.

What will you learn in this Advanced Excel - Databases and Pivot Tables training?
After completing this course you will:

• set up a workable database or adapt an existing database to it;
• do you work with Excel tables and pivot tables?
• create the corresponding graphs;
• you can summarize, analyze and present information from databases in various ways;
• do you know how to shorten routine actions with simple macros;
• Have you applied the training themes in assignments and cases?

Do you have questions and examples from your own work? Bring them with you. Or save them on your computer. You'll receive expert answers and practical advice.

What is the curriculum?
Working with databases

• Introduction to databases
• Sorting data
• Filter data
• Advanced filter (set criteria, AND relationship, OR relationship, copy filtered data to retrieval range)

Working with Excel tables

• Benefits of an Excel table
• Insert and format an Excel table
• Using a Total Row (SUBTOTAL Function)
• Structured cell references

Working with pivot tables and charts

• Create pivot table
• Change table layout
• Pivot table filter
• Slicers
• Sorting data
• Refresh pivot table
• Pivot chart

Data operations

• Calculated fields and items in pivot table
• Group fields
• Link data using the pivottable.get function

Introduction to macros

• Macros (record, run, save and view)
• Modify macros (errors, editing, project explorer)
• Absolute and relative recording (combination recording)
• Launch options (start macro via button on ribbon)

What is the learning approach?
How do you participate?

You can choose how you participate:

• in the classroom at our location, with your own Windows laptop; or
• Online, in a quiet learning environment with a good internet connection. You'll be able to view the class directly via MS Teams. From your own space, you'll be in live contact with the trainer and other participants. You'll receive your course materials digitally.

You indicate your choice when you register.

Classroom and interactive

The one-day Advanced Excel | Databases and Pivot Tables course at train2work is led by an enthusiastic trainer. He illustrates working with Excel with engaging practical examples. You'll discuss theory, share knowledge and experiences, practice, experiment, and receive personalized coaching.

Practice-oriented learning

You bring your own laptop, because you learn more easily and in a very practical way with your own work files in your own Office environment.

Teaching materials

You'll receive an e-book and digital instructional videos with practical explanations of each topic. This means you can always refer back to the topics you've learned and practice again.

Small group, full attention

There is a maximum of 8 participants in the class, which allows for plenty of room for personal attention and asking questions.

About your registration, the start date and other practical matters
You can register for this course immediately. You'll receive a confirmation email. Ten days before the course, you'll receive our invitation with more information about your participation. You're welcome to join us in our online classroom or at our location at Lange Kleiweg 14 in Rijswijk (near The Hague), a 3-minute walk from the station.

Looking for team training tailored to your needs, in-house or customized? Call or email us for the ideal learning solution.