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.


Pivot Table on a Map »

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.


Clean Data with Power Query »

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.


Introduction to Solver »

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.


What-If with Data Table »

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.


Protect Formula Cells »

September 21, 2017

How can you protect only the Excel cells with formulas? This article will show you some easy ways.


Faster VLOOKUP »

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.