Data validation in MS Excel

Working in a team can be irritating if some of the team members don’t play by the rules you all agreed when you started a project. Imagine this situation: for this team, you created some Excel templates which the other members need to fill in and return them to you,...
How to use macros in MS Excel

How to use macros in MS Excel

It happens many times that we have to accomplish boring repetitive tasks in MS Excel, such as formatting cells in lots of tables, to make them look more professional, in order to print, let’s say, a report for a client. Those tasks, although easy to do, require a lot...

How to label a CD or a DVD

I don’t know about you, but when it comes about CD/DVD writing, I have a problem: if I’m too lazy to label it immediately, it gets lost in the pile and there are 90% chances that I’ll never use it again, as most of the times I get bored of the search process before...

Cleaning products tips and tricks

Isn’t it difficult these days to choose the most appropriate cleaning products? Tips and tricks written on all kind of detergent boxes, minutes after minutes of advertising for various cleaners for all purposes, promotions and coupons… you get lost in choices, even...

The Hidden Face of Microsoft Excel

I don’t know how many Microsoft Excel users take advantage of all its features or even know such features exist. Probably very few ones. Although I have used this software a lot, for many years, I still discover new things everyday. I put together here a list of...