TEXTJOIN function - Microsoft Support
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
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
Where are my contacts in Windows 10? - Microsoft Support
Use the People app to see all your contacts in one place, listed alphabetically. To open the app, select the Start button, and then select People.Enter your account info if you’re asked to sign in.
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To: Microsoft Teams
Free Excel for the web templates - Microsoft Support
Tip: If you don’t like the name of the template (usually Book 1), click the name in the Excel for the web title bar at the top of the page and type a different name.
Applies To: Excel for the web
About Windows backup and sync settings - Microsoft Support
To find Sync settings, select Start , then select Settings > Accounts > Sync your settings . Choose from settings such as language preferences, passwords, and color themes. If you turn on Other Windows settings, Windows also syncs some device settings (for things like printers and mouse options), File Explorer settings, and notification preferences.
Applies To: Microsoft account dashboard
Add an exclusion to Windows Security - Microsoft Support
If you trust a file, file type, folder, or a process that Windows Security has detected as malicious, you can stop Windows Security from alerting you or blocking the program by adding the file to the exclusions list.
Diagnostic data in Microsoft 365 - Microsoft Support
Note: Diagnostic data may contain "personal data" as defined by Article 4 of the European GDPR, but it doesn't contain your name, your email address, or any content from your files.All diagnostic data Microsoft collects during the use of Microsoft 365 applications and services is pseudonymized, as defined in ISO/IEC 19944-1:2020, section 8.3.3.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, OneDrive for Business, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneDrive (work or school), Excel for iPad, Word for iPad, PowerPoint for iPad, OneNote for iOS, Excel for iPhone, Word for iPhone, PowerPoint for iPhone, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows, Visio Viewer for iPad
SUBTOTAL function - Microsoft Support
This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.. Description. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
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
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
Find and transfer Outlook data files from one computer to another
Email, calendar, contact, and task information for POP accounts. If you have a POP account, all of your information is already stored in a Personal Folders (.pst) file.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013