Examples of common formulas in lists - Microsoft Support
Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint Server Central Admin 2013, SharePoint in Microsoft 365, SharePoint Server 2010, Microsoft Lists, SharePoint in Microsoft 365 Small Business
Available number formats in Excel - Microsoft Support
Format. Description. General. The default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way you type them. However, if the cell is not wide enough to show the entire number, the General format rounds the numbers with decimals. The General number format also uses scientific (exponential ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Enable or disable ActiveX settings in Office files
Learn how to enable or disable ActiveX settings for Office files to improve security and functionality. Follow the steps for different Office versions.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
Use mail merge to send bulk email messages - Microsoft Support
To be able to send bulk email via mail merge, you must already have installed a MAPI-compatible email program such as Outlook or Gmail. The following process assumes that you already have the message you intend to send created and open in Microsoft Word.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
KB5034441: Windows Recovery Environment update for Windows 10, version ...
IMPORTANT This update is not needed and will not be offered if your Windows Recovery Environment (WinRE) meets any of the following conditions: If the WinRE recovery partition does not have sufficient free space.
Add or invite people outside your org to a chat in Microsoft Teams
With External Access for Teams, you can add or invite anyone outside of your Teams org who uses Teams, Teams for personal use, Skype (for consumers), and Skype for Business to a one-to-one chat.
Applies To: Microsoft Teams
Add or delete notifications or reminders in Outlook
In Outlook, you have the option to: Snooze or dismiss events or tasks | Turn the notifications on or off | Add reminders to events | Add reminders to tasks | Troubleshoot notifications. Snooze or dismiss an event or task. With the reminders window, you can select to snooze calendar events and tasks, join a Teams meeting, or dismiss events and tasks.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, New Outlook for Windows
Create an Outlook profile - Microsoft Support
Note: Before selecting New, consider selecting the check box for "Prompt a profile to be used."If this is enabled, you will get a prompt every time you start Outlook to pick which profile you want to open. This is helpful when you have multiple profiles and need to switch between them.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Give your PC a Fresh Start - Microsoft Support
To reset your PC, go to Start > Settings > System > Recovery .Next to Reset this PC , select Reset PC.Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No.. Open Recovery settings
Featured Visio templates and diagrams - Microsoft Support
Visio is a diagraming tool that makes it easy and intuitive to create flowcharts, diagrams, org charts, floor plans, engineering designs, and more by using modern templates with the familiar Office experience. On this page, you can access some of the top templates and sample diagrams available in Visio, or request ones that you want. To see the hundreds of templates and sample diagrams ...
Applies To: Visio Plan 2, Visio in Microsoft 365, Visio Plan 1, Visio Professional 2021, Visio Professional 2019, Visio Professional 2016