24 September 2016

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.

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.

02 September 2016

Process Excellence

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