Michael | search
Click here to view Michael news from 60+ newspapers.
Bookmark or Share- Create a relationship between tables in Excel - Microsoft SupportHave you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
- Find what you need with search in Microsoft 365 appsAt the top of your Microsoft 365 apps on Windows you'll find the Microsoft Search box. This powerful tool helps you quickly find what you're looking for, from text to commands to help and more. Let's take a look at what it can do for you.
- Find or replace text and numbers on a worksheetUse the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
- Calculate multiple results by using a data tableA data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. A good example of a data table employs the PMT function with different loan amounts and interest rates to calculate the affordable amount on a home mortgage loan.
- Share your Microsoft 365 Family subscription - Microsoft SupportMicrosoft 365 Family subscribers can share subscription benefits with up to five other people in their family group by sending an email or copying & sharing a link. Important: Sharing is only possible if the invitee joins the subscription owners' family group.
More
