How to Calculate EOQ (Economic Order Quantity) in Excel
If you want to find the order size that minimizes relevant annual ordering and holding costs, the EOQ formula is what you need. EOQ stands for Economic Order Quantity, and …
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 Make a Frequency Distribution Table in Excel
If you have a long column of numbers and want to see how many values fall into each range, a frequency distribution table is what you need. Staring at raw …
How to Lock Columns in Excel
If you want to keep certain columns in your spreadsheet safe from accidental edits, locking them is the way to do it. The catch is that Excel treats every cell …
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 …
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 …