When I first started to work with MS Dynamics NAV, I needed to understand some of the most important concepts related to Dimensions: what’s the difference between global dimensions, shortcut dimensions, default dimensions, what are default dimensions priorities, what are dimension set entries etc ? I couldn’t find an article on the internet that demonstrates all these concepts starting with…
DetailsAs 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…
DetailsThere 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…
Details
