Get geographic location data - Microsoft Support
To insert geographic data into Excel, you first convert text into the Geography data type. Then you can use another column to extract certain details relative to that data type, like Total …
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
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. For VLOOKUP, …
Create a Map chart in Excel - Microsoft Support
You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, …
Add, remove, or change a trusted location in Microsoft Office
You should use a trusted location to store a file when you don't want that file to be checked by the Trust Center, or if you don't want it to open in Protected View. Especially files with macros, …
Block or unblock external content in Office documents
To help protect your security and privacy, Microsoft Office is configured by default to block external content—such as images, linked media, hyperlinks, and data connections—in …
Excel is blocking untrusted XLL add-ins by default
There are a few different ways to do it, depending on your situation. In most cases you can unblock an XLL by modifying the properties of the file as follows: Open Windows File Explorer …
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 …
Group or ungroup data in a PivotTable - Microsoft Support
Create a PivotTable to analyze worksheet data. In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.
Use slicers to filter data - Microsoft Support
You can use a slicer to filter data in a table or PivotTable with ease. A slicer will be created for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter …
Create a PivotTable to analyze worksheet data - Microsoft Support
To add a field to your PivotTable, select the field name checkbox in the PivotTables Fields pane. To move a field from one area to another, drag the field to the target area. If you add new data …
Collaborate on Excel workbooks at the same time with co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of …