SUM function - Microsoft Support
How do I add or subtract Times? You can add and subtract times in a few different ways. For example, to get the difference between 8:00 AM - 12:00 PM for payroll purposes you would use: =("12:00 PM"-"8:00 AM")*24, taking the end time minus the start time.Note that Excel calculates times as a fraction of a day, so you need to multiply by 24 to get the total hours.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Customize the Quick Access Toolbar - Microsoft Support
Notes: To find an item in the Choose commands from list, it may be helpful to first confirm its location and name within the app. Commands that are no longer visible in the app could still be listed here under All commands.To help identify this type of command, a more descriptive tooltip name may appear in parentheses next to the legacy command name in this form:
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, InfoPath 2013, SharePoint Workspace 2010
Create a template - Microsoft Support
Tip: To change where your application automatically saves your templates, click File > Options > Save and type the folder and path you want to use in the Default personal templates location box. Any new templates you save will be stored in that folder, and when you click File > New > Personal, you'll see the templates in that folder.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Visio Standard 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Visio Standard 2016
Using the new Bing on the Windows taskbar - Microsoft Support
Open directly from the Search bar. If the Bing Chat icon is displaying in your Search bar on the taskbar, simply select it and Bing Chat will open in Microsoft Edge.. Open in Search Home. Here's how: Select the Search icon or the Search bar on your taskbar.
Move or copy cells, rows, and columns - Microsoft Support
You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse.. By default, Excel displays the Paste Options button. If you need to redisplay it, go to Advanced in Excel Options.For more information, see Advanced options.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 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 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Microsoft Teams (free) - Microsoft Support
Get started with Microsoft Teams (free). Explore your options, find out what’s new, browse help topics, and more.
Applies To: Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business
Help in Disk Management - Microsoft Support
Disk Management in Windows helps you perform advanced storage tasks like initializing a new drive and extending or shrinking volumes.
Insert or delete rows and columns - Microsoft Support
Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Firewall & network protection in Windows Security - Microsoft Support
Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.