How to Convert a Column to a Comma-Separated List in Excel
If you have a column of values in Excel and you want to turn it into a single comma-separated list, there are a few quick ways to get there. Copying …
Steve Scott
How to Build a Car Loan Amortization Schedule in Excel
If you have taken out a car loan and want to see exactly where each monthly payment goes, an amortization schedule is what you need. It splits every payment into …
How to Use the Fill Handle in Excel
If you’ve ever copied a formula into one cell and then retyped it row by row, the fill handle can do that in one drag. It’s the small square at …
Using Less Than or Equal to Operator in Excel Formula
Excel has six comparison operators, and <= is one of the handiest. It asks a simple question: is this value smaller than or the same as that one? The “or …
How to Find Critical Value in Excel
If you’re running a hypothesis test, sooner or later you need a critical value to decide whether your result is actually significant. The tricky part is that Excel has no …
How to Create a Multiplication Formula in Excel
If you want to multiply numbers in Excel, there’s no dedicated “times” button like a calculator has. Instead, you build a small formula and let Excel do the math for …
How to Create a Covariance Matrix in Excel
If you want to see how several stocks or variables move together, a single covariance figure between two of them won’t tell the whole story. You need every pair at …
INDEX MATCH with Multiple Criteria in Excel
If you want to pull a value out of a table by matching two conditions at once, a plain INDEX MATCH won’t cut it. It looks up a single criterion, …
How to Spell Check in Excel
If you want to catch typos before a spreadsheet goes out to your team or a client, Excel has a spell checker built right in. It just sits quieter than …
Count Characters in a Cell in Excel
If you want to know exactly how many characters sit inside a cell, Excel can tell you in a second, no manual counting required. The tricky part is that “characters” …
How to Calculate Average Percentage in Excel
If you have a column of percentages in Excel, getting a single average feels like it should be a quick AVERAGE and done. The catch is that a plain average …
Arrow Keys Not Working in Excel (Not Moving Between Cells) – FIXED!
If you want to move between cells with the arrow keys and Excel refuses to budge, the problem is almost never your keyboard. And this is because Excel has a …