Use the built-in function `=T.TEST(array1, array2, tails, type)` for a t-test p-value
Use `tails` as `1` for one-tailed or `2` for two-tailed
Use `type` as `1`...
Select the column or columns you want to hide
Right-click the selected column header
Click Hide
To hide non-adjacent columns, hold Ctrl while selecting the column headers
To...
Use the formula `=ABS(A1-B1)/AVERAGE(A1,B1)`
Format the result cell as Percentage
If comparing a new value to an old value, use `=(B1-A1)/A1`
Format the result cell as Percentage
To...
Enable the Analysis ToolPak
Go to File
Click Options
Select Add-ins
In Manage, choose Excel Add-ins
Click Go
Check Analysis ToolPak
Click OK
Arrange your data in columns or rows
Include a label...
Enter your data in two columns: categories and counts
Sort the counts from largest to smallest
Select the data range
Go to Insert
Choose Insert Statistic Chart
Select Pareto
If...
Click anywhere inside the pivot table
Go to the PivotTable Analyze or Options tab
Select the entire pivot table
Press Delete or Backspace
To remove only the pivot...
Enter your data in two columns: categories and values
Sort the values from largest to smallest
Select the data range
Go to the Insert tab
Click Insert Statistic...
Use `=COUNTA(A:A)` to count non-empty cells in column A
Use `=COUNT(A:A)` to count cells with numbers in column A
Use `=ROWS(A1:A100)` to count the total rows...
Open Microsoft Excel
Click File
Click Open
Browse to the TXT file
Select the TXT file
Click Open
Choose Delimited or Fixed width in the Text Import Wizard
Select the correct...
Select the cell or text in the formula bar
Highlight the specific character you want to make superscript
Press Ctrl+1 to open Format Cells
Go to the...
Use the formula `=IF(logical_test, value_if_true, value_if_false)`
Example: `=IF(A1>10,"Yes","No")`
Use `=IF(A1="Yes",1,0)` for text-based conditions
Use `=IF(AND(A1>10,B1<5),"Pass","Fail")` for multiple conditions
Use `=IF(OR(A1>10,B1<5),"Pass","Fail")` if any condition can be true
Use nested IF:...
Start with the equals sign `=`
Use cell references instead of hardcoded values when possible
Combine values, operators, and functions as needed
Use arithmetic operators like `+`,...
Windows: press `Alt` + `0176` on the numeric keypad
Mac: press `Option` + `Shift` + `8`
In Excel: use `=CHAR(176)` to display the degree symbol
Copy and...
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)`...
Use `COUNTIF(range, criteria)` to count cells that meet one condition
Select the range of cells to check
Enter the condition as the criteria
Example: `=COUNTIF(A1:A10, "Apple")`
Example: `=COUNTIF(B1:B20,...
Open the Excel workbook
Go to the Review tab
Select Track Changes
Click Highlight Changes
Check Track changes while editing
Set When, Who, and Where if needed
Click OK
Save the...
Enter the values in one column
Enter the corresponding weights in another column
Multiply each value by its weight
Sum the weighted values
Sum the weights
Divide the sum...
Select the chart
Go to the Chart Design tab
Click Switch Row/Column
If needed, right-click the chart and choose Select Data
Edit the series and category axis labels...
Use a formula like `=A1-B1-C1`
Subtract a cell range with `=A1-SUM(B1:D1)`
Subtract one cell from multiple cells with `=A1-B1-C1-D1`
Use parentheses to control order, such as `=(A1-B1)-C1`
Copy...
Format the cells as Text before entering data
Precede the number with an apostrophe
Import data using the Text Import Wizard and set the column format...
Select the range of data including the column headers
Go to the Data tab
Click Sort
Choose the column you want to sort by
Select the sort order
Check...
Click any cell in the PivotTable
Select the row or column label you want to sort
Right-click the label
Choose Sort
Select Sort Largest to Smallest or Sort...
Select the cell or range of cells
Go to the Data tab
Click Text to Columns
Choose Delimited or Fixed width
Click Next
Select the delimiter or set the...
Select the cell or range of cells
Go to the Data tab
Click Text to Columns
Choose Delimited or Fixed width
Click Next
Select the separator or set the...
Click the first cell
Hold down Ctrl
Click the second cell
For adjacent cells, click and drag across both cells
On a Mac, hold down Command instead of...
