The following tutorial is dedicated to all Excel professionals who are looking for solutions to optimize their daily work. There are more and more data to be processed every day in relatively short period of time, and here comes for help the Visual Basic for Applications.

The ETag or Entity Tag is a part of HTTP protocol used for caching purposes. In the simplest way ETags are strings that help browser to identify and validate cache. Like almost everything the ETags can be inefficient while configured incorrectly. So let's have a closer look at them..

Each time we are creating application with some kind of menu it is nice to have the basic functionality to highlight selected menu item. There are some solutions you can find in the Internet, however each time I've tried to use one it hasn't been working perfect. So let's create our own in three steps!

There are a lot of discussions in the Internet about the sense of testing the code with private accessors. In my opinion all of the discussions coming from the wrong understanding of the topic. What is unit testing? It is a testing of units, not classes, not methods exposed by some API. The term private is supposed to be private to the consumer, not to unit tests. Let's have a look at it closer..

In this video you can find answers to the following questions: what is unit test? when to write unit tests? how to write unit tests? what is a Test Driven Development?