Add-on: Microsoft 365

Excel 2019 - Advanced functions

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

Expand your Excel 2019 knowledge: Learn complex formulas, logical links, cell formats and tools such as target value search. Create PivotTables and protect and share workbooks professionally.

Learning objectives

  • Learn how to use advanced functions such as nested formulas and logical functions (e.g. IF, AND, OR) efficiently.
  • You work with user-defined cell formats and names for ranges
  • You are familiar with the use of calculation tools such as target value searches and scenario managers
  • You create pivot tables for dynamic data analysis
  • You will learn how to protect and share workbooks to ensure secure and structured collaboration within the team
Languages
DE
Duration
10 h 40 min
Level
Expert
Target group description
Whether you want to deepen your existing knowledge or take the next step after a basic course - this course will make you fit for the demanding use of Excel in everyday working life.

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