Filter by using advanced criteria - Microsoft Support
Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Настройка параметров питания и спящий режим в Windows
Чтобы настроить параметры питания и спящий режим в Windows 10, перейдите в Начните и выберите Параметры > Системные > Power & спящий режим. В разделе Экран выберите период ожидания перед выключением экрана, если устройство не ...
CONCATENATE function - Microsoft Support
Problem. Description. Quotation marks appear in result string. Use commas to separate adjoining text items. For example: Excel will display =CONCATENATE("Hello ""World") as Hello"World with an extra quote mark because a comma between the text arguments was omitted.
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
Customize the taskbar notification area - Microsoft Support
The notification area is located at the right end of the taskbar. It contains icons you might find yourself selecting or pressing pretty often: battery, Wi-Fi, volume, Clock and Calendar, and action center.
Activar Windows - Soporte técnico de Microsoft
Si estás instalando Windows en un nuevo dispositivo o placa base por primera vez y no tienes una clave de producto, selecciona No tengo una clave de producto durante las pantallas de instalación. Cuando se le solicite, escriba la cuenta de Microsoft que desea usar para comprar una licencia digital para este dispositivo.
Change mouse settings - Microsoft Support
To speed up the process of selecting a choice when a dialog box appears, under Snap To, select the Automatically move pointer to the default button in a dialog box check box.(Not all programs support this setting. In some programs, you'll need to move the mouse pointer to the button you want to click.)
Calculate the difference between two times - Microsoft Support
On the Home tab, in the Number group, click the arrow next to the General box, and then click More Number Formats.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Present your data in a Gantt chart in Excel - Microsoft Support
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Устранение проблем со звуком в Windows
Затем щелкните стрелку справа от ползунка громкости динамиков, чтобы открыть список аудиоустройств, подключенных к компьютеру. Подсказка должна отображаться как Управление звуковыми устройствами при наведении ...
Delete files or folders in OneDrive - Microsoft Support
Open the Shared view, and select the files or folders you want to remove by pointing to each item and clicking the circle check box that appears.. To remove an item shared by other users, select the item, then select Remove from shared list on the bar at the top of the page.. To remove an item from Shared by me, select the item, select Information in the upper-right corner to open the Details ...
Applies To: OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows