Add-on: Microsoft 365
Excel 2021 - Advanced functions
#
Microsoft Office
#
Excel
#
Spreadsheet program
#
Calculation tools
#
Data analysis



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.
Test access
Experience the Content Collection for yourself - test it for free
See the quality of our e-learning flat rate for yourself. Test selected courses from the Content Collection directly in our learning world for 2 weeks.
- E-learning with a wide variety of formats
- Topics ranging from project management and artificial intelligence to leadership and health
- Multilingual course offerings
- Learning via a digital platform





.webp)