Working out my credit card statement date in Excel

This might be the most niche post I have ever done but I hope that it might prove useful to someone.

My credit card bill gets made up on or around the tenth of each month but, for reasons I won’t go into here, I needed to much more accurately predict when it was actually going to be created. Through a combination of searching and testing, I discovered that in my case it is always made up on the sixth working day of the month. Turns out that there is an Excel (and Google Sheets) function that can help with … Read the rest

Useful Excel for Mac Keyboard Shortcuts

Like so many others I am a regular Excel user but having grown up on Windows finding equivalent keyboard shortcuts for the Mac can sometimes be a pain. Specifically how to manipulate cells.

So presented here as an aide memoir for me and hopefully it will prove useful to others:

Ctrl + u – edit a cell

Cmc + Alt + Enter – new line in cell

Enter – move to next cell below

Shift + Enter – move to next cell above< … Read the rest