Excel Tips
VLOOKUP Each Alt+Entered Value »
October 2, 2017
How to do a calculation (such as VLOOKUP) for each item that has been Alt+Entered in a cell.
September 29, 2017
Display an Excel Pivot Table on a Map using the new Power Map or 3D Maps feature in Windows versions of Excel. Animate data over time using Excel. Zoom in on the neighborhood of each store location.
September 28, 2017
Power Query is a new tool from Microsoft to Extract, Transform, and Load data. Today's article is about processing all files in a folder.
September 27, 2017
Solver has been a free add-in since the days of Lotus 1-2-3
Random Walk Down Wall Street »
September 26, 2017
A simple gambling game is called Penny Pitching. Learn how Excel can model a career of penny pitching or a career of investing.
September 25, 2017
Excel What-If Analysis offers a Data Table. This is a bad name. It should be called Sensitivity Analysis. It is cool. Read about it here.
Back into an Answer with Goal Seek »
September 22, 2017
Excel What-If Analysis offers a goal seek feature. You can use Goal Seek to find the correct input values to lead to a given result. If you need to back into an answer, Goal Seek is the solution. Learn how to use Goal Seek in Excel.
September 21, 2017
How can you protect only the Excel cells with formulas? This article will show you some easy ways.
September 20, 2017
If you have a large worksheet, a lot of VLOOKUPs can begin to slow things down. Do you have a slow worksheet due to VLOOKUP? I am talking a worksheet that requires 40 seconds or 4 minutes to calculate. In today's article an amazing formula with two VLOOKUPs using the range lookup will solve the problem.