Doug Harrison | search
Click here to view Doug Harrison news from 60+ newspapers.
Bookmark or Share- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportThe VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.
- Add a pie chart - Microsoft SupportPie charts can convert one column or row of spreadsheet data into a pie chart. Each slice of pie (data point) shows the size or percentage of that slice relative to the whole pie. Pie charts work best when: You have only one data series. None of the data values are zero or less than zero.
- 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.
- What is AutoSave? - Microsoft SupportAutoSave is a new feature available in Excel, Word, and PowerPoint for Microsoft 365 subscribers that saves your file automatically, every few seconds, as you work. AutoSave is enabled by default in Microsoft 365 when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online.
- Using wildcard characters in searches - Microsoft SupportUse wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern.
More
