Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel. Spreadsheets’ greatest ...

How can I use Benford’s Law in Excel? A. Benford’s Law is a powerful tool in the accounting and auditing profession. It is ...

Plotting the frequency of data falling within numeric ranges illustrates the diversity of your data. As an example, a teacher might wish to calculate and display her students' grades by tabulating the ...

Get faster reports with Copilot in Excel, from smart insights and visuals to Python in Excel Premium, plus prompts, review ...

We are often reminded in press and analyst reports that more data has been created in the last year than in all previous years combined. Such articles often are written in a giddy tone based on the ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

How to return the top or bottom n records without a filter or PivotTable in Excel Your email has been sent Returning the top or bottom n records of a data set in Excel isn’t difficult, and there are ...

Data matters to every business. So it follows that every business needs a data strategy. As a strategic business and technology advisor, not only have I written the book on data strategy (literally), ...