How to create a link to export one-click query or report to excel

How to create a link to export one-click query or report to excel

My customers uncomfortable when to export the report or query dashboards need to do some additional steps. How do I set up a link in one click?

It would be nice to be exported to use filters on dashboards and without filters.