How to create a pivot table in Excel

If you deal with data, then you probably use spreadsheets. Microsoft Excel is a widely popular spreadsheet software, and there’s a good chance that you use it. You can do a lot with Excel; moreover, repositories like Excel Template provide very useful templates to improve your productivity. Excel also provides many powerful tools. One such tool that can help you to analyse data is “Pivot table”. How can you create a pivot table in Excel? Read on to find out....
Read more

10 MS Excel productivity tips from experts

The Microsoft Office spreadsheet software MS Excel is widely used for a large range of applications, from keeping a list of items up to date to generating invoices or even playing video games. However, in daily business use, lot of basic users are not even aware of very useful Excel productivity tip that could save them lot of time and energy, for example to count number of occurences in a list of thousands of entries, or for more simple operations such as find the position of a character in a string and other operations....
Read more

Google notepad online: 2 solutions to organize your work

Notepad softwares are getting a lot of downloads recently. But, if you do not want to mess your computer, you may prefer to use an online notepad. Right now, a big part of the population is starting working from home due to latest changes in work habits. Those workers do not have the same environment at home compared to their office. Your personal computer probably does not have as much space as your professional one....
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

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

How to count number of cells and count characters in a cell in Excel?

MS Excel is a good tool for organizational and accounting things and it can be used at any level. It doesn't require a lot of experience, because the tool is making everything seem easy. You can use it for your personal need too, with powerful functions such as advanced Vlookup in Excel, find the position of a character in a string, or also count number of occurences of a string in a file....
Read more

How to properly use Excel String Compare function?

Using MS Excel as an everyday solution, can make your life much easier. It doesn't matter where you work, the way that Excel works, it will get you out of trouble, with plenty of useful simple functions to count number of occurrences, find the position of a character in a string, count digits in cell or count characters in cell for example....
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 compare two files in Notepad++?

It often happens, when you have to work with a lot of data, to need to know differences between two sets of text data. A simple solution to know quickly if data set look alike or not, or to have an overview of different lines, is to use Notepad++ text editor as a text file compare tool with an extra plugin, that can be easily installed from the Plugin Manager. It even works to compare two XML files!...
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

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 solve Bluetooth paired but not connected on 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

How to change Outlook calendar weather to Celsius?

How to change Outlook weather to Celsius or change weather to Fahrhenheit? By default, the MS Outlook calendar is displayed in Fahrenheit or in Celsius. The weather unit can be changed, see below how to change weather to Fahrenheit in Outlook, or how to change Outlook calendar weather to Celsius. See also how to change Outlook calendar location after you had change Outlook calendar to Celsius weather unit....
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

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

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

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