Knowledge Sharing
by Paracon Consultants
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...
by Paracon Consultants
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...
by Paracon Consultants
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...
by Paracon Consultants
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...