In this article I present a model for monitoring the time spent at office by employees, check-ins and check-outs. I used Excel array formulas (max, min, small) with multiple conditions and also other formulas.
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.
In this post I present 5 examples of C# simple exercises with strings. Try to solve them by yourself and if you miss something, you have also one possible solution.
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…
The part 2 of the post which shows how to create a simple application with Windows Forms interface and SQL Server Database
This post explains how you can automatically install and activate an Excel Addin using VBA code. At the end you can also download the installation file.
A very easy tutorial about how to create in Visual Studio and SQL Server a simple application
Excel model which can help accountants analyze the aging of Accounts Receivable and calculate the Allowance for Doubtful Accounts and the Bad Debt Expense