MS Excel advanced

Why take this course

You know the basics of Excel, but want to fully leverage its potential? This training will teach you advanced analytical, reporting, and automation functions. With the knowledge you gain, you’ll transform raw data into clear insights and make better business decisions.

What you’ll learn

• Use advanced Excel functions and formulas
• Perform complex data analysis
• Apply data validation and conditional formatting
• Create interactive reports and pivot charts
• Combine data from multiple sources and work with databases
• Use Solver and Analysis Toolpak for optimization
• Automate tasks with macros
• Manage access, changes, and data protection

Certification & Exam

Upon completing the course, you will receive a personalized certificate confirming your advanced Excel skills – including functions, pivot tables, complex formulas, and data analysis. There is no final exam – active participation in the sessions is enough.

Who is this course for

• Individuals with a solid understanding of Excel basics (cell referencing, sorting, autofilter, functions)
• Analysts and specialists working with large datasets
• Office and administrative staff looking to improve daily workflows
• Professionals responsible for reporting, data presentation, and process optimization

Topics covered

• Advanced formula
• Naming cells, advanced work with cells named.
• Conditional Formatting
• Forms
• Advanced filters
• Subtotals after a few categories
• Data Validation
• Sharing a workbook
• Change Management
• Data protection
• Pivot Tables and Pivot Charts
• The connection to the database, query databases
• Macros. Create, edit and run macros
• Manager scenarios
• Tools MS Solver and Analysis Toolpak
• The window detector

This range is the basis for the classes and may be subject to slight changes depending on what the individual preferences of the group.