Screen mirroring and projecting to your PC or wireless display
You can wirelessly connect your PC to a TV, projector, or other kind of external display that supports Miracast. Turn on your TV, projector, or other display. If you're using a Miracast dongle or adapter, make sure it's plugged in to the display.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. 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.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Sign in to SharePoint - Microsoft Support
SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint.
Applies To:
SharePoint in Microsoft 365
Use Game Bar to capture game clips and screenshots on Windows
While you’re playing a game, press the Windows logo key + G to open Game Bar. Choose Widget Menu > Capture. Choose Start recording, Take screenshot, or Record last…. Record last… turns the most recent moments of play into a game clip when background recording is turned on.
SharePoint にサインインする - Microsoft サポート
SharePoint にサインインする. SharePointは、次のように、Web ブラウザーを介して接続するブラウザー ベースのアプリです。. [office.com] に移動し、職場または学校アカウントにサインインします。. ウィンドウの左上隅で、 [ すべての アプリ] > > アプリ起動ツール ...
Applies To:
SharePoint in Microsoft 365
Receive Remote Assistance Support from Microsoft
Remote Assistance Support from Microsoft allows a Microsoft support professional in another location to view your computer screen and work on your computer over a secured connection. Protect yourself from tech support scams. Before clicking 'I accept', review the: Agreement for Microsoft Services. Microsoft Software License Terms.
Get to know Game Bar on Windows | Xbox Support
Xbox Chat (13) and Xbox Social (14) – Start a text or voice chat, one on one or in a group. Connect with friends or make new ones and join a friend’s PC game or invite them to join yours. For more info, go to: Use Game Bar to play and chat with friends.
Which version of Windows operating system am I running?
Find operating system info in Windows 11. To find out which version of Windows your device is running, press the Windows logo key + R, type winver in the Open box, and then select OK. Here’s how to learn more: Select Start > Settings > System > About . Open About settings.
Create a named range from selected cells in a worksheet
You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column labels. Click Formulas > Create from Selection.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
VLOOKUP function - Microsoft Support
Look up values with VLOOKUP, INDEX, or MATCH. HLOOKUP function. Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
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