Get things done faster. Impress your co-workers.

Leverage the full potential of your existing applications – using all the tools you already have available.

Loved by system administrators, PowerShell is a simple-to-grasp scripting environment that features a huge variety of pre-defined functions that allow you to automate almost any task, including data collection, data cleanup, database interactions, systems monitoring and managing complex applications like Microsoft Teams.

Introduced to Excel in 1993, Visual Basic for Applications (VBA) is still the number one choice when it comes to automating Business Processes that revolve around Excel Spreadsheets, ranging from simple macro recording to complex business logic including database access, forms and more.

I am still amazed how there are many “Excel Power Users” who have never heard of PowerQuery. It is a tool that is integrated into Microsoft Excel (and also a core component of Power BI) which allows you to automate a huge part of your daily ETL (extract, transform, load) tasks in Excel. Need to clean up that same old SAP excel export and manually transform it into the format that you require? You need to pull data from a relational database but have no knowledge of SQL? Your legacy system will only provide PDF exports? PowerQuery provides a solution for all these.

Build performant applications such as background service workers, database CRUD apps, Web APIs and more.

Excel is like having a calculator inside your computer! Wow!

Some Accountant

Latest Articles