Excel shortcuts

I spent 5 years in M&A, did lots of Excel. Naturally, I learnt all the shortcuts that made me more productive. However, when I migrated to Mac none of those shortcuts worked, so I went back to using a mouse.

Recently, I changed my keyboard to one that allows you to program different layers. Basically,  you press a special "super" button and the whole layout of keys changes to whatever you want. In my case it changes from "qwerty" to "Excel" layer.

Here is one of the possible layouts:

**Top row:

1st button Format cells - 2 Toggle Filters on/off - 3 Align text to the left - 4 center - 5 to the right - 6 autofit column width

**Middle row:

1 indent left - 2 indent right - 3 cell format $ - 4 fortmat % - 5 cell format number

Also when you press 3 and 4 together it will decrease the decimal points; 4 and 5 - will increase decimal points of a number

**Bottom row:

1 font size down - 2 font size up - 3 underline - 4 italic - 5 bold - 6 paste special

This is a game changer:

- I don't need to remember complicated combinations like Alt-h-a-r -- I just press one button on my top row

- All shortcuts are logically placed (e.g. all alignment shortcuts are next to each other)

- All shortcuts are accessible with one hand

- I can program to have a shortcut activated when I tap/hold a button instead of just press; or when I press two buttons next to each other together

Highly recommended.