Microsoft Excel always fascinates me with its awesome features, which help us do lots of stuff easily. If you are dealing with a lot of data and as it keeps on changing, you might come across a ...

In addition to storing typed data in each cell of a spreadsheet, Microsoft Excel allows you to perform functions on one cell and show the result in another cell. The most basic function, a link, ...

Microsoft Excel helps you sort your data for analysis by providing a Filter command. For example, when you want to sort number values from low to high, this Filter command will insert a clickable ...

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would. Conditional formatting in Microsoft Excel has been ...

Microsoft Excel PivotTables do a great job of turning data into meaningful information, but they have one flaw: You can’t easily add grand total rows. Microsoft Excel PivotTables are a great way to ...