Excel tables

Useful article about Excel tables - including their drawbacks

Economics briefing 4 Aug 2016

Mindmap of HSBC economics briefing with Amanda Murphy, Head of UK Corporate Banking and Mark Berrisford-Smith, Head of Economics for HSBC UK Commercial Banking.

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.

Process Excellence

Mindmap from Process Excellence BPP online course 2 Sep 16.  Note there are multiple tabs, one includes into to 6 Sigma.