Excel Advanced Formulas - Apprentice Course

Master complex calculations with ease and discover new Excel possibilities!

Course duration: 8 hours
Cost: € 315.70 per participant
Apprenticeship funding: up to 75% of the course costs (max. €3,000 per apprentice and duration of the apprenticeship contract)
Number of participants: min. 6 and max. 12 people
Location: Gemini Salzburg
Date: Fixed date & on request
Target group: Apprentices from the 1st year of training – particularly suitable for: Office clerk, industrial clerk, all apprenticeships with office-related qualifications

Benefits of the course

After completing the course, participants will be able to efficiently perform complex calculations in Excel and use advanced functions effectively. With the help of ChatGPT, they will develop customized Excel formulas, automate processes, and make data-driven decisions faster and more reliably.

Course description

The "Excel – Advanced Formulas" course provides practical instruction on how to master challenging tasks with Excel. Participants learn how to analyze large amounts of data, automate recurring tasks, and minimize sources of error – ideal for everyday use.

Course content

• Introduction to advanced Excel functions
• Creation & adaptation of complex formulas and nesting
• Automation of recurring processes with logic and text functions
• Data analysis & visualization with pivot tables
• ChatGPT support for formula creation and optimization

At the end of the course...

… participants will have the knowledge to use Excel as an efficient analysis and automation tool in everyday office life – from complex reports to optimized workflows.