In this post you can watch and/or download a video tutorial about Microsoft’s Excel 2016 Power Query basic features. The parts of the tutorial are the following: Part 1: an overview of Power Query, the working files used in the tutorial and the final report which you learn to create in the next sessions Part 2:…
In this post I explain how to create and schedule a Python script that automatically sends every month an email to a list of persons in a specific day and hour of the month.
In this post I show you how to Import in Excel exchange rates from a webpage using VBA Internet Explorer Automation. You will also learn to use some nice formulas (date formulas, counta, indirect, text) and create a dynamic chart to represent the trend of the imported data.
Excel model used to track and report the data regarding your personal income from the companies you worked for. At the end of the post you can also download a free example and use it by replacing the dummy data with your own data.
In this post I present the best practices to find in Excel VBA the Last row, last column of a worksheet and Type Name of the current selection. See here how to do it properly
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:…