Excel is great! I only do the most simple things with it.
BTW, you need a subscription to read WSJ.
All pasty white guys like me.
I like Excel and Word. Excel is extremely useful in a wide variety of ways. I used to like Outlook, but they only let us use the Web version now. I dislike it intensely.
I often export values from one thing that have to be imported into something else, and the data exported is missing values that must be present for the import. You can select each cell with a value and drag it down until another value is populated, which is okay if you have ten or twenty rows. But if you have 10,000 or 100,000, it is a maddening task which can take a looooong time and is prone to error.
One of the most useful tricks I ever learned is, if you have a columns sorted in a particular way, and all the values in a column should all have the same value (as it is sorted) but only the first line in each group has a value and all the rest are blanks...
In this example below which was exported from something, we have all the Conference Rooms in a facility, the person responsible for them, and the color code area the room is in.
We have all the rooms, but because of how we extracted them from some system, they are missing either the name of the person responsible or the color coding. But you know Rooms 1-100 are covered by Smith, and are in the Blue zone, 101-200 are covered by Jones in the Gold zone, etc.
To populate some other system, you need to have EVERY cell in every row populated or the import will fail (or be useless if it succeeds)
You can select the entire column(s) with the missing values (that have one at the top of each grouping or maybe some randomly intermixed). Then, from the Find& Select menu, you choose Go To Special.
When the dialogue comes up, you select Blanks from the choices.
When you can see the blank cells highlighted, type the = sign, then type the up arrow on your keyboard, and then finally, hit CTRL-Enter. It fills in all the blanks with the value above it, so you have everything populated on every row.
Then, you have to select the ENTIRE row(s) (in this example, rows B and C) copy them, then Paste Special (values) to overwrite the cells with formulas in them. If you don't do this, your cells will be formulas instead of text or number values.
Over the years, I have saved so much time with this one thing, I thought I would share it. Of course, I recognize this may be known by nearly everyone who has to use Excel seriously, but...until someone told me, I didn't know about it...:)