From within Excel you can fetch issues from your filters (in settings you can enable shared filters) , or you can build your own JQL queries.
Previous: https://psc-software.atlassian.net/wiki/spaces/ECSD/pages/634552333
Next: https://psc-software.atlassian.net/wiki/spaces/ECSD/pages/634290201
Feel free to tell us what topic should be covered: excelconnector@psc-software.atlassian.net