Create a flow chart with SmartArt - Microsoft Support
A SmartArt Style is a combination of various effects, such as line style, bevel, or 3-D, that you can apply to the boxes in your SmartArt graphic to create a unique and professionally designed look. Click the SmartArt graphic whose SmartArt Style you want to change.
Create an organization chart in Office by using SmartArt
Use a SmartArt graphic to create an organization chart in Excel, Outlook, PowerPoint, or Word to show the reporting relationships in an organization, such as department managers and non-management employees.
Create a treemap chart in Office - Microsoft Support
Use the Treemap chart, introduced in Office 2016 for Windows to quickly see a hierarchial representation of your data. Treemap charts are often used to quickly identify patterns in lots of data points.
Create a diagram in Excel with the Visio Data Visualizer add-in
Create stunning, high-quality diagrams with the Visio Data Visualizer add-in for Excel with a Microsoft 365 work or school account. You can create basic flowcharts, cross-functional flowcharts, and organizational charts. The diagrams are drawn automatically from data in …
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.
Edit titles or data labels in a chart - Microsoft Support
In PivotChart reports, the following procedures reestablish links between data labels and source data (not worksheet cells). On a chart, click the chart or axis title that you want to link to a corresponding worksheet cell. On the worksheet, click in …
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, counties or postal codes. Note: This feature is available if you have a Microsoft 365 subscription.
Parse text as JSON or XML (Power Query) - Microsoft Support
Deconstruct the contents of a column with text strings that contain JavaScript Object Notation (JSON) or Extensible Markup Language (XML).
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 …
Import XML data - Microsoft Support
To control the behavior of XML data (such as data binding, format, and layout), click Properties, which displays the XML Map properties dialog box. For example, existing data in a mapped range will be overwritten when you import data by default, but you can change this.
Create a SmartArt graphic from scratch - Microsoft Support
A SmartArt Style is a combination of various effects, such as line style, bevel, or 3-D, that you can apply to the shapes in your SmartArt graphic to create a unique and professionally designed look. Click your SmartArt graphic.