Knowledge Sharing

Excel: How to Case Sensitive Vlookup formula
By default, vlookup function is non case sensitive. What if we need to do a case sensitive vlookup operation. For example, let us use the following table   As you can see, the values in column A can be repeated but with...
How to unprotect Excel sheet without password
If you prefer to watch the complete steps in a video, then visit this youtube link: https://youtu.be/eSTUQk1t1dI Below are the steps to unlock any Excel sheet if you forgot the password If your file is .xls then save it as .xlsx...
Installing Primavera on SQL Server
How to install Primavera P6 Stand-alone on SQL database server. By Default, Primavera will install Oracle database.This article shows in details how to install Primavera P6 on SQL server 2012.The same concept should apply to any other versions.    Installation...
VBA Outlook: Insert Picture Signature Without Displaying Email
Insert Picture Signature Without Email Display I have been searching the internet for a VBA code to insert my picture signature to my email and found many posts stating that to insert a picture signature you will have to display the email...