You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

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.

A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate budget data from different departments in your organization.

How cloud gaming works on your device or console. See how to get set up for cloud gaming. Tips. More ways to play. Now you can play Xbox games with the Xbox app on a smart TV. No console required! Manage your Xbox subscription. Game Pass Ultimate or a supported free to play game is required for cloud gaming.

From the Overview page, select Office apps and on that page, find the Microsoft 365 product you want to install and select Install. To install Microsoft 365 in a different language, or to install the 64-bit version, use the dropdown to find more options.

If you already redeemed a product key, you're simply reinstalling the apps, or you know you have an assigned license through work or school, you can skip ahead and go to the section sign in to download and install Microsoft 365 or Office.

PC Health Check app brings you up to date info on your Windows device health, helping you take action to improve your device performance and troubleshoot performance problems.

Many tools and options in Microsoft Edge are available when you select Settings and more . If you don’t see the options you need, select Settings from there. You can change settings like your browser home page or search engine, clear browsing history and cookies, or sync your info across devices.

Open a service request in the Microsoft 365 admin center. This service is free. Microsoft Store support. Get help and support, whether you're shopping now or need help with a past purchase. Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.

If you’re working on a Windows PC and want the apps and content from another device to show on your PC screen, you’ll want to consider mirroring that device‘s screen or projecting it to your PC. Note that you’ll need a device that supports Miracast. Here’s how to mirror another screen or project to your PC. Windows 11 Windows 10.