Intermediate Excel

Acquire the tools to assess suppliers’ financial stability and support strategic purchasing and supply chain decisions.

24/04/2026

START DATE

8 hours

COURSE DURATION

9 – 6

ORARI

17/04/2026

REGISTRATION BY

Hybrid

IN THE CLASSROOM AT VIA JAN PALACH, 55, MODENA | REMOTELY ON MICROSOFT TEAMS

Directions

Funding

Courses fundable through Interprofessional Funds

The course can be funded through Funds: please let us know during registration or contact us.

Promotion

−10% on multiple registrations

Applicable for two or more participants from the same company for the same course

Courses are confirmed only upon reaching the minimum number of participants.

Each course adopts the Learning by Doing method, which prioritizes learning through practice.

Who is it for?

For those who want to develop their Excel skills

All Professionals

Prerequisites

There are no necessary prerequisites.

What you will learn

Advanced tools for data analysis and automation

You will be able to process and organize data from management systems
You will be able to use PivotTables to create effective reports
You will be able to create professional and easily readable charts
You will be able to apply advanced filters to analyze large quantities of data
You will be able to create and use macros to automate repetitive tasks
You will be able to understand the basics of VBA language and its operational applications

Program

Data analysis, reporting, and automation with Excel

Module 1 Processing extractions from management systems

Introduction to the activities of extracting and processing data from corporate management systems.

Module 2 Data cleaning and organization

In-depth study of data cleaning techniques and methods for enriching datasets with useful information for reports.

Module 3 Reporting via PivotTables

Creation and management of dynamic reports using PivotTables.

Module 4 Charts and visualization of results

Analysis of data representation methods, chart construction, and visual optimization.

Module 5 Using advanced filters

In-depth study of filtering tools to analyze and segment large quantities of information.

Module 6 Introduction to Macros and VBA

Overview of the potential of Macros and the VBA language as automation tools.

Module 7 Macro creation and application examples

Development of macros using variables, arrays, loops, Input Boxes, Message Boxes, and the use of interfaces and buttons.

Module 8 Learning by doing: exercises and simulations

Practical application of concepts through concrete examples, guided exercises, and real-world cases.

Frequently Asked Questions

FAQ

Is prior Excel knowledge required?

Yes, the course is designed for those who already have basic skills and wish to delve into more advanced tools.

Will PivotTables be covered?

Yes, the program includes creating reports using PivotTables and data analysis.

Will Macros and VBA be discussed?

Yes, the course introduces Macros and the main functionalities of the VBA language through practical examples.

Are exercises included?

Yes, the program follows a strong Learning by Doing approach with concrete examples and exercises.

Request information

Want to improve your Excel skills?

Contact us to receive the complete course program and discover how to analyze data, create reports, and automate tasks with Excel.