Turn your data into insights. List of all Excel functions available. VLOOKUP function. IF function. Create a drop-down list. Combine text from two or more cells. Freeze panes to lock rows & columns. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable.

Select Start > Settings > Apps > Default apps. To change the default app, you can do either of the following: Set a default for a file type or link type. In the search bar, enter the file type or link type you want, then select it from the list of results. You can choose which app can open that file or link type. Set defaults for applications.

In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.

If you are using a mouse, select Start > Settings > Accessibility > Magnifier.Select View, and then open the Keep the mouse pointer or Keep the text cursor drop-down menu, and select how Magnifier behaves when the mouse pointer or text cursor move around the screen. This is something you should experiment with to see which combination works best for you.

The macro settings are not changed for all your Microsoft 365 apps. Select the File tab and choose Options. Select Trust Center, and then choose Trust Center Settings. In the Trust Center, select Macro Settings. Tip: If you have the developer tab on your ribbon, select the Developer tab and then choose Macro Security to open the Trust Center ...

On your taskbar, select the Network, Volume, Battery icon > VPN. From the list of VPN connection names, select the one you want, and then select Connect. If prompted, enter your username and password or other sign in info. Connect to a VPN from the Windows Settings page: Select Start > Settings > Network & internet > VPN .

First, try checking your hardware. Try using a different USB port on your PC. If you use a USB hub between the device and the PC, make sure the hub has power. If it’s still not working, try removing the USB hub and plugging the device directly into a USB port on the PC. Make sure that the cables on your device aren't damaged in any way.

Add flair to your email with emojis. Windows 10 and 11 contain a large set of emojis. To insert one: Put your cursor where you want the emoji. Hold Windows key + . (period) to open the Windows Emoji picker. Select a symbol to insert it in your email message. When you're done, select × to close the emoji picker.

In Windows 11, select Start, type control panel, then select Control Panel > Network and Internet > Network and Sharing Center . Select Set up a new connection or network. Select Set up a new network, then choose Next. The wizard will walk you through creating a network name and a security key. If your router supports it, the wizard will ...

Add or remove an automation add-in. Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them. Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Some other ...