Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Find and remove duplicates - Microsoft Support
How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.
Use AND and OR to test a combination of conditions
This formula nests the AND function inside the OR function to search for units sold between April 1, 2011 and January 1, 2012, or any units sold by Nancy. You can see it returns True for units sold by Nancy, and also for units sold by Tim and Ed during the dates specified in the formula.
Filter for unique values or remove duplicate values
In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
BI capabilities in Excel and Office 365 - Microsoft Support
Business intelligence (BI) is essentially the set of tools and processes that people use to gather data, turn it into meaningful information, and then make better decisions. In Office 365 Enterprise, you have BI capabilities available in Excel and SharePoint Online.
INDEX function - Microsoft Support
The INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form.
Specify Organization data types with the Data Selector
Specify Organization data types with the Data Selector. To convert to a data type from your organization, Excel looks for a match between the cell values and Power BI data in the data type selected from the gallery or pane.
Explode or expand a pie chart - Microsoft Support
Quickly change a pie chart in your presentation, document, or spreadsheet. Explode the entire pie chart or just one piece. Change to a pie or bar of pie chart.
Convert text to an Organization data type - Microsoft Support
Applies To. Not only can you get data on subjects like cities, foods, stocks, geography, and more, but you can also get data types provided by your organization through Power BI. You can view data type cards to get specific info about your converted data and extract that to your workbook.
Apply data validation to cells - Microsoft Support
Use data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list. Select the cell (s) you want to create a rule for. Select Data >Data Validation. Whole Number - to restrict the cell to accept only whole numbers.
Design the layout and format of a PivotTable - Microsoft Support
To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.