Latest Posts

What is a Pivot Table in Excel – Make a Pivot Table Manually!

What is a Pivot Table in Excel? This is the answer we shall search for in this article. I'll answer this question by making a Pivot Table from ...

Exporting Data in Excel

We shall discuss in this section about exporting data in Excel. You can convert your Excel workbook in different formats like CSV, txt, PRN, and many ...

Data clean-up techniques in Excel

Cleaning-up data in Excel covers many areas. We have covered almost every angle. Here are the links: Data clean-up techniques in Excel: Removing ...

Data clean-up techniques in Excel: Fixing trailing minus signs

Sometimes it may happen that your imported data will show as the following screenshot: Some data have minus signs at the end, trailing minus ...

Data clean-up techniques in Excel: Adding text to cells

Sometimes you may need to add text to a cell, one solution is to use a new column and use formulas. To gain a clear grasp on this topic, you have ...

Data clean-up techniques in Excel: Replacing or removing text in cells

Solution 1: Using Find and Replace Dialog box. Sometimes it is necessary to replace or remove some characters from a column of data. For example, ...

Data clean-up techniques in Excel: Filling blank cells

Sometimes you will end up with a worksheet that will look something like the one shown in the following Figure. Filling Blank Cells in Excel. ...

Data clean-up techniques in Excel: Changing vertical data to horizontal data

Sometimes after importing a file in your Excel file, the following type of data layout may generate. See the following image. Vertical data. We ...

Offset(…) Function in Excel with Examples

The syntax of OFFSET(...) Function    OFFSET( reference, rows, cols, , ) Examples of OFFSET(...) Function Example: =OFFSET(A5, 2, 2, 1, 1) ...

How to copy formula in Excel

While you are working with Excel, you will have to copy formulas frequently from one cell to another cell. Here is how you will do this: Select ...

Data clean-up techniques in Excel: Matching text in a list

You may have some data and you want to check this data against another available list. Download this file to work with us in the following ...

Data clean-up techniques in Excel: Extracting a filename from a URL

Sometimes you may have a list of URLs and you need to extract only the file name. In the following way, you can extract the file name from a URL. ...

Data Clean-up Techniques in Excel: Randomizing the Rows

Sometimes you may need to randomize the rows in a column. Say you are a teacher of a school, you have some naughty students who try to copy papers of ...

Data Clean-up Techniques in Excel: Classifying Values

This article requires that you know Data clean-up techniques in Excel: Transforming Data with Formulas Sometimes it may be necessary that you will ...

Splitting Text in Excel Using Flash Fill

The Text to Columns Wizard works very well for many types of data. But some data can't be split by this wizard. For example, you can't split data if ...

ExcelDemy
Logo