Of all the Excel tools, the PivotTable provides the most effective way to analyze your company’s general ledger data because it enables you to slice, dice, drill, group, analyze, compare, chart, and ...

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

How to combine Excel VLOOKUP() and PivotTable for simple solutions Your email has been sent Combining features often extends the flexibility and efficiency of your solution. Many solutions require ...

You can alphabetize data in an Excel spreadsheet in a few different ways. Shutterstock It’s easy to alphabetize data in a Microsoft Excel spreadsheet by row or column using the “Sort” feature.

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.