Excel application development

We offer Excel based services combined with VBA (Visual Basic for Applications). According to business requests we also use other MS Office products like MS Word, MS Outlook and MS Access as well as databases like SQL Server and Oracle.

Since almost every business problem could be solved with above mentioned tools, they are ideal for rapid application development. If it’s not the case at least they can be used while making a prototype for the solution.

Because of its wide use, excellent analytical and presentational features MS Excel have become a de facto standard among office applications. Also it is present at almost every office desk which makes it even more attractive for application development because usually there is no need for some additional software installation. With its familiar interface, even the training needed to use MS Excel based solutions is minimized thus cutting the overall costs down.

We are ready to cooperate with companies or individuals from any business area.

If you need quality solutions to your business demands, we are here to make it happen!

In order to get an insight of the possible solutions made with Excel here are some examples:

  • Excel application development – different kinds of custom made business applications with GUI and Ribbon implemented
  • Creation of automated reports, charts, Pivot tables…
  • Dashboards (key data visualization)
  • Add-Ins – (e.g. for data collection from distributed spreadsheets that are filled with
    needed data and have to be merged, change case tool, clearing and converting
    data…)
  • Excel PowerPivot data models with analysis and reporting solutions (different data sources)
  • Modelling (controlling, finance…)
  • Automation of repetitive tasks
  • Custom Excel functions development (UDF)
  • Data manipulation on external data (obtained from SQL Server, Oracle, MS Access…)
  • MS Outlook (or Lotus Notes) in interaction with MS Excel – a tool for sending
    personalized e-mails with specific attachments to receivers (every receiver
    gets its own attachment), manipulation and collection of attachments from Inbox
    according to criteria
  • Project management – templates and tools for tracking project completion
  • Quotations and invoices generators
  • Variety of solutions (for collecting data from different locations, spreadsheet for
    calculating daily alowances…)
  • Creation of complex formulas
  • Text files manipulation and data conversion