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.

In this tutorial, you'll learn how to create an interactive Excel dashboard from scratch, focusing on the richest people in ...

Now we will create the relationship between tables after naming the tables. On the Data tab, click Relationships in the Data Tools group. A Manage Relationships dialog box will open. In the Manage ...

Have you ever felt like your Excel skills hit a ceiling, no matter how many pivot tables you create? You’re not alone. While standard pivot tables are a reliable tool for summarizing data, they often ...

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager?

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather than spending hours manually copying and pasting ...

Turn Excel into a lightweight data-science tool for cleaning datasets, standardizing dates, visualizing clusters, and ...

Microsoft Excel lets you store and manipulate data for business or personal purposes. The tools within Excel give you the ability to interpret data sets, similar to the kinds of interpretation you ...

Posts from this author will be added to your daily email digest and your homepage feed. is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 ...