Distribute the contents of a cell into adjacent columns
You can divide the contents of a cell and distribute the constituent parts into multiple adjacent cells. For example, if your worksheet contains a column Full Name, you can split that column into two columns—a First Name column and Last Name column. Tips:
Split text into different columns with functions - Microsoft Support
You can use the LEFT, MID, RIGHT, SEARCH, and LEN text functions to manipulate strings of text in your data. For example, you can distribute the first, middle, and last names from a single cell into three separate columns. The key to distributing name components with text functions is the position of each character within a text string.
Split text into different columns with the Convert Text to Columns ...
Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard. Try it! Select the cell or column that contains the text you want to split. Select Data > …
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.
Create a parameter query (Power Query) - Microsoft Support
Create a parameter query (Power Query) You may be quite familiar with parameter queries with their use in SQL or Microsoft Query. However Power Query parameters have key differences: 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.
Split a cell - Microsoft Support
How to split the content from one cell into two or more cells in Excel.
Text Import Wizard - Microsoft Support
As an alternative, you can import a text file by connecting to it with Power Query. Go to the Data tab > Get External Data > From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import, and the Text Import Wizard dialog will open.
Tutorial: Import Data into Excel, and Create a Data Model
These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View. The tutorials are designed to demonstrate Microsoft Business Intelligence features and capabilities in …
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Excel functions (by category) - Microsoft Support
Detect errors in formulas. Lists all Excel functions by their category, such as Logical functions or Text functions.
Use AND and OR to test a combination of conditions
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 …