How to Do Linear Regression in Excel
If you have two columns of numbers and you want to know how strongly one relates to the other, linear regression is the tool for the job. It fits a …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Use VLOOKUP with Multiple Criteria in Excel
If you’ve ever tried to look up a value that depends on more than one condition, you’ve hit VLOOKUP’s biggest limitation. It only matches one lookup value against one column. …
How to Calculate Relative Frequency in Excel
If you want to know what share of your data falls into each group, relative frequency is the number you’re after. It turns raw counts into proportions, so a busy …
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 …
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 …