How to delete duplicates in Excel

How to find duplicates in Excel, delete duplicate rows in Excel, and eliminate duplicates in Excel are all the same thing, with one simple function included in Excel to perform data deduplication. Below, we will also propose another solution with an Excel remove duplicates formula, which can also be used to identify duplicates in Excel and hide duplicates in Excel, without necessarily having to eliminate duplicates in Excel....
Read more

Combine columns in Excel and generate all possible combinations

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 effort – much less than copy pasting the second list for each value of the first list – this last solution would take hours with hundreds of entries. See below how to combine Excel columns and generate all possible combinations Excel....
Read more

Notepad++ randomize, sort lines random

Using Notepad++, it is very simple to randomize a list of lines, going from an organized list to a random one, as seen above. To do so, make sure you have installed Python Script plugin – if not, see Notepad++ install Python Script plugin with Plugin Manager. We will then install the RandomizeLines.py for Notepad++ from github. ...
Read more

How to compare 2 CSV files with MS Access

It may happen to end with two different tables, in which you just want to know what are the exact differences, especially when you manage a lot of data. I propose you a simple way to quickly get differences between two tables – the only difficult part is to get them in the right format ! ...
Read more

How to turn off Chrome notifications on Windows10?

The Chrome notifications can easily become annoying on Windows10. However, there is an easy way to turn them off, by going to settings > content settings > notifications > block. See below a detailed example to turn off Chrome notifications on Windows 10 - it also world to turn off FaceBook notifications on Chrome, and any other website or push notification that has been activated by mistake, or is not needed anymore....
Read more

How to add back the Notepad++ missing plugin manager?

In the latest versions of Notepad++, the plugin manager is not present by default anymore. To add it back, it is necessary to install the plugin nppPluginManager that will actually replace the plugin manager, and allow to search, install, update and delete Notepad++ plugins....
Read more

How to screen record Windows for free with PowerPoint?

That is right, you read well - if you have Microsoft PowerPoint installed on your computer, you can now screen record for free your Windows desktop, with a very good quality. If a PowerPoint presentation is on presentation mode, you can turn the PowerPoint presentation into a video, and otherwise, you can turn anything on your computer into a video, simply by having it being shown on the screen, and including registering your microphone....
Read more

How to change Windows 10 file associations?

When opening a file type in Windows Explorer, and having it opened in another program than the one you would like to, the solution is to change the Windows 10 file associations for these types of files, based on the file extension....
Read more

Microsoft OutLook weather forecast for my location

In Outlook Calendar, you can add as many weather locations as you like as your favorites, and select the one displayed. To add a location, click on the current location, and click Add Location: Enter the name of the location, or the closest main city, and click enter to get some city propositions....
Read more

LibreOffice get colors back in PDF exports

Since OpenOffice [1] moved to LibreOffice [2], direct consequence of Sun Microsystems bought by Oracle [3], some differences may have been felt, except name change. One of them, on my LibreOffice version (actually 3.3.3), had a particular impact on me : my PDF exports were systematically black and white....
Read more

MSOutlook change weather unit

The weather in Outlook calendar is displayed in the wrong unit, Celsius C° instead of Fahrenheit F°, or the inverse, Fahrenheit F° instead of Celsius C° ? It is possible to change the weather unit displayed in MSOutlook from Celsius to Fahrenheit, or from Fahrenheit to Celsius by going in menu File > Options > Calendar > select the weather unit to display....
Read more

Outlook find folder of email

Using the search tab advanced options, it is possible to find emails by content or sender, and see in which folder of the hierarchy they are located, using the Outlook advanced find tools. It is too easy to move by mistake a folder from the folder hierarchy in Outlook without noticing - and quite difficult to find it back....
Read more

Notepad++ open file in new window

As you might have noticed, Notepad++ doesn’t offer the option to open a new window, and opens all files in the same one. In order to open a new window, in which you’ll be allowed to open files / create new tabs / drag and drop opened files, simply put your cursor on the tab name of the file you want to open in a new window, click and keep the mouse button pressed, drag the mouse out of the Notepad++ window, release the mouse button – and voilà ! ...
Read more

Paste CSV into Excel

Copy pasting CSV (Comma Separated Values) is pretty easy in Microsoft Excel ! In short : use the Data > Text to Columns option. Starting with a CSV file, like the following one, open it in Excel by using the standard Excel file opening, using keyboard shortcut CTRL+O, or by opening it in Windows Explorer with right clic and selection Open with Excel 2010 / Excel 2013 / Excel 2016, depending on the version you have installed....
Read more

Forgot Windows 10 password no disk

Fingerprint blocked, PIN not working anymore, password forgotten, can't retrive the Microsoft account, and no WiFi connection ? See below a way to solve it without needing a reset disk - simply plug a phone with USB, sharing the internet connection and reset forgotten Windows 10 password !...
Read more

Bluetooth paired but not connected Windows 10

It can happen that a Bluetooth device, such as a headset, which has been previously paired and connected on a Windows installation, is suddenly unable to reconnect, ending up with a Bluetooth speaker paired but no sound. There are several possible reasons to this, and several solutions which should allow you to reconnect your device....
Read more

Windows search show full path

When performing a search in Windows explorer window, it might be interesting to see the files locations in the results. This is not displayed by default - however, there is an easy way to do it, by displaying the search as a list, and adding the full folder path in displayed columns....
Read more

Notepad++ install Python Script plugin with Plugin Manager

In order to be able to run a lot of interesting scripts (see Notepad++ randomize, sort lines random), written in Python language in Notepad++, you need to install the Python script plugin. You can either download and install it manually, or install it automatically with the Plugin Manager, that you can find in menu Plugins > Plugin Manager > Show Plugin Manager....
Read more

Windows search text in files and folders with Notepad++

One of the many useful abilities of Notepad++, is to search multiple text files for a text string and find in files and folders - including subfolder and windows hidden files and folders - and even to find and replace in notepad this search text in all files....
Read more

Batch image resizer with GIMP photo editor batch processing

In various occasions, it is useful to update in one shot a batch of photos. This operation takes a few minutes to setup using the Batch image manipulation plugin for the GIMP. It means processing as many files as you want at once, for example a batch resize will resizer thousands of files in one operation....
Read more

How to download subtitles in VLC

Since a few versions of VLC, there is now a built in option that will search for subtitles of current media file online, download the one selected, and play it with the movie, with only a few clicks. This is achieved by the VLC VLsub extension, which was previously an external plugin, but is now directly integrated in VLC media player....
Read more

Lotus Notes an error was encountered when opening a window

Do not reboot your computer ! All you have to do is to terminate the ntaskldr.exe process. This might happen when hard closing Lotus Notes, for example by terminating the process, or asking Windows to do it when the program does not answer, you might face this issue at the next Lotus Notes start....
Read more

Scribus tutorial add hyperlink to PDF

Using Scribus free software, it is possible to add a hyperlink on top of any image, and export it to PDF format. When working on a document, would it be a vectorial document, a print poster, or simply a jpeg image, it is possible to add on top of any part of the image, a link annotation, or a hyperlink, which will be displayed in an interactive PDF as a clickable area, leading to the hyperlink opening....
Read more

Notepad++ copy with formatting

The text formatting in Notepad++ can be copied to clipboard or exported using the menu Plugins > NppExport > Export to RTF or Export to HTML. Once exported, the formatted text with its syntax highlighting can be pasted in other applications, such as LibreOffice, Microsoft Word, or a WordPress post....
Read more

MS Access MDB repair tool

Even if we will all agree to say that an Access database should certainly not exist to handle more than 2GB of data, but it can happen for some reasons that you end up with such database (Fig 1). For example, when you import external data in the database, after you deleted tables in the Access file, you still have to compact and repair it in order to clean the cache, and reduce filesize....
Read more

How to record screen on Windows 10 for free

There are several ways to record screen for free on Windows 10, either using the built in Game screen recorder accessible with Windows+G, and following the on screen instructions. The other option is to install the excellent VLC media player, and use it as a free screen video recorder for Windows 10 or any other Windows version on which it is installed....
Read more