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.

Economic briefing 27 Jul 16 HSBC

Mind map from HSBC economics briefing 27 Jul 2016.  Key point seems to be it is still too early to interpret the post Brexit economic indicators.

Economic briefing 20 Jul 16 HSBC

Mind map of notes from webcast.

BPMN Business Process Modeling Notation

A useful summary/introduction to BPMN useful for anyone creating process maps: Lucid charts

The link is provided by Lucid Charts who provide cloud based diagram software.  It's really good for process maps and mind maps.