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.
DetailsIn 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.
DetailsExcel 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.
DetailsIn 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
DetailsIn 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.
Details
