Hi wrw,
There’s a support article here that gives a good starting point: Getting started with MYOB for Excel
In short, MYOB for Excel lets you pull data from your MYOB business straight into Excel, so you can work with it there for reporting, sorting and filtering. Once the add-in is installed, you sign in with your MYOB login, choose the business you want to use, then select the data you want to bring through. It also has a refresh option, so the data can either update automatically when you open the workbook or be refreshed manually.
Regards,
Sai