Calling Microsoft Excel a mere spreadsheet falls short. Extensive information can be displayed, sorted, filtered and analysed in a structured way. As soon as numbers are involved, Excel takes care of calculations and complex computations, turning plain tables into meaningful charts and dashboards.
Our Excel courses are structured in several levels to match your level of knowledge and your goals – from a solid introduction through to advanced skills, data analysis with PowerPivot and automation with VBA. For specific requirements from controlling or statistics, we can also put together courses with specialists from these fields on request.
The courses take place as classroom training in Wangen-Brüttisellen and Lausanne, as an online live webinar, as in-house training or as one-to-one coaching. Write to us via our contact form, and we will recommend the right level for you.
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.
With PowerPivot, Business Intelligence reports that previously had to be commissioned can now be created independently. This course shows you how.
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.
