Overview of formulas in Excel - Microsoft Support
Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
DATEDIF function - Microsoft Support
Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...
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, SharePoint Foundation 2010, SharePoint Server 2010, Windows SharePoint Services 3.0
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Create a document - Microsoft Support
Click a template to see a preview. Click the arrows on the side of the preview to see more templates.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Find the serial number on your Microsoft or Surface device
If you have this Surface. Find it here. Surface Laptop, any Surface Laptop Go, and Surface Laptop SE. Look under your keyboard near the hinge. Any Surface Laptop Studio. Starting in Laptop mode, gently rotate the top of the display backwards 180 degrees.
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
What do the OneDrive icons mean? - Microsoft Support
If you see a blue circle with an informational letter "i" in it over a OneDrive cloud icon in the notification area, it means there are new messages about how best to use OneDrive, or to inform you about new or unused features.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Meet Windows 11: The basics - Microsoft Support
Try it! Universal search. Select Search on the taskbar or press Windows logo key + S, then type what you want to find.You'll get personalized search results for people, email, and files in local and shared sites, or from the web. Desktop groups
My microphone isn't working in Microsoft Teams
Use your phone's audio. If your mic doesn’t work after trying the solutions above and you see one of the messages below, select Call me back to use your phone’s mic.. Enter your phone number and select Call me to receive a call from Teams that will connect you to your meeting. Your audio will come from your phone, but other content sharing will still take place on your desktop.
Applies To: Microsoft Teams
Connect a wireless display to your Windows PC - Microsoft Support
On the right side of the taskbar, select the Network icon > Cast, then select your display or wireless adapter.