Using In-Cell Formulas to run SOQL queries in XL-Connector 365

XL-Connector 365 supports running SOQL queries directly as in-cell formulas. You can craft a custom query that will return either one value or multiple rows/columns and display them directly in the Excel worksheet.

The query would look as follows:

=XAPPEX.RUNQUERY(“SELECT count(id) FROM Opportunity WHERE StageName ='”&B1&”‘”)
Where cell B1 would hold the value for the Stage filter