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

    How to Use Excel Formulas in SpotlightXL

    • Dark
    • 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?