Having a list of values, for example city names, and want to know how many times each unique entry is repeated ? Here’s a simple solution, using built in functions. See also with pivot table Start by copying the list, and pasting it in another column. With the pasted data selected, click on menu option […]
Monthly Archives: January 2017
How to count the number of occurrences in a list with a pivot table in Excel
Having a list of values, for example city names, and want to know how many times each unique entry is repeated ? Here’s a simple solution, using a pivot table. See also with standard functions Start by selecting your list of values, and go to menu INSERT > PivotTable Make sure your selection is correct, […]
How to free storage space in Android by clearing cache
If your Android is getting slow, or throw at you an “Insufficient storage” error message when trying to install an app, here’s a quick solution to free some storage space up quickly. In short, clear the Cached data in the Storage menu. Open the Settings app on your phone, and locate the Storage menu. Wait […]
Best hotel in Brussels
Going to Brussels, and wondering how to get free reward nights as fast as possible, which loyalty program to choose, or which hotel is best for your budget to get free nights in Brussels ? You will get one free night every 8 paid nights in Hotel Ramada Brussels Woluwe with Wyndham Rewards. See the table […]
How to combine two data sets and create all possible combinations with Excel
Having two different data sets, for example a customers list and a products list, and want to combine them to get a new list with all possible combinations of customers and products ? The solution is pretty simple, feasible with MS Excel in a few minutes, and, even with thousands of entries, doesn’t require much […]
Prestashop how to create a discount / coupon / voucher code (percentage, fixed amount, …)
Creating a percentage discount code, meaning the customer enters a specific character string at the end of order process, and gets X% discount on his order, is pretty easy – and it is even a standard functionality of Prestashop, called a Cart Rule in latest 1.6 version. See more detail in Prestashop online documentation To […]
How to get faster Gold Frequent Traveler with Staralliance, or why I switched from Miles&More to Miles+Bonus
Being a frequent traveller, with silver FTL status at Miles&More for longer than 5 years, I never got to the Gold card – even though this year, I flew 122 flight segments with them. In short, to get faster to gold FTL within Staralliance, use Miles+Bonus (Aegean / Air Olympic). You will need about 18 […]
Phone frozen how to force restart it with a hard reset
Having a phone (or, most likely, smartphone) not responding, probably making noise that won’t stop until the non removable battery runs out of power ? Do not panic, there is a simple solution, which is called power cycling, hard reset, hard reboot, force reboot, depending on the source. Basically, it is equivalent to your computer’s […]