It is very frustrating to see that Microsoft Excel has appended some zeros before the number that you entered into a cell. This usually does not happen by default. You may find yourself in such a situation if the Excel…
Microsoft Excel arguably is the most popular and widely used spreadsheet program in the world. Not only is it used by people across the world, businesses both big and small, government organizations, multinational corporations, etc, all use Microsoft Excel. Excel…
There are times that you have data in separate columns in an excel spreadsheet but you would want to put those data into a single column. One of such instances is when you want to combine the first and last…
Imagine wanting to print an Excel spreadsheet with just a few rows on it. You will realize that the spreadsheet is going to print on just one side of the paper and this is because your data is not horizontally…
One of the commonest pain points that you are likely to face as a user of Microsoft Excel spreadsheets is the difficulty with printing your excel spreadsheet. Most often than not, you will like to print the spreadsheet with the…
A very common thing that you may need to do in excel is to split the data in one column in excel into multiple columns. An example of this will be being able to split a column containing the full…
One of the commonest questions I get from colleagues about the use of Microsoft Excel is how to convert a Portable Document Format (PDF) to an Excel (XLS or XLSX) format. Normally, when it comes to converting from one file…
In a spreadsheet containing a lot of data, you may find that some of the data are repeated across the spreadsheet. In such a case, you will be interested in removing the duplicate entries. If the number of entries are…