How to GRANT permission to execute stored procedure?
in Excel when they go to Data -> Get Data -> From Database -> From SQL Server Database


That's PowerQuery. Just ran through that on Excel, and stored procedures don't appear, but Table-Valued Functions do. And you can call a stored procedure, but it won't show up in the query designer. You just enter 'exec dbo.Proc1' in the SQL Statement dialog: