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 ...

How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata Your email has been sent When a Microsoft Excel workbook contains a lot of sheets, the sheet tab you need is ...

You’re probably familiar with selection shortcuts in Microsoft Excel. There are several that select text, sentences, whole paragraphs, and so on, so it should come as no big surprise that shortcuts ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool. Tables are one of the fundamental tools in ...

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...

You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.