How to Use Excel Formulas in SpotlightXL
  • 1 Minute to read
  • Dark
    Light
  • PDF

How to Use Excel Formulas in SpotlightXL

  • Dark
    Light
  • PDF

Article summary

In SpotlightXL, you can leverage familiar Excel-based 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-based 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.

Was this article helpful?