Basic tasks in Excel. Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas.

=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. This argument can be a cell reference, or a fixed value such as "smith" or 21,000. The second argument is the range of cells, C2-:E7, in which to search ...

Where can I find my BitLocker recovery key? BitLocker likely ensured that a recovery key was safely backed up prior to activating protection. There are several places that your recovery key may be, depending on the choice that was made when activating BitLocker:

Here’s the list for the new Microsoft Edge and Microsoft Edge for Mac. Windows Mac. Press this key. To do this. Ctrl + Shift + B. Show or hide the favorites bar. Alt + Shift + B. Set focus on the first item in the favorites bar. Ctrl + D.

Closing recovered files. If you click Close without reviewing all recovered files, you'll see an option to view them again later. The next time you open the application you'll have the option to save or remove those autorecover files. Yes, I want to view these files later (safest option)- Select this option if you are not sure whether you need the data in the recovered versions of the files.

Find your files in Windows 11 using one of these methods. Search from the taskbar: Type the name of a document (or a keyword from it) into the search box on the taskbar. You'll see results for documents across your PC and OneDrive. To filter your search, you can select the Documents tab—and then your search results will only show documents.

Select Start and open the Surface app. Open the Surface app. Tip: If you can't find the Surface app on your Surface, you might need to install it from the Microsoft Store. Get the Surface app. Select Battery & charging and from the Smart charging section, select Charge to 100%. Smart charging will be paused and allow a full battery charge until ...

Taskbar icon. Apps. Check your version of Teams. For Microsoft Teams (free), select Settings and more > Settings > About Teams , then look under Version to see if you have the latest version or need to Update now. For Microsoft Teams (work or school), select Settings and more > About, then look under Version.

PowerPoint 2021 for Windows lets you create compelling content with the addition of features including co-authoring, Ink Replay, improved slide show recording, new stock media from the Office Premium Creative Content collection and new Draw tab additions such as Point Eraser, Ruler, and Lasso. If you're upgrading to PowerPoint 2021 for Windows ...

Sign in to Office.com and go to OneDrive. Select My Files. Choose where you want to upload a file or folder. Select Upload > Files or Folders. Find what you want to upload and select Open . Or, you can select files or folders on your computer and drag them into the OneDrive web browser window.