Skip to content
Spreadsheet Planet
  • About
  • Excel Tips
    • Excel Functions
    • Formulas Tricks
    • Charts
  • Shortcuts
  • Excel VBA
  • Power Query
  • Calculators

Steve Scott Articles

=NOMINAL(B2,C2) in cell D2 converting Riverside Community Bank's 9.38% effective rate into a 9.00% nominal rate

How to Calculate Nominal Interest Rate in Excel

Click here to Read More »
=SORTBY(A2:D11,RANDARRAY(ROWS(A2:D11))) in cell F2, spilling the whole list back in a random order

How to Randomize a List in Excel

Click here to Read More »
Excel scatter plot showing a downward trend line with the equation y = -0.2776x + 9.2755 and R-squared value of 0.9804

How to Do Linear Regression in Excel

Click here to Read More »
VLOOKUP against the helper column returning 67000 in cell J2 for the Finance and Evening criteria in H2 and I2

How to Use VLOOKUP with Multiple Criteria in Excel

Click here to Read More »
The COUNTIFS formula in cell F2 returning 0.3 for the 0-100 bin, with 0.4, 0.2 and 0.1 filled down the column

How to Calculate Relative Frequency in Excel

Click here to Read More »
CONCATENATE in cell E2 with every cell from A2 to A11 listed one by one, separated by a literal comma and space

How to Convert a Column to a Comma-Separated List in Excel

Click here to Read More »
The finished amortization schedule with both summary figures sitting below the last payment

How to Build a Car Loan Amortization Schedule in Excel

Click here to Read More »
The Auto Fill Options button expanded, offering Fill Days, Fill Weekdays, Fill Months and Fill Years

How to Use the Fill Handle in Excel

Click here to Read More »
The formula =E2:E11<=D2:D11 in cell G2 spilling TRUE and FALSE down the Within Promise column.

Using Less Than or Equal to Operator in Excel Formula

Click here to Read More »
=NORM.S.INV(1-0.05) in cell G2 returning the one-tailed Z critical value 1.6449

How to Find Critical Value in Excel

Click here to Read More »
=B2:B11*C2:C11 typed once in cell D2 and spilling a total for every member down column D

How to Create a Multiplication Formula in Excel

Click here to Read More »
The COVARIANCE.P formula in cell H2 returning 0.000772 as AAPL's covariance with itself

How to Create a Covariance Matrix in Excel

Click here to Read More »
« Previous Page1 Page2 Page3 … Page43 Next »
spreadsheetplanet.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

2026 © spreadsheetplanet.com Privacy Policy | Sitemap | Contact Us

DMCA.com Protection Status