Category: Advance Excel

Learn how to add VLOOKUP formulas in different rows and columns, using excel 2013 it’s most important function for creating different reporting and dashboard of project plan. Search for specific information in your spreadsheet. For example, if you have a list… Read More

Check out how you can change color in table using alternate highlight technique and apply formula? In given pictures you can seen “new formatting rules” so read it before apply in any table. In 2nd image you can seen conditional… Read More