Unlicensed Product and activation errors in Office
WEBIf Office activation fails, you'll see Unlicensed Product or Non-commercial use / Unlicensed Product in the title bar of your Office apps, and most features of Office are disabled. To restore all features of Office, you'll need to fix the problem that's causing activation to fail.
PRODUCT function - Microsoft Support
WEBThe PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT (A1, A2) to multiply those two numbers together.
"This product key has already been used" error in Office
WEBIf you see the message "This product key has already been used," this means that you've already redeemed your product key and added your Office product to your Microsoft account. Don't worry, this message doesn't mean you can't install or activate Office.
Activate Office - Microsoft Support
WEBTo use Microsoft 365 on your new device, you can activate Microsoft 365 as a 1-month trial of Microsoft 365 Family. You can also buy Microsoft 365 or a non-subscription version of Office, add Microsoft 365 to an existing Microsoft 365 subscription, or enter a product key from a new product key card.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
WEBUse the table_array argument in a VLOOKUP function. Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.
Repair an Office application - Microsoft Support
WEBRight-click the Start button (lower-left corner) and select Apps and Features on the pop-up menu. Select the Microsoft Office product you want to repair and select Modify. Note: This will repair the entire Office suite even if it's just one …
About Office: What version of Office am I using? - Microsoft …
WEBUnder Product Information, you'll find your Office product name and, in some cases, the full version number. 1 - Product name, such as Microsoft 365 ProPlus or Office Home and Student. 2 - Version number, which includes version, build number, and the type of installation such as Click-to-run or Windows Store.
MMULT function - Microsoft Support
WEBThe MMULT function returns the matrix product or multiplication of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. The way you enter the formula depends on which version of …
Excel functions (by category) - Microsoft Support
WEBWorksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
Excel video training - Microsoft Support
WEBA list of Excel training, from entry level to advanced skills, plus templates and other resources.
Create conditional formulas - Microsoft Support
WEBYou can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check. value_if_true: The value to return if the condition is True.