Add-on: Microsoft 365

Excel 2021 - Analyzing data: data tables and PivotTables

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

Expand your skills: Learn how to evaluate, prepare and protect data efficiently. Discover tools such as complex formulas, logical links, cell formats and the target value search. Create PivotTables for flexible analyses and protect and share workbooks professionally.

Learning objectives

  • You can professionally create, sort and filter data tables in Excel
  • You can analyze your data flexibly with the help of PivotTables
  • You know how to customize fields, filters and layouts in PivotTables
  • You are ready to answer typical analysis questions with just a few clicks
  • You know how to present your results clearly and convincingly
Languages
DE
Duration
1 h 35 min
Level
Advanced
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