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.

Would you like to make your Excel spreadsheet and data management smoother, more efficient, and less error-prone? Excel tables have transformed data management, offering a wide range of features that ...

Many Excel tools are optional extras, but these six are essentials I rely on in every workbook.

Power Query replaces risky and time-consuming manual edits with a safe, user-friendly system that speeds up everyday ...

One way businesses can save time and money is using Excel spreadsheets as data tables in which to store customer information, inventory details or other important data. Excel has several features that ...

Microsoft’s updated spreadsheet tool isn’t getting a lot of new, whiz-bang features, but it is becoming more functional. That’s something both new and experienced users will enjoy—especially a new ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...

Microsoft Excel has great tools to help you in getting important data easily without any research. You can get almost any data in Excel directly with just some functions. The less-used data function ...

Microsoft recently added a new optical character recognition feature to Excel that lets users import data from a photograph taken from a smartphone. Here's how to use it. I first started using ...