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.

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)

You can manage all of your Microsoft subscriptions in your Microsoft account dashboard. Select each subscription to change when and how you pay, or to see order history & receipts. Choose your account type.

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.

Check the Xbox services, games, and apps for any service outages.

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

After your organization signs up for Microsoft 365, the admin can assign different Microsoft 365 licenses to each user account. The different licenses include different services, such as SharePoint in Microsoft 365 and Skype for Business Online. See the different Office 365 for business plans.

If your purchase of Office or Microsoft 365 came with a product key, you enter your product key on one of the websites listed below for your product. After you enter your key, you can download and install Office, or you can renew your Microsoft 365 subscription. Tip: Get tech expertise with Business Assist.

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.

However, you may need to choose an encoding standard when you open or save a file in these situations: Sharing text files with people working in other languages. Downloading text files across the Internet. Sharing text files with other computer systems.