Excel

Instead of manually entering in numbers, you can generate random numbers in Excel to automate the process. Excel has two built-in functions, RAND and RANDBETWEEN, which populate cells with randomly […]

Excel sheets and workbooks are usually protected to prevent unwanted changes to the document. The sheet protection feature allows people to view the sheet, but not make changes to it […]

Reading thousands of lines in an Excel spreadsheet can be an annoying process, especially when the data is unorganized. Luckily, it is very easy to sort multiple columns alphabetically in […]

Data in an Excel spreadsheet is usually unorganized, unsorted, and hard to read. There are many techniques to make the data easier to read, such as using filters and sorting […]

Many users are unaware that it is possible to add bullet points in Excel. While Excel does not provide a built-in functionality to do this, there are four workarounds that […]

To make your data easier to read, you may want to color alternate rows in Excel. Excel provides built in functionality to do this and even alternatively colors newly added […]

In Excel, quite often you will want to compare data in completely different areas of your worksheet. Instead of scrolling back and forth between these two areas, you can simply […]

In order to protect the data contained within Excel documents, a lot of people make the document read only. When trying to edit a read only Excel worksheet you will […]

Some people prefer having a dataset with blank spaces, but others absolutely detest it. Instead of manually finding and deleting each blank row, you can have Excel do the hard […]