Posts

Showing posts from 2019

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

Image
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

Xiaomi Redmi Note 8 Pro new features

Redmi Note 8 Pro is among the most anticipated flagship phone in the last few months in India. Now that it is available and I wanted to list out some of the features that new on this device and interesting. You can connect to Wifi and enable Hotspot at the same time This is a very interesting feature. You can enable WiFi and at the same time, you can enable the hotspot. Earlier, either you could enable WiFi or enable Hotspot at the same time. That means you could use mobile data in the hotspot. Once you enable the hotspot, your WiFi would be disabled and when you enable the WiFi, your hotspot would be disabled. With this, you could only share your mobile data through the hotspot. Now you can use the WiFi data to share the internet through the hotspot. With this, you can use your mobile as a WiFi repeater, as a WiFi relay. If your WiFi router is a bit far from your TV, for example, and if the strength of the Wifi signal is weak, then you can keep your mobile phone in between these

MS word drop down control with Excel data

Image
There are lots of things you can do with MS Excel and MS word. Word and Excel can be connected easily to build sophisticated use cases. Mail merge is one of the great tool, where you can leverage the data power of excel and reporting feature of the MS Word. With a bit of VBA knowledge, you can extend the mail merge for usages. Below I explain how to use the Excel data to populate the DropDown control in the MS word. And it is dynamic, when the data in Excel got changed, the items in the drop-down will also be changed.  First, I have this sample data in Excel. I want this data to be displayed in a dropdown control in the MS Word. For this I am making use of this macro or VBA code. Private Sub ld_Click() Dim objExcel As New Excel.Application Dim objWB As Excel.Workbook Set objWB = objExcel.Workbooks.Open("C:\Users\krsanjee\Documents\krishtalk.com\book1.xlsx") 'Me.drop.RemoveItem (0) Me.drop.Clear total_rows = Cells(Rows.Count, 1).End(xlUp).

VirtualBox and Hyper V conflicts on Windows 10

Image
If you are using Windows 10 operating system and want to use virtualization on it, then you have 2 options. 1. Using Virtual Box 2. Using Hyper V This post is not about how to use them but instead, what are the issues you will encounter if you have them together. One scenario is, you have VirtualBox installed and working fine. Then you realize you want to use a docker on your Windows machine. The VirtualBox working fine until will start comparing about virtualization and acceleration. After installing the docker on your windows, all your VMs on the VirtualBox cannot start. It complains about the availability of virtualization. " The hardware virtualization is enabled in the Acceleration section of the system although it is not supported from the host system. It should be disabled in order to start the visual system " The error message not straight forward to understand. As you know virtualization is required for docker or VirtualBox to work. First thing you will do

Excel conditional formatting based on multiple cell values

Image
1. Condition on a single cell To apply conditional formatting based on the values of multiple cells. In other words, format a cell where formatting cell is different and conditional cell is different. Click on the cell where you want to apply for formatting Go to Home on the Ribbon, then select Conditional Formatting. Then select the last option, "Use a formula to select which cell to format" Now, in the formula cell write the formula for your condition =$C$6=10 2. Conditions on multiple cells What if you have to consider multiple cells for the condition? Condition cell 1: Value equal to 10 Condition cell 2: Value equal to "Krishna"  You need to build a formula with multiple conditions using AND operator. Based on your requirement, you can also use OR operator. Not just AND and OR, you can use any of the available functions in the MS Excel. The overall result should be TRUE or FALSE. It does not matter how complex your formula is, what do

How to control your Android Phone from PC | How to make a phone call from Laptop

Image
Have you ever thought of using your Laptop or in general a PC to make a call? It would be easier if there is an option available to make a call or receive a call. Yes, there is an option to use your PC to make a call. In other words, connect your mobile phone to your PC and control it. Without touching your phone you can make a call, send an SMS or transfer a file between your PC and your Mobile. You can even open a link in the Mobile browser.  There is a utility called AirDroid, using this you can connect your phone to PC. Then, from within your PC dial a number or send an SMS, etc. This is very handy if you are using the phone most frequently when you are in front of your Laptop. How to setup. On your Android mobile, download and install the Airdroid mobile app. On your PC, you have an option either install a desktop application or you can use the web application.  If you don't want to install any application on your desktop, then go to  http://web.airdroid.co

How to connect wireless Bluetooth headphones to your old TV or non smart TV

Image
Have you ever thought of making your old TV wireless audio capable? Wanted to connect your wireless headphone or a wireless speaker to your TV which does not support wireless audio streaming? You can do that with an additional device. Smart TVs have the capability to stream your TV audio onto your wireless speakers or headphones. But non-smart TVs does not support this feature. Just for the wireless purpose, you cannot change your TV, right?. Instead, make your TV wireless capable and connect any wireless audio receivers to your TV and increase your TV viewing experience. I will explain to you what are the devices you need to make your TV wireless audio capable, but before that, you should understand some terminologies. Bluetooth audio transmitters and Bluetooth audio receivers  Most of the Bluetooth wireless audio devices like Headphones, Wireless Speakers are audio receivers. They are capable of receiving the audio signals through from a transmitter and they cannot transmit b

Amazing tricks in MS Word which are less known

Image
Write Anywhere How to write anywhere in the MS word document You can only move the cursor to the location you have already visited. But what if you want to type anywhere in the document? You can do so by double-clicking your mouse left button. Once you double click, the cursor will move to that location and you can start typing. Quick calculate How to quickly calculate big numbers in MS word Think about you have a big number and you want to know the total sum or the difference of the numbers quickly. You may copy the values into excel and find a sum or difference. Or you can use your calculator to do the math. What if you have the Excel-like option within the MS word to quickly calculate the sum or difference? Yes, you have that option in the quick access menu. That’s at the top left corner. First, enable the Formula item in the quick access menu, then to find the sum select the numbers and press on the formula button. You can see the result in the status bar.

4 Amazing WhatsApp features you should know

Image
A lot of new features have been introduced in the WhatsApp recently. You may know some of them or all of them. I am listing here 4 new features that are very handy. 1. Sending messages to multiple people - Message broadcasting Earlier there was no option to send messages more than one person at a time, without creating a group. But now, WhatsApp has added this new feature where you can send a message to multiple persons. Remember, you cannot forward a message to multiple people. It has to be your own message and not the forwarded message. If you want to broadcast a forwarded message, then you can copy and send it to multiple persons Follow these steps to broadcast a message to multiple persons. On the home screen of WhatsApp, select CHATS, then click on 3 dots, which will display a menu. You will find a menu item called New Broadcast, click on it. In the next screen, you will get an option to chose the contacts to which you want to broadcast a message. Select the cont