Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...

OneDrive is your online cloud storage within Microsoft 365. It lets you store your individual work files that you don't want your colleagues to have access to unless you choose to share the files with them.

How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.

Closing recovered files. If you click Close without reviewing all recovered files, you'll see an option to view them again later. The next time you open the application you'll have the option to save or remove those autorecover files. Yes, I want to view these files later (safest option)- Select this option if you are not sure whether you need the data in the recovered versions of the files.

The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function.However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.

To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.

Microsoft Defender is a security app that helps people and families stay safer online with malware protection, web protection, real-time security notifications, and security tips.Microsoft Defender is included in a Microsoft 365 Family or Personal subscription and works on your phone (Android or iOS), PC, and Mac.

Pour obtenir de l’aide dans Outlook.com, cliquez ici ou sélectionnez Aide dans la barre de menus et entrez votre requête. Si l'auto-assistance ne résout pas votre problème, faites défiler la page jusqu'à la rubrique Avez-vous toujours besoin d'aide ? et sélectionnez Oui.. Pour nous contacter dans Outlook.com, vous devez vous connecter.

In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.