Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

Data clean-up techniques in Excel

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 duplicate rows How to Find, Highlight & ...

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 formulas frequently from one cell to another cell. Here is how you will do this: Select cell B4 and enter this formula "=RAND()". ...

READ MORE +