I've been covering tech for decades. These are the software tools I use for work (and occasional recreation) every day - and boy, have they changed a lot over the last few years.

The Ctrl + End shortcut deserves special mention as it instantly takes you to the last cell containing data, which is perfect for quickly assessing the size of your dataset. If Ctrl + End takes you ...

Now that the data from the workbooks has been combined and transformed, it's time to see how it looks in a regular Excel worksheet. In the Home tab on the Power Query Editor window, click the top half ...