Pass-thru | search
Click here to view Pass-thru news from 60+ newspapers.
Bookmark or Share- Digital signatures and certificates - Microsoft SupportDigital signatures and certificates. Applies To. More and more people and organizations are using digital documents instead of paper documents to conduct day-to-day transactions. By reducing dependency on paper documents, we are protecting the environment and saving the planet’s resources.
- Automatically number rows - Microsoft SupportIn an Access database, you can create a field that automatically generates a unique number when you enter a new record in a table. What do you want to do? Fill a column with a series of numbers. Use the ROW function to number rows. Display or hide the fill handle. Fill a column with a series of numbers.
- Import data from data sources (Power Query) - Microsoft SupportUse Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
- 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.
- Open file links directly in Office desktop apps - Microsoft SupportThis feature works for links to Word, Excel, or PowerPoint files, stored on OneDrive or SharePoint, that you click in Word, Excel, Outlook, or PowerPoint for Microsoft 365 on Windows or Mac. Once a user turns this feature on, it will apply to all three apps - Word, PowerPoint, and Excel.
More
