The use of analysis is done mainly via the ribbon in excel. Individual features in the ribbon are enabled or disabled based on the type of data displayed and selected (Greyed out if disabled).



Description of the "Analysis" tab 

GroupIconDescription

Insert Data source : Insert a query in the selected excel cell/sheet

Refresh All

Reloads all the queries in the workbook