How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

Add or subtract dates. Insert the current date and time in a cell. Fill data automatically in worksheet cells. YEAR function. MONTH function. DAY function. TODAY function. DATEVALUE function. Date and time functions (reference)

To connect a wireless printer, follow these steps: Select Start > Settings > Bluetooth & devices > Printers & scanners . Open Printers & scanners settings. Next to Add a printer or scanner, select Add device. Wait for it to find nearby printers, then locate the one you want to use, and select Add device. If you want to remove the printer later ...

If you're moving from a Windows 7 or Windows 8.1 PC to a new Windows device, you'll find that the best way to get apps and games is through Microsoft Store. Microsoft Store is familiar on any device—you can search for free and paid apps like Adobe Reader, view their popularity and ratings, and download them to your device.

Do you need some help installing Quick Assist? For the best experience, download and install the new version of the Quick Assist app from Microsoft Store. If you have problems installing Quick Assist, here are some steps to try to get it installed and working properly.

The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER (A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").

If your computer is showing a black or blank screen in Windows, these troubleshooting tips could help get your system back up and running.

您可以 将 表格 转换为区域 中首先，或可以使用 TRANSPOSE 函数 旋转的行和列。. 选择要重新排列的数据，包括所有行或列标签，然后按 Ctrl+C。. 注意: 请确保复制数据以执行此操作，因为使用 “剪切 ”命令或 Ctrl+X 不起作用。. 在工作表中选择要粘贴转置表格的 ...

Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let's say you know the part number for an auto part, but you don't know the price. You can use the LOOKUP function to return the price in cell H2 when you enter ...

Prova de här lösningarna om du inte kan logga in på ditt Outlook.com-, Hotmail-, Live- eller MSN-e-postkonto, eller om du inte vet hur du loggar in eller loggar ut.