@LiamStewart If you want to get started with PowerQuery you need to use Excel for Windows, as PQ is not fully supported by Excel for he Mac. You can connect to a workbook or a Text/CSV file and load it, but you can't do transformations. You can refresh certain queries that were created on a PC, but you can't create or edit them on a Mac. That is, not as easily as on a PC. When you Google for Power Query on the Mac, the first hit is probably this:
https://support.microsoft.com/en-us/office/import-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4f...
Scroll down a bit and you'll see a caption on Authoring and transferring queries with VBA. Once, the VBA code is in place you can go modify it. That is, if you know what you're doing. But it's definitely not the way to learn PQ. You really need a PC or run a virtual Windows machine on your Mac, e.g. with Parallels or Bootcamp. That's what I do.
A good starting point to learn more about PQ would be here:
https://exceloffthegrid.com/power-query-introduction/
