Add-on: Microsoft 365

Excel 2019 - Advanced functions

Microsoft Office

Excel

Calculation tools

Spreadsheet program

Data analysis

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

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.

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.

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