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.

Build multi-table data models with Power Pivot to upgrade your Excel workflow. Replace flat files and use DAX variables for ...

Microsoft Excel lets you swiftly create a variety of useful records to log sales calls, service calls and other kinds of call information you need to run your business. In just a few minutes, you can ...

Applying XLOOKUP, IF, TEXTSPLIT, and TRIM to my source data gives my PivotTable more useful fields and cleaner info to work ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...

Advanced list solutions are easy thanks to Excel’s Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

Q. I spend a substantial amount of time entering data into Excel. Do you have any suggestions on ways to make this faster and/or more efficient? A. One of the best data-entry tools to use in Excel is ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

We can create a master sheet in a Workbook and link other sheets to it, and create links to access them instantly. This gives us a lot of convenience in managing data and multiple sheets. It makes it ...