There might be situations when you would like to set a trial period for your Excel applications: maybe you want to prevent employees take the applications and use them forever in other places after they leave your company or you simply need to provide to a client a trial that can be tested only a limited…
DetailsIn this post I will demonstrate how to use Dictionaries in Excel VBA in order to calculate, store and use data summarized on different criteria. In the real life I used the algorithm from this post to automate the issue of inter-company invoices. This automation saved dozens of hours considering that before they had it, users where issuing…
DetailsWhat 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…
DetailsYou 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…
DetailsIn 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:…
Details
