XLOOKUP vs VLOOKUP in Excel
If you want to pull a value out of a table in Excel, you now have two functions for the job, and it is not obvious which one you should …
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 Calculate Average Deviation in Excel
If you want to know how far your numbers typically sit from their average, average deviation is the measure you’re after. It gives you the average distance of each value …
How to Round to the Nearest Whole Number in Excel
If you have a column of decimal numbers and you just want clean whole numbers, Excel gives you a few different ways to get there. The tricky part is that …
How to Build a Balance Sheet Formula in Excel
If you want to build a balance sheet in Excel, the whole thing rests on one simple rule: your assets have to equal your liabilities plus equity. When those two …
How to Sort by Column in Excel
If you want the rows in a table reordered based on the values in one column, sorting by column is what you need. It sounds simple, but sort the wrong …
How to Subtract Dates in Excel
If you want to subtract one date from another in Excel, you might get a date back instead of a number. And this is because Excel copies the date format …
How to Add Cells in Excel
If you want to add up the numbers sitting in a bunch of Excel cells, the tricky part is not the adding. It’s that the best way to do it …
How to Select Multiple Cells in Excel
If you want to select a bunch of cells in Excel and do something to all of them at once, dragging the mouse across them is usually the first thing …
How to Insert Multiple Rows in Excel
If you need to add ten or twenty blank rows to a sheet, inserting them one at a time is the slow way to do it. And most people get …
How to Combine Cells in Excel
If you want to pull the contents of a few cells into one cell, Excel’s Merge & Center button won’t do it. It squashes them into one big cell and …
How to Divide in Excel
If you want to divide numbers in Excel, you’ll go looking for a DIVIDE function and there isn’t one. And this is because Excel handles division with a plain forward …
How to Insert Page Breaks in Excel
If you want to control exactly where your Excel sheet splits when you print it, you can’t just hit Enter and hope for the best. Excel decides where the pages …