Excel created pivot tables to improve upon its convoluted, weak reporting features (which are still available). The pivot table is actually a collection of tools that Excel uses to help you create ...

Whether you employ a single part-time consultant or a dozen full-time workers, the people who work for you are your most important -- and often your most expensive -- resources. Appraising and ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

These four overlooked Excel features completely changed how I design spreadsheets.