ExcelDemy.com Blog

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

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...

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...

0

Using task panes in Excel

Task pane is another useful user interface in Excel. Some commands in Excel will response automatically with task panes. For example, if you work with a picture, and right click the image and choose...

0

Working with Dialog Boxes in Excel

Some groups of commands may have more commands that they are showing in the Ribbon. For example, PAGE LAYOUT tab’s Page Setup group of commands has more commands than it is showing in the...

0

Undo Redo commands in Quick Access Toolbar

Undo command is located on the Quick Access toolbar. You can use this command to delete your recent actions you have done in Excel worksheet. If you have done an error when you were...