Add-on: Microsoft 365

Excel 2019 - More complex tables: Advanced calculations, simulation and monitoring

Person works with Microsoft 365Person works with Microsoft 365Person works with Microsoft 365

Excel is more than just a calculation tool: In this e-learning course, you will learn how to professionally implement complex calculations, scenarios and analyses. Whether it's what-if analyses, target value searches or monitoring windows - this training course shows you how to solve challenging tasks efficiently and transparently. Use Excel as a powerful tool for analysis and decision-making.

Learning objectives

  • You can use scenario managers to compare different assumptions and make well-founded decisions
  • You will learn how to use monitoring functions such as the monitoring window or error checking to check formulas in a targeted manner
  • You can then use complex formulas and nested functions to perform sophisticated calculations
  • You will learn how to structure and efficiently manage large tables in order to maintain an overview even in complex data analyses
  • You will then know how to use the target value search and the solver to analyze scenarios and find optimal solutions
Languages
DE
Duration
1h 35 min
Level
Expert
Target group description
For users who have mastered the basic functions and want to get to know advanced functions or expand their knowledge.

Fancy an insight into the course?

Start the interactive course demo with one click and get a first impression of this e-learning course.

Start today

Build up relevant knowledge and skills in your company with our e-learning courses.

Despite its high information content, the e-learning "Code of thanks" conveyed the topic in an easy-to-understand way and with entertaining animations.

Thorsten Eska Copy 2
Expert for success skills of the future, author, successful speaker and trainer.

Despite its high information content, the e-learning "Code of thanks" conveyed the topic in an easy-to-understand way and with entertaining animations.

Thorsten Eska
Expert for success skills of the future, author, successful speaker and trainer.

Get advice

Book an introduction
Anne Müller, Lena Kaster
and her team will be happy to advise you