Skip to content
Info

Excel advanced 2 – dynamic calculations and Pivot

11.12.2025 9:00 - 12:00 Teams


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



Time

11.12.2025 9:00 - 12:00

Location

Teams

Language

English

Organizer

Eduhouse

Price

Participation in this training is free of charge for YKA members. 

Registration

Please read YKA’s registration instructions (second tab) carefully before signing up.
Register for this training by 9:00 AM on December 9, 2025, through Eduhouse via the following link:
https://trainings.eduhouse.fi/en/koulutukset/excel-advanced-2-dynamic-calculations-and-pivot/

After the registration deadline, you can inquire about available spots via Eduhouse's chat or by emailing: trainings@eduhouse.fi

Questions?

Questions and feedback about the YKA–Eduhouse collaboration:
koulutukset@yka.fi

Questions about Eduhouse trainings and registrations:
trainings@eduhouse.fi

You can also use the chat feature on Eduhouse’s website!
https://trainings.eduhouse.fi/