Modelling

  • Excel models (vlookup, lists, validations) design / optimization

  • Interactive dashboards / KPI

  • VB.Net / VBA programming

  • Data analysis (pivot tables, graphs, trends)

  • Business Intelligence (Power BI)

  • Access databases / management applications (stocks, customers, investments) design

  • Oracle SQL queries

Creating Excel input forms

We create input forms for entering data into the different tables, simulating the functioning of a database by validating inputs, with these features:
  • forms for adding / editing / deleting records
  • data tables
  • filter management
  • generating pivot tables
  • multi-user password-protected entry
  • administrator mode for direct editing in tables
  • save after each change

Price: fr. 200.- for each unit of points above

  • Input form model
  • Generating pivot tables
  • Data structure scheme

Our applications / demos