Create a new query that is linked to the selected Excel table or named range.
If the selected range is not part of a table or named range, it will be converted into a table.
Create a new column that contains the values in the selected column, with the first letter of each word converted into an ...
Create a new column that multiplies the values in the currently selected columns. If a single column is selected, the new ...
Create a new column which contains the numbers in the selected column raised to a specified power. If two columns are selected, ...
Create a new column which contains the numbers in the selected column, rounded to the specified number of decimal digits. ...
Create a new query that is linked to the selected Excel table or named range. If the selected range is not part of a table ...
Create a PivotTable or PivotChart to help you summarize, visualize, and explore your PowerPivot data. At least one table ...
Create a record from the table of the form Table.FromRecords({[Name = "A", Value = 1], Name = "B", Value = 2], Name = "C", ...
Create a record from the table of the form Table.FromRecords({[Name = "CustomerID", Value = 1], Name = "Name", Value = "Bob"], ...
Create a relationship between two tables in the PowerPivot window. Before you can create a relationship, at least two tables ...