Good refresher on lookups, match. index, pivot tables with slicer etc.
Key points for me to follow up:
- Using calculated field in pivot tables
- 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.
- 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