Pablo Gallardo's Blog
My professional web log about SAP and IT
 
Archive | Microsoft Excel RSS feed for this section

INDEX and MATCH as alternative VLOOKUP in Excel

VLOOKUP is a very useful and powerful Excel formula. It has however, its limitations: for example, the searched word must be obligatory in the first column of the search matrix. This article provides an alternative to VLOOKUP. The alternative would be to use a combination of the formulas INDEX and MATCH instead. There are plenty […]

Comments { 0 }

How to create a Gantt chart in Excel 2007

Today I had to spend a several minutes just to find a proper tutorial about how to create a Gantt chart in Excel 2007 (most of them concerned only previous versions). When I found Microsoft’s official instructions, it turned out that they where incomplete and incorrect at some point. This video tutorial was the best […]

Comments { 0 }
Política de privacidad