22 September 2016

Enhanced aspects of Excel

Attended presentation by  Kate Watson for CIMA on enhanced aspects of Excel.

Good refresher on lookups, match. index, pivot tables with slicer etc.

Key points for me to follow up:

  1. Using calculated field in pivot tables
  2. Think more about using Indirect(cell name) and in that cell have a dynamic name that refers to a range of cells.  This could be really useful for data validation where second choice is dependent on first choice.
  3. Power pivots (not covered but sounds like can be used to connect multiple data sources)
Kate said she would send out links to materials which I will link here when they arrive.

No comments:

Post a Comment