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 …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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 …
How to Move Columns in Excel
If you want to move a column in Excel so it sits somewhere else in your table, you cannot just drag it across and drop it. A plain drag lands …
How to Check If a Cell Contains Text in Excel?
If you want to do something when a cell contains a certain word, you cannot just use =IF(C2=”urgent”,”Rush”,”Standard”). And this is because that test asks whether the cell IS urgent, …
How to Highlight Duplicates in Excel
If you want to spot the repeated entries in an Excel sheet, coloring them in is the fastest way to see what you’re dealing with. But Excel’s built-in rule compares …
How to Lock a Row in Excel
If you want to lock a row in Excel, the first thing to work out is which kind of locking you actually mean. The phrase covers three completely different jobs, …
Calculate Growing Annuity in Excel
A growing annuity is a series of payments made at regular intervals, each payment increasing at a fixed rate over time. Excel doesn’t have a built-in function for calculating a …
Calculate CHI-SQUARE in Excel
Chi-Square measures how far observed values differ from expected values. It tells you whether the difference is real or just a random chance. In Excel, you can calculate the Chi-Square …
Excel Filter Not Working – How to Fix?
When Excel’s filter stops working, you may find that filter buttons are missing, the criteria don’t apply correctly, or Excel only filters part of your data. In this tutorial, I …
How to Generate Random Dates in Excel
You might need to generate random dates between two dates in Excel, for example, when creating a sample set of transaction dates to test formulas. I will show you how …