Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Import data from a folder with multiple files (Power Query) - Microsoft …
Use Power Query to combine multiple files with the same schema stored in a single folder into one table. For example, each month you want to combine budget workbooks from multiple departments, where the columns are the same, but the number of …
Combine text from two or more cells into one cell
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed.
VLOOKUP function - Microsoft Support
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.
Activate Office - Microsoft Support
Learn how to activate Office that is pre-installed on new Windows 10 PCs or using a new product key.
Apply sensitivity labels to your files and email - Microsoft Support
You can apply sensitivity labels to your files and emails to keep them compliant with your organization's information protection policies.
Use multiple tables to create a PivotTable - Microsoft Support
Use multiple tables to create a PivotTable. PivotTables are great for analyzing and reporting on your data. And when your data happens to be relational—meaning it's stored in separate tables you can bring together on common values—you can build a PivotTable. What’s different about this PivotTable?
Manage workbook links - Microsoft Support
Here's how to ensure that you are retrieving the latest values from your source workbooks. Sometimes, you need to change the source workbook, a workbook link breaks, or you may no longer need the workbook link. There is no automatic way to find all workbook links in a workbook.
Filter by using advanced criteria - Microsoft Support
Microsoft Office Excel uses the separate criteria range in the Advanced Filter dialog box as the source for the advanced criteria. The following sample data is used for all procedures in this article. The data includes four blank rows above the list range that will be used as a criteria range (A1:C4) and a list range (A6:C10).
CONCATENATE function - Microsoft Support
Use CONCATENATE, one of the text functions, to join two or more text strings into one string. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on.
Unlicensed Product and activation errors in Office
To restore all features of Office, you'll need to fix the problem that's causing activation to fail. Step 1: Sign in to Office with the right account. If Office asks you to sign in, enter the account you used to buy Office. You'll see "We couldn't find any Office products" if you use the wrong address. Try this: Sign in to Office.