Shortcuts and shortcuts to shortcuts

Lessons learned from thinking about shortcuts this week:

1. Breevy is an app for PCs that allows creation of shortcuts.  The more you think about it the more exciting this gets: names, email addresses, jumping to directories, whole paragraphs can all be created.
   
   I started off with a shortcut system that started with semicolons and ending with a space but have now moved to one starting with real letters and ending with double dots.  This gives me slightly longer to remember I have a shortcut for the word and gives me the option of adding an S a the end for a plural.
2. Breevy can be made to sync with Dropbox (banned at some work places) and is limited to PCs.  Text Expander is another option, works for Ipad and Macs (not tested by me) and has a beta for PCs.  This looks good for synchronisation but costs US$40 a year.
3. Ipads have settings/general/text replacement which is basic but does the trick.

Thought about backing up Windows favourites:

1. Right click favorites (in Windows Explorer)
2. Open in a new window
3. Select all with the mouse
4. Copy
5. Create a new directory in backup destination
6. Paste

Notes from podcast: Simplicity in Computing by Brett Kelly

Focus area: making messaging more efficient

Actions

Turn off Linked in notifications

Check if Spam Sieve could be added to my email system

Think about quick responses to emails - extend use of Breevy

Use text expander for iPad (like Breevy)

Use Breevy for addresses and email addresses

Start shortcuts with single dot or end with double dot

Create structure for shortcuts

Shortcuts for Evernote tags 

Email gate?  If not known sender gets them to type code

Consider out of office that says 'will not be read, pls resend when I get back if still an issue'

Things to look at one day

Sane box (mail client)

Mail mate (mail client)  - Evaluates mail and learns

Spam sieve - Works on user defined rules

Tweetbot- allows muting

TM1 refresher

Had a TM1 refresher with David Bonser, TM1 Developer.  Lots of useful tips and some good ideas about designing future slices in a way that will reduce system requirements, by hard coding semi-fixed variables.

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.