ExcelDemy.com Blog

0

How to use Flash Fill in Excel 2013

Flash Fill is one of most important features newly added in Excel 2013. Flash Fill technique can recognize pattern in a text and you can separate part of a text in a new column...

0

Using Text to Columns to split text in Excel

The Text to Columns command can split the text into their component parts. First step to split data in this method is to see whether there is enough empty columns to the right to...

0

How to split text into multiple cells in Excel

When you import data from another source, it may happen that multiple values have been imported into a single column. Following image shows an example of this type of import incident. Tip: Your default...

0

COUNTIF formula in Excel

COUNTIF formula syntax: COUNTIF (range, criteria) Range is the range of cells from where you want to find your values. Criteria can be expressed in many ways. It can be number, expression, cell reference,...

0

How to Find, Highlight & Remove Duplicates in Excel

Sometimes you may want that you will observe which rows are duplicate in the spreadsheet. Then you can manually delete those rows. It is easy to mark the duplicate rows in a column. For...

0

Importing a text file in Microsoft Excel

Sometimes you may want that you will place a text file into a specific range of your worksheet. You will at first think that you have to import the text file in a new...

0

Supported file formats by Excel

Excel 2013 is backward compatible. Backward compatible means that when a new version of Excel comes in the market, this new version is compatible with the old version Excel files. Excel 2013 supports XLSX,...

0

Importing Data in Excel

If you want to do anything with data, you must at first get that data into your worksheet. Excel can import data from text file and can also retrieve data from websites. Importing from...

0

Excel is a superb tool to analyze data

Data is everywhere. Say we run ExcelDemy.com to make you master in Microsoft Excel. To run this site, we need to know who are visiting this site, from where they are, whether our site...

0

Understanding contextual tabs in Excel Ribbon

When you will work with charts or shapes or these kind of objects then special types of tabs will appear in Excel Ribbon Tab zone. These contextual tabs contain commands related to objects that...

1

Mouse Conventions

Some mouse related terms we shall use in the tutorials of Excel 2013. Mouse Pointer: When we move our mouse, a small graphic figure moves onscreen. The mouse pointer is generally an arrow but...

1

Creating and Copying formula using relative references in Excel

In our following example, we want to calculate Menu Cost(see the heading in the example) multiplying every menu’s price and quantity. We shall not create formula for every cell, we shall create formula for...

0

Controlling cell pointer after pressing Enter in Excel

By default, when you press Enter key in your keyboard, active cell will move one cell down. You can change this behavior by changing option. Go to File, then Options, then select Advanced and...