Excel Tips
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.
Replaced Nested IF with VLOOKUP »
September 19, 2017
Do you have an Excel formula that nests multiple IF functions? When you get to the point with too many nested IF statements, you need to see if the whole thing would become simpler with a simple VLOOKUP function. I've seen 1000-character formulas be simplified to a 30-character VLOOKUP formula. It is easy to maintain when you have to add new values later.
September 18, 2017
Excel's VLOOKUP - can it return a value to the left of the key field? Can you specify a negative value for the third argument? Learn some alternatives in today's article.