Latest Posts

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. The following image shows an ...

Finding out the number of duplicate rows using COUNTIF formula

Say you have a column with duplicate rows. You just want to find out which rows are duplicate and how many times they are duplicated. You can find ...

How to Find, Highlight & Remove Duplicates in Excel

Sometimes you may want that you will observe which rows are duplicates in the spreadsheet. Then you can manually delete those rows. It is easy to ...

How to Find & Remove Duplicate Rows in Excel

One very common use of Excel is: it is used as a tool to clean up data. Cleaning up data means: Getting raw data into a worksheet ...

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

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 a text file and can also ...

Understanding contextual tabs in Excel Ribbon

When you will work with charts or shapes or these kinds of objects then special types of tabs will appear in Excel Ribbon Tab zone. These contextual ...

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

Using Task Panes in MS Excel

Task pane is another useful user interface in Excel. Some commands in Excel will respond automatically with task panes. For example, if you work with ...

Working with Dialog Boxes in Excel

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

How to Customize the Quick Access Toolbar in Excel

The Quick Access Toolbar is a customizable toolbar. Quick Access toolbar contains commands from different tabs. You can place the Quick Access ...

Dialog Box launcher of Excel Ribbon

Some groups may have more commands that they are showing in the Ribbon. For example, the Page Setup group of commands in the PAGE LAYOUT ribbon has ...

Types of commands on the Ribbon

If you take your mouse pointer over a Ribbon command, a pop-up box will be visible that contains the command’s name and a brief description of the ...

What is Spreadsheet in MS Excel

A spreadsheet in MS Excel is basically a worksheet that is divided into rows and columns to store data related to business inventories, income, and ...

What is Spreadsheet Software

Spreadsheet software is a computer program (e.g. Excel, Lotus) that has efficient and accurate methods to work with numbers. You can perform very ...

ExcelDemy
Logo