Excel is incredibly powerful when your data is complete, but what happens when you need to solve for unknown variables? Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy ...

This is my simple way to use the VLOOKUP function in Excel to find data fast. I walk through how I use VLOOKUP to look up inventory amounts from a table. This helps me quickly check how many items we ...