How to Create a Dynamic Top 10 List in Excel
A dynamic top 10 list in Excel pulls the ten highest values out of your data and keeps itself current, so when a number changes, the ranking changes with it. …
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 Trim Spaces with Excel VBA
If names or codes you imported into Excel won’t match, sort, or look up properly, stray spaces are usually to blame, and a short VBA macro can clean them out …
How to Get a Cell Address with Excel VBA
When you’re writing a macro, you often need to know where something is, not just what it holds. Maybe you want to tell the user which cell they’re on, log …
How to Import the Current Workbook into Power Query
If your data is already sitting in the workbook you’re working in, you don’t need to connect to an outside file to get it into Power Query. You can point …
How to Use SUMIFS With Arrays in Excel
The SUMIFS function in Excel adds up values that meet every condition you give it. That’s AND logic, so the moment you want sales for Denver OR Austin, a plain …
How to Append Queries in Excel Power Query
If you have the same kind of data split across several tables, like one table per store or per month, appending them in Power Query stacks all those rows into …
How to Organize Excel Tabs Under a Master Sheet
If your Excel workbook has grown to a dozen tabs, you’ve probably wished you could tuck some of them under one main tab, the way folders work on your computer. …
How to Build an Amortization Schedule with Irregular Payments in Excel
An amortization schedule in Excel shows how each loan payment splits between interest and principal, and how fast the balance drops. That’s simple when every payment is the same, but …
How to Refresh Excel Queries Automatically
If you’ve built a Power Query in Excel, you’ve probably noticed that its loaded table doesn’t change when the source data does. It only updates when the query refreshes. By …
How to Convert Text into a Formula in Excel
If your formulas show up as text like =C2*D2 instead of a result, you need a way to make Excel treat that text as a real formula and calculate it. …
How to Calculate Percentiles with Criteria in Excel
To calculate a percentile with criteria in Excel, pick the rows that meet your conditions and pass their numbers to PERCENTILE.INC. That gives you a cutoff for the group you …
How to Calculate Distance Between Coordinates in Excel
To calculate the distance between two points in Excel, check what your coordinates measure. X and Y positions on a flat grid measure distance from an origin. Latitude and longitude …