Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

You can reverse the row or column order of a list in Excel by creating reference list, a Macro, and using INDEX function. We have explained all these methods.

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

How to add multiple grand total rows to a PivotTable in Excel When you create a PivotTable, Excel will insert a grand total at the bottom that returns the sum of the value column.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.