Showing posts from October, 2018

How to create a self signed SSL certificate and how to use it with your web Server.

SSL certificate is the foremost important aspect of any website. If your website is running without the SSL, the modern browsers will stop the users from entering the website. Of course, there are ways to bypass that, at your own risk. As long as your website has no commercial data exchange, sensitive user information, etc, you are still good to run a website without a proper SSL certificate. For example, a blog can run without an SSL.  Note that Google AdSense accepts websites without SSL.  But the topic of this post is about Self Signed SSL certificate. How to create one, how to use it, and where to use it.  Let us see where to use it. For any website which is used for internal purposes, it's always a good idea to use Self Signed SSL, instead of paying for a real SSL certificate. Internal I mean, within a company, team, or for personal uses, for testing purposes, etc.  Now, let us see how to create a self-signed SSL certificate.  What you need A Linux machine.  OpenSSL utility  A

Practical Text Manipulation using MID LEFT RIGHT FIND Functions in MS Excel

Text manipulation is one of the great features of MS Excel. It has a lot of built-in functions to extract desired values from a text. By using different combinations of these functions we can create a complex formula. I have listed a few practical examples which are very useful. Extracting a Door number from an address text.  8314 W. Galvin Lane West Des Moines, IA 50265 68 4th Ave. Neptune, NJ 07753 8 Oklahoma St. Ladson, SC 29456 I will use the LEFT and FIND functions to extract the Door number of an address.  =LEFT(B4,FIND(" ",B4)) Here I am using the delimiter space (" "). The formula first finds a space character which appears after the door number. Then extracts the value whatever if at the left side of the first space.  Extracting a ZIP code from an address  Generally, the ZIP code will at the end of the address. Using the RIGHT function, we can extract the ZIP code  =RIGHT(B9,5) Extracting a spe

Practical examples on MS Excel date functions

MS Excel has an amazing set of Date and Time functions. By tweaking these functions, we can create a complex and useful formula. I am trying to list down a few practical examples particularly on the Date part, which will be very useful for a moderate to advanced Excel user.  How to find the end of the month for a given date Note that  EOMONTH  will return a serial number. You have to change the format to date format.  =EOMONTH(TODAY(),0) =EOMONTH(DATE(2018,10,10),0) How to find the number of days remaining in a month This is useful for interest calculation on first and last month on any type of loan repayment schedule.  Use DAYS , EOMONTH,  and DATE functions. =DAYS(EOMONTH(TODAY(),0),DATE(2018,10,10)) Number of days remaining in this month or current month =DAYS(EOMONTH(TODAY(),0),TODAY()) Find the number of months between two dates In other words, find the date difference in terms of months. DATEDIF is one of the very useful formulas in MS Excel.