Use the Data Analysis ToolPak
Go to File > Options > Add-ins
Select Excel Add-ins and click Go
Check Analysis ToolPak and click OK
Go to the Data tab
Click Data Analysis
Choose the appropriate test
Enter the input range and output options
Click OK
Read the p-value in the results table
Use the T.TEST function
Enter =T.TEST(array1,array2,tails,type)
Replace array1 and array2 with your data ranges
Set tails to 1 or 2
Set type to 1, 2, or 3
Press Enter
Read the returned p-value
Use the Z.TEST function
Enter =Z.TEST(array,x,[sigma])
Replace array with your data range
Replace x with the hypothesized value
Optionally enter sigma
Press Enter
Read the returned p-value
Use the CHISQ.TEST function
Enter =CHISQ.TEST(actual_range,expected_range)
Replace actual_range and expected_range with your data ranges
Press Enter
Read the returned p-value
Use the F.TEST function
Enter =F.TEST(array1,array2)
Replace array1 and array2 with your data ranges
Press Enter
Read the returned p-value
Use the CORREL or regression output for hypothesis tests
Run regression through Data Analysis
Check the Significance F or coefficient p-values
Read the p-values in the output table