Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.

Press this key. To do this. Command + Shift + B. Show or hide the favorites bar. Command + Shift + C . Open Developer tools. Command + D. Save your current tab as a favorite. Command + Shift + D. Save all open tabs as favorites in a new folder

To do this. Press. Move to the Tell Me or Search field on the Ribbon to search for assistance or Help content.. Alt+Q, then enter the search term. Open the File page to use Backstage view.. Alt+F. Open the Home tab to use common formatting commands, paragraph styles, and the Find tool.. Alt+H. Open the Insert tab to insert tables, pictures and shapes, headers, or text boxes.

Note: The Automatically save passwords setting has been retired with Microsoft Edge version 124 and later. Instead, Edge will offer to save your passwords each time you enter new credentials in the Edge browser. All your previously autosaved passwords will continue to be available for a seamless login.

Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.

Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.

On another Windows PC or other device, connect to Wi-Fi as you normally would, and enter your Wi-Fi password when prompted. For more info about connecting to Wi-Fi, see Connect to a Wi-Fi network in Windows.

Turn your PC off completely. To shut down, select Start and then select Power > Shut down.. Sleep. Sleep uses very little power, your PC starts up faster, and you’re instantly back to where you left off.

Find operating system info in Windows 8.1 or Windows RT 8.1. To find out which version of Windows your device is running, press the Windows logo key key + R, type winver in the Open box, and then select OK.. If your device is running Windows 8.1 or Windows RT 8.1, here’s how to learn more:

In the Add-Ins dialog box, select the check boxes the add-ins that you want to use, and then click OK. If Excel displays a message that states it can't run this add-in and prompts you to install it, click Yes to install the add-ins. For more information about how to use add-ins, see Add or remove add-ins.