If you ask me for example how much commission I’ve paid in a given quarter or how much profit or loss I’ve realized in a given month from the past on the Stock Exchange Market, the answer is: I don’t know. I am creating this application in order to fix this problem and be able…
1. Project Introduction: Each team from the Accounting department of a SSC had a delegated person who was responsible to manually prepare and send via email every day, for 10-15 days in a row each month, a report regarding the status of the account reconciliations for the month. There was no automation for this process…
The creation of this Excel Addin started in mid-2015 and the trigger was the need to streamline and automate general recurring and/or time consuming “manual” work in Excel. This is a project at which I work constantly by creating new features or improving the existing ones. In this post you can find examples of how…
The Overtime Tracker is an application developed in Access 2013. It was designed to store and analyze the Overtime hours submitted and compensated by the employees of one client. This app can be modified and in the real environment it is updated with more modules and features in order to satisfy multiple needs of the HR…
In this post I briefly present an application created to analyze company’s financial data and compare it with the data of main competitors. It is created in Excel 2013 and uses Excel VBA, advanced formulas and interactive charts.
A. What is the Access Web App for Tasks Management ? A Web Application which helps to manage the tasks from a company. It is developed in Access 2013 Web Apps and runs from any internet browser or even from mobile devices or tablets. It is stored on Sharepoint site. The data is structured in…
What is the Paysplip Sender ? An Excel VBA application which automatically sends the Payslips each month to all employees in Password Protected PDF file. How it works ? 1) The HR user inputs in sheet Send all employees with ID, Name, E-mail, Password for PDF file with the Payslip and the Year and Month:…
I presented some examples of Excel VBA projects on my old blog. For most of them you will find also downloadable files, detailed explications and in some cases video tutorials. Unfortunately, the old site was mainly in Romanian, but I think you will understand most of the ideas even if you don’t know the language. You can find all…