No products in the cart.
Excel advanced 2 – dynamic calculations and Pivot
240 € + VAT
Time: 9-12 | 13-16 | 17-20
Duration: 3 hours
Address: Online training
Trainings are free of charge for Eduhouse customers who hold an organizational license with digital classrooms for the relevant training topic.
NOTE! As a union member, you can verify your subscription through your union's customer service.
In Excel advanced 2-training we become familiar with the most important advanced features of Excel, including dynamic calculations and Pivot.
This training includes the second part of Excel advanced. First part is its own separate training, that focuses on dynamic calculations and Pivot.
Goal
You learn how to do dynamic functions and how to do effective and visual reports with Pivot. You learn how to use dynamic references and how to produce reports and analysis with Pivot tools.
Target audience
The training is suitable for Excel users who already know the basics of Excel like how to use tables and how to calculate with different formulas.
Program version
This training is suitable for Excel 2013, 2016, 2019, and 2022 for Windows and Excel 2016 on Mac.
Content
Advanced calculating
- Format as a table in calculating.
- What does the spread of formulas to multiple cells mean? Dynamic references #, @ and UNIQUE-function.
Advanced information handling
- Rehearse of basics of databases.
- How to hide useless information? Managing your view with Grouping.
- What is Pivot? Introducing Pivot tool.
- Reportage and information analysis with Pivot.
- Grouping tools in Pivot
- How can I Pivot multiple Excel-tables or import information from outside sources to Pivot? Look in to Excels Power Pivot tool and how to build a working database.
Keywords
Excel, advanced, advance, table calculus, Calculation, Dynamic Functions, calculus, #, @, Unique, Pivot, report, Reportage, PowerPivot
| Location | Teams-meeting |
|---|---|
| Date & Time (EET) | 24.2.2026 at 13-16, 22.4.2026 at 9-12, 17.6.2026 at 13-16 |