These reusable shortcuts handle pasting, navigation, cleanup, indexing, and timestamps from any standard Excel workbook.

We all can admit that Microsoft Excel is the best tool in its class, but there are ways to improve it with some cool and free Excel add-ins from the store. Some of these add-ins do basic things, while ...

Columns organize data in Excel, and are often used as categories with headers to sort cells. You can simply right-click on an existing column to add another column immediately before it. To add ...

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

We have created sample data containing sales of 6 different companies in four consecutive months (from January to April). The Total Sales sheet represents the total number of sales in all four months ...

Many Excel tools are optional extras, but these six are essentials I rely on in every workbook.

Microsoft Excel provides numerous mathematical functions that save time and improve accuracy in data entry. Percentage markups are used in retail, government and business environments to calculate the ...