Latest Posts

Excel Pivot Table Formatting (The Ultimate Guide)

Pivot table helps you to summarize your data quickly and easily. With the help of Pivot Table, you can analyze your data perfectly. In this article, ...

Excel Pivot Table Terminology

You have to understand the terminology associated with pivot tables. It is the first step to the master Excel pivot table. See the following Figure. ...

Creating an Excel Pivot Table Manually

It is easy to use Recommended PivotTables option for creating pivot tables. But you might prefer to create a pivot table manually. Prior to Excel ...

Creating a Pivot Table Automatically

Is it a tough job to create a pivot table? If you create your pivot table with Recommended PivotTables option, it is one of the easiest jobs in ...

Data appropriate for a pivot table

A pivot table can handle data that is in the form of a rectangle. Your database can be stored in either a worksheet or an external database file. ...

8 Excel Pivot Table Examples – How to Make a PivotTable!

The PivotTable feature is perhaps the most important component in Excel. PivotTable is making one or more new tables from a given data table. The ...

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

ExcelDemy
Logo