We have started our autumn training sessions!
We are starting with a dear client from Međimurje, Hilding Anders, where we’ll deliver an advanced Excel training for the logistics and production departments. The training will last a total of 16 hours, split into 2-hour sessions.
Advanced Excel is useful for all participants who work daily with large amounts of data, preparing and analyzing them, but are limited to basic formulas that often make them slower and less flexible when solving more complex tasks. That’s why the participants decided to improve their Excel skills and attend this training in the coming weeks.
What we’ll cover:
– Data entry into cells – differences and best approaches
– Real tables – how to work with them and why they are important
– Conditions and the SWITCH function – an elegant solution instead of nested IFs
– Data merging (XLOOKUP/FILTER) – why FILTER is not a complete replacement for XLOOKUP
– PivotTables and PivotCharts – powerful data analysis
– Power Query – an introduction to automated data cleaning and transformation
The training will be based on real-life examples from the client’s business to help them solve their specific cases, with a focus on data analytics.
We’re looking forward to hearing our clients’ feedback once we wrap it up!
There are still a few free slots left this autumn, so if you’re interested, get in touch with us!
