About Power Query in Excel - Microsoft Support
With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
How to enable global and advanced logging for Microsoft Outlook
Compared to earlier versions of Microsoft Outlook, Outlook 2010 and later versions provide an easy method to enable advanced logging: through Event Tracing for Windows (ETW). When you enable ETW logging, an event trace log (.etl) file is generated. You typically use ETW logging on the Microsoft Exchange server where you have a mailbox.
Get started with Python in Excel - Microsoft Support
Python in Excel uses the custom Python function xl() to interface between Excel and Python. The xl() function accepts Excel objects like ranges, tables, queries, and names.. You can also directly type references into a Python cell with the xl() function. For example, to reference cell A1 use xl("A1") and for the range B1:C4 use xl("B1:C4").For a table with headers named MyTable, use xl ...
Applies To: Excel for Microsoft 365
Save disk space with OneDrive Files On-Demand for Windows
When you delete an online-only file from your device, you delete it from your OneDrive on all devices and online. You can restore deleted files and folders from your OneDrive recycle bin on the web for up to 30 days for items stored in OneDrive personal (when you're signed in with a Microsoft account), or for up to 93 days for items stored in OneDrive for work or school or SharePoint in ...
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive for Windows
About the Microsoft Support and Recovery Assistant
for every .etl file: *.etl and {file name of binary etl file without extension}_timber.xml, {randomGUID}-HR.txt. Outlook Expert Experience (OffCAT) FilePath. If user is authenticated. ConfigurationDetails_{CorrelationId}.json and ConfigurationDetails_{CorrelationId}.html from OffCatDataCollectionAction and API_Results.{date timestamp}.log. FilePath
Applies To: Outlook for Microsoft 365, Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Microsoft 365 admin
Microsoft security help and learning
Get security info and tips about threat prevention, detection, and troubleshooting. Including tech support scams, phishing, and malware.
"Access Denied" or other errors when you access or work with files and ...
If the Encrypt contents to secure data check box is selected, you have to have the certificate that was used to encrypt the file or folder to be able to open it. In this situation, you should obtain the certificate from the person who created or encrypted the file or folder, or have that person decrypt the file or folder.
Troubleshoot problems updating Windows - Microsoft Support
Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.
Instalar Windows 7 Service Pack 1 (SP1) - Soporte técnico de Microsoft
La forma recomendada (y más sencilla) de obtener SP1 es activar la actualización automática en Windows Update en Panel de control y esperar a que Windows 7 te avise de que SP1 está listo para instalarse.
Low Disk Space error due to a full Temp folder
To clear the Microsoft Store cache, press the Windows Logo Key + R to open the Run dialog box, then type wsreset.exe and select OK.A blank Command Prompt window will open, and after about ten seconds the window will close and the Store will open automatically.