Add-on: Microsoft 365

Excel 2016 - Advanced functions

Microsoft Office

Excel

Calculation tools

Formulas

PivotTables

Expand your Excel knowledge: Learn complex formulas, logical links, PivotTables and tools such as target value search. Protect and share workbooks for professional use.

Learning objectives

You will get to know advanced functions that will make your daily work even more efficient and professional
You work with user-defined cell formats and names for ranges
You will learn: the use of calculation tools such as target value search and scenario manager
You are familiar with protecting and sharing workbooks in order to ensure secure and structured collaboration within the team

Languages

Duration

8 h 55 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.

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