What was the problem: In finance-accounting area some companies consider workdays as below: WD-5: the last fifth working day from the previous month … WD-1: the last working day from the previos month WD1: the first working day from the month WD2: the second working day from the month … How can we create an algorithm…
You have an Excel file with thousands of rows like in the below image and for each row you need to extract the file name: How would you do this ? Solution: One formula that can solve your problem is this one: =RIGHT(A3,LEN(A3)-FIND(“$”,SUBSTITUTE(A3,”/”,”$”,LEN(A3)-LEN(SUBSTITUTE(A3,”/”,””))))) Let’s explain how it works: The file name is the sub-string after the…
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.