• how to use Offset in a table
    Data analysis

    How to use Offset in a table

    Need to find a value in a large table and you know only the label of the row and column where the target is located? No problem, Excel can help you do it with only two formulas: Offset and Match.…

  • SunSystems Query Tool and Custom Reports

    SunSystems Custom VBA Reports

    Are you wondering if there is some possibility to extract information from SunSystems database that allow for decisions to be taken without having to ask employees to process the data before presenting it in a standard or custom reporting template?…