Create a Venn diagram - Microsoft Support
You can create a SmartArt graphic that uses a Venn diagram layout in Excel, Outlook, PowerPoint, and Word. Venn diagrams are ideal for illustrating the similarities and differences between several different groups or concepts. Overview of Venn diagrams. A Venn diagram uses overlapping circles to illustrate the similarities, differences, and ...
Create a parameter query (Power Query) - Microsoft Support
Parameters can be used in any query step. In addition to functioning as a data filter, parameters can be used to specify such things as a file path or a server name. Parameters don’t prompt for input. Instead, you can quickly change their value using Power Query.
Use AND and OR to test a combination of conditions
Applies To. When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's an example:
Add a custom column (Power Query) - Microsoft Support
You can add a custom column to your current query by creating a formula. Power Query validates the formula syntax in the same way as the Query Editing dialog box. For more information about the Power Query Formula Language, see Create Power Query formulas.
Create Power Query formulas in Excel - Microsoft Support
The Power Query Formula Language provides a wide variety of formulas that are used to build complex expressions. Power Query formulas can be written or modified in the Query Editor, by using the formula bar.
Create and manage Sheet Views in Excel - Microsoft Support
Use Sheet Views in Excel to create custom views that won't interrupt others. For instance, you can sort a table by a certain criteria, and others will still see the full table. Or sort a table in a particular way, but everyone else will see it the way it was originally.
Import or export text (.txt or .csv) files - Microsoft Support
There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down …
Overview of formulas in Excel - Microsoft Support
If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro. Formulas in-depth.
Command-line switches for Microsoft Office products
This article describes how to do both. It also includes a table that lists all of the switches and parameters that are available in the desktop Office apps. About commands, switches, and parameters. Startup command names and locations. Use a switch once by adding it to the Run command. Make a switch available for reuse by creating a shortcut.
Python in Excel DataFrames - Microsoft Support
Python in Excel can output a DataFrame in two ways: as a Python object or converted to Excel values. When a DataFrame is returned as a Python object, the cell displays the text “DataFrame”, preceded by a card icon. The following screenshot shows a …
Insert data from picture - Microsoft Support
With the Data from Picture feature, you can insert data from a screen clipping on your clipboard, an image file from your computer, or from your iPhone camera. Capture your data from an image. There are three methods: Avoid images that depict data from an angle - the perspective should be head-on and focused.