Latest Posts
1

Data appropriate for a pivot table

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. Worksheet database can be in table form or just a ...

READ MORE +
0

Exporting Data in Excel

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 more. Converting Excel workbook to text format ...

READ MORE +
0

How to copy formula in Excel

How to copy formula in Excel

While you are working with Excel, you will have to copy formula frequently from one cell to other cells. Here is how you will do this: Select cell B4 and enter this formula "=RAND()". ...

READ MORE +