Alex Balgavy

Just some stuff about me.

Here's my dotfiles repository.

Check out my blog.

My keys: PGP, SSH

My crypto wallets (BTC, XMR)

I see you have JavaScript disabled. In GUI browsers, I have this page themed dynamically, so when it's dark outside, you'll get a dark theme. You need JS enabled if you want the dynamic theme; I don't run any JS-based analytics or tracking.

Excel notes

Cmd-t/f4: toggle absolute/relative reference

Filling data:

ctrl-d: fill down
double click bottom right corner: fill range
select cells, then pressing enter will jump you through them
select cells, then ctrl-enter to fill all with same value

Switch to R1C1 mode to see actual cell references (in settings).

Cmd-a, ctrl-a (cmd-asterisk in LibreOffice): select current region (island surrounded by whitespace)

Ctrl-semicolon to insert today’s date.

https://trello.com/b/HGITnpih/you-suck-at-excel

https://youtube.com/watch?v=0nbkaYsR94c