Overview of PivotTables and PivotCharts - Microsoft Support
You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
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.
Restore or reset Surface for Windows - Microsoft Support
Next to Reset this PC, select Reset PC and choose an option:. Keep my files—Reinstalls Windows 11 but keeps your personal files and any apps that came with your PC.This option removes changes you made to settings, as well as apps and drivers you installed.
Back up your folders with OneDrive - Microsoft Support
Set up PC folder backup. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help & Settings icon then Settings.). Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.)
Applies To: OneDrive for Business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Xbox Support
Xbox Support offers help for Xbox, Game Pass, and billing questions. Get advice and customer service in the Xbox Support community.
Связывание устройств Bluetooth в Windows. - Служба поддержки Майкрософт
Перед началом работы убедитесь, что ваш компьютер Windows 11 поддерживает Bluetooth. Дополнительные сведения о том, как проверка, см. в статье Устранение проблем с Bluetooth в Windows.Если вам нужна помощь по добавлению устройства без ...
Stay protected with Windows Security - Microsoft Support
Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.
Description of Microsoft System Information (Msinfo32.exe) Tool
Examples To view your System Information, type: msinfo32 To create an .nfo file in the folder C:\Temp with a name of Test.nfo, type:. msinfo32 /nfo C:\TEMP\TEST.NFO To create a .txt file in the folder C:\Temp with a name of Test.txt, type:. msinfo32 /report C:\TEMP\TEST.TXT To view System Information from a remote computer with a UNC name of BIGSERVER, type:
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones