Knowing how to alphabetize in Excel can be a real time-saver. Here, we look at how to alphabetize columns (and even rows) in an Excel spreadsheet.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Open a new Microsoft Excel spreadsheet by clicking the "Excel Workbook" button on the welcome screen. Create column headers to organize your data set into discrete records.

Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

Hiding lines, or rows, in Microsoft Office Excel 2010 is very simple: Right-click the lines and select "Hide." However, expanding the hidden lines in the Excel spreadsheet is not as simple. To get ...

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.