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.

There are several ways to multiply numbers. Multiply numbers in a cell. To do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50. Multiply a column of numbers by a constant number.

In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)

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.

Hotmail is now Outlook.com. Learn how to sign in to access your Outlook.com, Hotmail, Live, or MSN email account.

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.

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.

You can view and clear your Microsoft Edge browsing history stored on a single device, across all synced devices, and in the cloud. You may choose to clear your browsing history at any time. Clear browsing data stored on your device.

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).

Open a service request in the Microsoft 365 admin center. This service is free. 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.