I know what you mean, Steve. My wife is, shall we say, considerably less technical than I when it comes to computers. To make things a bit easier for her (and me) I employee a password vault application (1Password in my case) that I store all of my passwords in with only a master password required to enter it. I have given that password to my best friend who lives out of state. He's agreed to help my wife with my online accounts if I pass before she does. I also primarily bank at USAA and they have a program to help spouses deal with financial matters upon the death of a veteran. One thing left to do is a will, which I should really do and soon.
I also want to ensure that my social media accounts don't outlive me very long. It was disturbing when I got a LinkedIn notification to celebrate a friend's work anniversary who had passed away more than a year ago. I don't want that to happen to my friends and family!