Calling Excel “just” a spreadsheet program is almost cheeky. In our courses we show you what both tables and calculations have to offer. Large amounts of information can be presented, sorted, filtered and analysed in a structured, tabular form. If your data contains numbers, use Excel to calculate results or carry out complex calculations. Don’t just create tables – put the data to use again! Charts, dashboards and much more: simply more than just a list.
Our courses are organised into different levels so that they match your goals as closely as possible. For specific requirements (statistics, controlling, etc.) we are also happy to organise courses with experts from these fields, so that participants and trainers speak the same technical language.
Participants will be able to create spreadsheets with Microsoft Excel for calculations and as a basis for planning. In addition, they will gain knowledge of working with charts in order to present calculations effectively.
You become familiar with advanced functions, e.g. names and conditional formatting, database functions and advanced filters, complex analyses using pivot tables and arrays. You learn how to analyse and visualise your data quickly and professionally.
In this Excel VBA course for versions 2013, 2016 or 2019, you get to know and master the VBA programming language. With VBA you can automate Excel, so that recurring processes run error-free within seconds with a single call instead of several individual commands. With this language you can communicate with Excel. Among other things, you learn about variables, loops and dialog boxes. Special attention is given to error handling and error prevention.
