How to Use Excel Formulas in SpotlightXL

  • 1 minute(s) read
Prev Next

In SpotlightXL, you can leverage familiar Excel formulas to enhance your data analysis and reporting capabilities.

  1. In SpotlightXL, go to Report > Design.
  2. In the desired cell, enter the Excel formula.
  3. Click Save. Name the report Excel report.
Note:
You cannot view this report in Spotlight Web as it has an Excel formula.
IMPORTANT
You must manually enter an Excel formula for each cell. Do not copy and paste Excel formula cells as the Member Cell is not captured.