In day-to-day work, a significant amount of time is often spent on data organization, manual calculations, and repetitive tasks. Microsoft Excel offers features that allow you to complete such tasks more quickly and efficiently. During the training, participants will learn through practical examples how to use Excel to simplify work processes, reduce time spent on tasks, and achieve greater reliability and transparency when working with data.
Date and Location of the Event
The course consists of three workshops, which will be held on the following dates:
- Thursday, March 12, from 10:15 a.m. to 2:30 p.m.
- Thursday, March 19, 2026, from 10:15 a.m. to 2:30 p.m.
- Thursday, March 26, 2026, from 10:15 a.m. to 2:30 p.m.
The course will take place at the Cene Štupar-CILJ location, 5 Ambrožiča Novljana Street, Ljubljana, on the ground floor in the computer lab. You’ll be working on our computers, but you’re also welcome to bring your own.
Program
The course consists of a series of three workshops that build on one another. It is intended for anyone who uses data in spreadsheets (e.g., lists, records, overviews, reports) in their work or daily tasks and wants to perform their work faster, more efficiently, and with fewer errors. Using real-world business examples, participants will acquire a basic level of Excel proficiency that they can apply to solving specific business problems. Course participants will learn to effectively:
- enter and format data in a table, use the QUICK ANALYSIS tool, and use the DESIGN TABLE tab
- design and print large data tables
- visually highlight exceptions in the data (conditional formatting, sparkline charts, line charts, pie charts, combination charts, Pareto charts)
- remove and flag duplicate data
- split text data using the FLASH FILL and TEXT TO COLUMNS tools, and combine text data using the CONCAT formula and function
- apply various formulas when processing data and calculating structures and indexes
- use mathematical functions when processing data: SUM, AVERAGE, COUNT, COUNTA
- use logical functions when processing data: IF, IFNA
- Combine data from two or more tables by transferring one or more columns using the XLOOKUP function
- create simple pivot tables and charts when preparing reports and analyses.
Workshop Facilitator: Peter Vrečar, M.A.
Peter Vrečar, M.A., completed his master’s degree in information management at the Faculty of Economics . He has completed training in pedagogy and adult education.
For many years, he worked in the business sector, in sales, focusing on the optimization of business processes and related IT support, the implementation of organizational changes, and decision support.
He is a tenured assistant professor of computer science and an assistant professor and instructor of statistical skills at the Faculty of Economics. He also teaches at various colleges and technical universities.
For more than 10 years, he has been conducting workshops on digital content for businesses. He is constantly expanding his knowledge of MS Office 365 services in business environments, with a focus on solutions offered by MS Excel (Power Query, PowerPivot) and Power BI.
Price
The workshop fee is 244 EUR, including 22% VAT.
The price includes:
- participation in three workshops that are practice-oriented and include working on case studies under the guidance of an experienced instructor specializing in Microsoft Excel,
- the opportunity to ask individual questions during the workshops,
- A computer for conducting workshops in a modern, well-equipped computer lab.
Free parking nearby; coffee upon arrival.
Registration
We are accepting applications until Friday, February 27, 2026, or until all available spots are filled. Please apply using the online form at https://prijave.snipi.si/mNB7IWhoxD
Questions and Information
For more information: Jana Mlačnik, jana.mlacnik@cene-stupar.si, 031 729 908.
