Calculate the difference between two times - Microsoft Support
A. B. 1. Start time. End time. 2. 6/9/2007 10:35 AM. 6/9/2007 3:30 PM. 3. Formula. Description (Result) 4 =B2-A2. Hours between two times (4). You must manually apply the custom format "h" to the cell.
Applies To: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, Excel 2016
Change the spaces between text - Microsoft Support
Kerning refers to the way spacing between two specific characters is adjusted. The idea is to give a better looking result by reducing the spacing between characters that fit together nicely (such as "A" and "V") and increasing the spacing between characters that don't. Select the text that you want to change.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Word 2024, Outlook 2024, Word 2021, Outlook 2021, Word 2019, Outlook 2019, Word 2016, Outlook 2016
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
What is: Multifactor Authentication - Microsoft Support
A factor in authentication is a way of confirming your identity when you try to sign in. For example, a password is one kind of factor, it's a thing you know.
Overview of PivotTables and PivotCharts - Microsoft Support
For instance, you shouldn't mix currency values and dates in the same column. Additionally, there shouldn't be any blank rows or columns within the data range. Excel tables Excel tables are already in list format and are good candidates for PivotTable source data. When you refresh the PivotTable, new and updated data from the Excel table is ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2021, Excel 2019, Excel 2016
Obtain a digital certificate and create a digital signature
About digital signatures and certificates in Office, and buying a digital certificate from a certificate authority or create your own.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Word 2024, Word 2021, Word 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Office 2013
Set up dual monitors on Windows - Microsoft Support
If you don't see the monitors, select Multiple displays , then Detect. Use the dropdown list next to the image of your desktop to choose how your screen will project across your displays. Once you've chosen your setup, select Apply .
Create an organization chart in Office by using SmartArt
Create an organization chart using SmartArt graphics. Although you cannot automatically connect two top-level boxes with a line in the organization chart layouts, such as Organization Chart, you can imitate this look by adding a box to the top level to your SmartArt graphic and then drawing a line to connect the boxes.(On the Insert tab, in the Illustrations group, select Shape, select a line ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2024, Outlook 2024, PowerPoint 2024, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016
Choose language settings for your keyboard, websites, and apps
If you don't see the keyboard you want, you may have to add a new language to get additional options. If this is the case, go on to step 4. Return to the Language settings page, and select Add a language. Choose the language you want to use from the list, and then select Next.
Add or manage an iCloud email account in Outlook - Microsoft Support
If two-factor authentication isn't set up, you should be able to use your regular password. Enter your password and select Connect. However, if two-factor authentication is set up, you'll need to generate an app-password. Follow the steps in the section Outlook won't accept my password.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows