Select the data range, including headers
Go to the Insert tab
Click PivotTable
Choose the table or range
Select where to place the PivotTable
Click OK
In the PivotTable Fields...
Enter your data in a single column or row
Click an empty cell where you want the result
Type `=STDEV.S(range)` for a sample standard deviation
Type `=STDEV.P(range)`...
Check the status bar for a circular reference warning
Go to the Formulas tab
Click Error Checking
Select Circular References
Review the listed cell references
Click each reference to...
Go to the Formulas tab
Click Error Checking
Select Circular References
Review the listed cell address
Click each circular reference to jump to the cell
Use Trace Precedents to...
Select the cell with the drop-down list
Go to the Data tab
Click Data Validation
In the Settings tab, check the Source box
Edit the list items directly...
Right-click the sheet tab you want to duplicate
Select Move or Copy
Check the Create a copy box
Choose where to place the copied sheet
Click OK
Alternatively, hold...
Select the cell where you want the result
Type `=VLOOKUP(`
Enter the lookup value
Type a comma
Select the table array
Type a comma
Enter the column number to return
Type...
Enter your data in a single row or column
Click an empty cell where you want the result
Type `=STDEV.S(range)` for a sample standard deviation
Type `=STDEV.P(range)`...
Select the cell where you want the result to appear
Type `=VLOOKUP(`
Enter the lookup value
Type a comma
Select the table array or range to search
Type a...
Select the data range
Go to the Insert tab
Click PivotTable
Choose the table or range
Select where to place the PivotTable
Click OK
Drag fields to Rows
Drag fields to...
Use the CONCAT function: `=CONCAT(A1,B1)`
Use the TEXTJOIN function: `=TEXTJOIN(" ",TRUE,A1:B1)`
Use the ampersand operator: `=A1&B1`
Add a separator with ampersand: `=A1&" "&B1`
Fill the formula down for...
Use `=AVERAGE(range)` to calculate the average of the values in a range
Use `=AVERAGE(range1, range2)` to calculate the average of multiple ranges
Use `=AVERAGE(A1:A10)` for a...
Select the cell where you want the average to appear
Type `=AVERAGE(range)`
Replace `range` with the cells you want to average, such as `A1:A10`
Press Enter
Use `=AVERAGE(A1:A10)`...
Select the cell where you want to add a new cell
Right-click the selected cell
Click Insert
Choose Shift cells right or Shift cells down
Click OK
Select a...
