Excel Hire Test version1

As you might noticed, Excel is one of my passions, so I always thought about creating an Excel Hire test that would test the knowledge of candidates about the most important Excel concepts. So here it is ūüôā What covers this test ? Lookup Functions: vlookup, index and match Basic Reference Function: offset Basic Date…

Details

How to implement trial period or protection for your Excel Add-ins or workbooks using Excel VBA

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…

Details

An example of how to use Excel VBA Dictionary of arrays data structure

In 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…

Details

Excel Formula and VBA solution to dynamically extract the file name from website paths

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…

Details