Cast to a display from a Windows PC. 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.

Learn how to redeem a gift card, code, or Office product key and spend your balance at Microsoft Store online, on Windows, or Xbox.

Fix your audio drivers. Hardware problems can be caused by outdated or malfunctioning drivers. Make sure your audio driver is up to date and update it if needed. If that doesn't work, try uninstalling the audio driver (it will reinstall automatically).

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.

Between 31 and 90 days from a game’s launch date, members receive up to a 10% discount off the Microsoft Store price. After 90 days from a game’s launch date, members receive up to a 20% discount. For game DLC and add-ons, Xbox Game Pass members receive up to a 10% discount from the day the add-on is released.

Learn how to add user accounts in Windows 10 and Windows 11. With an account, each person has separate files, browser favorites, and a private desktop.

Press the Xbox button on your controller to open the guide, and then go to Profile & system > Settings > Account > Subscriptions. Select the subscription that you want to manage. From here, you can view your plan, expiration date, billing history, subscription status, and change how you pay.

Install Microsoft 365 2019 or 2016 on a PC. Remember a one-time purchase version of Microsoft 365 is licensed for one install only. Depending on your browser, select Open file (in Edge or Internet Explorer), Setup (in Chrome), or Save File (in Firefox).

Sending a friend referral. You can send a 14-day trial if you’re currently a paid Xbox Game Pass Ultimate or PC Game Pass member. Note Non-paid memberships like Game Pass trials, are not eligible for this offer.

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.