Add-on: Microsoft 365

Excel 2021 - Advanced functions

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

Expand your Excel 2021 skills: Learn how to analyze, prepare and protect data efficiently. Use complex formulas, logical links, cell formats, target value search and PivotTables. Protect and share workbooks professionally. Whether you want to deepen your existing knowledge or take the next step after a basic course - get fit for your demanding day-to-day work!

Learning objectives

  • Learn advanced functions such as nested formulas and logical functions (e.g. IF, AND, OR) for more efficiency.
  • 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 PivotTables 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
9 h 10 min
Level
Expert
Target group description
For beginners or users with little basic knowledge who want to master all the important basic functions of Excel.

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