TODAY function - Microsoft Support
Note: If the TODAY function does not update the date when you expect it to, you might need to change the settings that control when the workbook or worksheet recalculates. On the File tab, click Options, and then in the Formulas category under Calculation options, make sure that Automatic is selected.
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
Allow messages to be sent on your behalf when sharing a folder or ...
Under Delegate Permissions, set these five options to None: Calendar, Tasks, Inbox, Contacts, and Notes.. Selecting None for each of these options gives the delegate the basic ability to send messages on your behalf, but nothing more. Grant the delegate additional permissions (such as the ability to see your inbox) by selecting Inbox, and from the dropdown select Reviewer, Author, or Editor.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
Use Excel as your calculator - Microsoft Support
Learn more about simple formulas. All formula entries begin with an equal sign (=).For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use — the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
What's the difference between the OneNote versions?
No matter where you live, work, or roam, there’s a version of Microsoft OneNote to fit your needs. Whether you’re on a PC, a Mac, in a browser, or on a mobile device, each version of OneNote lets you reliably access your cloud-connected notebooks to capture your thoughts and ideas.
Applies To: OneNote for Microsoft 365, OneNote for Microsoft 365 for Mac, OneNote for the web, OneNote 2021, OneNote 2021 for Mac, OneNote for Windows 10, OneNote 2019 for Mac, OneNote 2016, OneNote for Mac, OneNote for iOS, OneNote for Android
Manage, view, or delete SharePoint alerts - Microsoft Support
Alerts are notifications of changes to content on a site that you receive as email messages or text messages to your mobile phone, depending on how your site is configured.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013, SharePoint in Microsoft 365, SharePoint Server 2010
Customize permissions for a SharePoint list or library
Important: While SharePoint allows considerable customization of site permissions, we highly recommend using the built-in SharePoint groups for communication sites and managing team site permissions through the associated Microsoft 365 group.You can add, change, or remove permissions for an individual document or folder by following methods mentioned in Share files or folders in Microsoft 365.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, SharePoint Server 2010, Microsoft Lists, SharePoint admin center, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Group or ungroup data in a PivotTable - Microsoft Support
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2019, Excel 2016
Uninstall Office for Mac - Microsoft Support
Ctrl+click the application you selected and click Move to Trash.
Applies To: Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Microsoft 365 for Mac
Examples of query criteria - Microsoft Support
Criteria. Description >25 and <50. This criterion applies to a Number field, such as Price or UnitsInStock. It includes only those records where the Price or UnitsInStock field contains a value greater than 25 and less than 50.. DateDiff ("yyyy", [BirthDate], Date()) > 30
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016
See what's on the Start menu - Microsoft Support
Get started. To pin your favorite apps to the Start menu, select and hold (or right-click) the app you want to pin. Then select Pin to Start .. To group your apps into folders, simply drag an app on top of another with mouse or touch or highlight the app with your keyboard and use the Ctrl + Shift + <Left or Right arrow> keyboard shortcut.. Your apps and programs—right at your fingertips