Application, Entertainment, IPTV

7 ways to watch Live IP TV from across the world

  • Updated many of the download links. Working Links available now (9th April 2020)

In the recent past, we have seen a lot of developments in the online TV industry. Because of the high speed and affordable internet services, the online TV industry seems to have a bright future ahead. Online TV somewhat narrows the gap of geographic location. There are many Online TV applications/Websites available today to pick from. However, if you are looking for some decent application/Websites to watch Online TV channels, Movies or programs across different genres then you must continue reading the below post below.

Table of Contents:

1 – THOPTV [update: Thoptv is no longer available and is permanently shutdown]

ThopTV is one of the best IPTV free apps for Android users, this app provides lots of IPTV of television channels. It is a simple to use android application supported on any android device running version 4.2 and higher.

THOP TV is the one-stop destination for all your movies and shows cravings. This android app lets you browse any shows from thousands of TV channels from around the world. Along with the TV shows, it also brings many movies of almost all genres. These movies are free and you do not have to pay anything to the developers. Earlier it was available on the Play Store and could be easily be downloaded from there. But due to some issues with terms and conditions on account of which it was removed from there. The users love it for ease and accessibility.

The look and feel is simple. There is no registration required to use the service and it is free service as of today. Just install and start using the application.

Some of the notable features are:

  • Watch TV from almost 5000 channels.
  • Listen to music from at least 5000 radio channels.
  • It has a collection of more than 3000 movies.
  • Has the ability to choose the audio language and subtitle accessibility.
  • It supports Fire TV, Amazon Fire TV stick, Smart TV, etc.

Follow below instruction to install APK file of ThopTV:

  • Download the APK of THOPTV
  • If the device says “You are not authorized to install App from Unknown Sources” then go to Settings followed by Security, then turn on Unknown Sources. 
  • Go to the folder where is you have stored it or Download Manager if you have and click on APK file or visit File Manager and click on APK section and click on ThopTV APK.
  • Click on Continue Installing button
  • Now click on the Install button
  • Now app installing wait for few seconds
  • Now ThopTV installed, click Done or Open to launch

ThopTV has a PC 64 bit version as well.

PC 64 Bit Windows Version:

Windows 8 and 10 Click Here

Windows 7 Click Here

Direct Download Links:

Android Version: Click Here

MAC Version: Click Here

2 – OREO TV [update: OreoTv is no longer available and is permanently shutdown]

Oreotv app is another nice application that can be used on android device 5.0 and above. It works with almost all android device including firetv. The look and feel is simple and you have options to streme channels at different bandwidth.

Orea TV has lots of good features, we are highlighting here some features:

  • This app contains more than 6000 TV channels.
  • Orea TV covers all Asian channels especially from India, Pakistan, Bangladesh. This app also has channels from the United State and Canada.
  • The complete package of Jio TV and Airtel TV.
  • You get categories like Sports, News, Movies, entertainment, Kids, etc.
  • This app also has a trending section on which you get live sports or shows.
  • This app also supports Download media content, you can download Movies and TV shows easily.
  • This app has an inbuilt player that supports multi video formats.
  • The simple user interface has this amazing app you can use it easily.
  • No need to register or subscribe to Oreo TV.
  • Orea TV compatible with all Android devices such as Android Smartphone, Android TV Box, Amazon Firestick, Fire TV, NVIDIA Shield.

Oreo TV is supported in all Android supported devices, if you have Smart TV but non-android you need Firestick to install it on your TV

You can download OreoTV apk file here

What devices does it work on?

Oreo TV compatible with all Android devices such as:

  1. Android Smartphone
  2. Android TV Box
  3. Android Smart TV
  4. Firestick / FireTV
  5. NVIDIA Shield
  6. Ruko
  7. Kodi Android Box
  8. Android Smart Watch
  9. Fire Cube.

This is one of the best IPTV streaming apps now, we here written all information about this app just download and install it. This app is made for Asian people this app is amazing. I hope you like it, just download & install the app on your smartphone.

3 – YuppTV

YuppTV is one of the world’s largest internet-based TV and On-demand service provider for South Asian content, offering more than 250+ TV channels, 5000+ Movies and 100+ TV Shows in 14 languages. YuppTV has 25000 hours of entertainment content cataloged in its library, while nearly 2500 hours of new on-demand content is added to the YuppTV platform every day. Making the best use of technology growth and advancement, YuppTV enables its consumers to experience the convenience of virtual home entertainment anytime, anywhere, through multiple screens – Connected TVs, Internet STBs, Smart Blu-ray Player, PCs, Smart Phones and Tablets.

YuppTV offers Live TV and Catch-Up TV technology. It also offers YuppFlix, a movie on demand streaming service for Expat Market and recently launched YuppTV Originals to bring forth unconventional story telling in collaboration with the top talent from the movie industry. More info about YuppTV can be obtained from

Some of the popular channels on this platform includes: ABP News, AAj Tak, NDTV India, B4U Movies, B4U Music, Star Plus, Gemini TV, Maa TV, Star Vijay, Sun TV, Asia Net, Star Jalsha, Sony Max, Zee TV, Colors, &TV and many more.

4 – Airtel Xstream

Another one recommended in the list is Airtel Xstream. Erstwhile known as Airtel Digital TV, Xstream has launched its web version that contains Popular Web Series, Movies, TV Shows, Live TV and many more. For those of you who are not aware, Airtel Xstream already has a popular mobile app that can be downloaded from Playstore or appstore.

Airtel Xstream is the only entertainment service you ever need. You can watch 10000+ movies, TV Shows, 350+ Live TV channels and more using this service . You can watch Live TV, TV Shows, Movies and catch up on missed Live TV shows on the Airtel Xstream app. The Airtel Xstream Website is an attempt to provide the same service on the web so that you can access it from your browser on any device. The website is still undergoing development, and so it may take a little longer for all content on the app to be available on the website. Airtel Xstream promises to bring you enhanced streaming experience, powerful UI and lots of different features.

Anyone who has an Airtel connection (Postpaid, Broadband, DTH, Prepaid) has access to Airtel Xstream. Airtel Xstream is free for its mobile customer. To access the web version of Airtel Xstream, you need to go to following link: Once you are on this page, it will ask you for Airtel mobile number. An OTP will be sent to your mobile number for verification. Once verified, you will be able to access entire list of content including Live TV Channels. Some of the popular channels include Sony, Zee, Sports and News. Must give a try and let me know if this works for you.

Airtel Xstream Premium subscription includes access to the entire catalogue of the latest TV shows, movies, videos, Live TV and catch up TV. Content titles which have the premium tag can be watched only by premium users. Eligibility: 1. Airtel Prepaid users who are active on bundle recharges including and above of Rs 199 in value 2. Airtel Postpaid or Broadband or DTH users

5 – Redbox TV

Another excellent application streaming live TV content across from across the Globe is Redbox TV. The developer of this application seems working very hard to keep the application up-to-date and keep on adding new channels everyday.

The android app is small in size (5.6 MB) and compatible with android TV or Amazon Firestick. App provide IP TV from 16 Countries including USA, UK, Australia, France, Germany, India, Srilanka, Malaysia and Indonesia to name a few. Redbox TV also provides you option to make a list of favorite channels. The app contains advertisement that can pop up while you switch channel and can be a little annoying some times.

You can download the app from official website Here

I would recommend trying this app and share your experience with all of us. A must have application on your android device.

6 – Mobdro

Mobdro is another application to stream videos and channels that you might already be using. Mobdro is a tool that constantly looks for free video streams available on the web and makes them accessible on your mobile device.

Mobdro is completely free, although there are two modes: the ADS mode and the NO ADS mode. No ads mode is free from annoying advertisements. I personally like look and feel of Mobdro as its simple to use application. Mobdro is compatible with android device like firetv and android Tvs. You can download Mobdro from their official website Here

7 – Jio TV

Jio Tv has been officially launched in India. Since the Launch of Jio TV, Reliance Industries have been trying to fix all the loopholes that has led to use Jio TV on bigger screens using android device. Here we are providing information related to Jio Tv apk that is still compatible with most of the android devices.

With Jio TV Apk, you can enjoy the most recent content in 15+ languages including Hindi, English, Tamil, Odia, Punjabi, Bengali, Gujarati, Bhojpuri, Malayalam, Assamese, Telegu, Urdu, and more. You can choose any show from various categories such as infotainment, news, sports, movies, music, kiddies, devotional, educational, lifestyle, and more.

Some of the Key features of Jio Tv Mod are:

1. With a long 7 days catch up, you will miss any of your favorite shows. You can watch it later when you are free. It proves beneficial when the showtime doesn’t match with your working hours. You can pause and Live TV channels accordingly.

2. You can separately mark channels as your favorites so you never miss it.

3. It allows you to watch and scroll through the app at the same time. You just need to drag the video downside. You can also browse other applications by clicking on the side window button.

4. In Jio TV Mod, apart from the Jio network, you can enjoy movies and tv shows on networks like Airtel, Idea, BSNL, MTNL, and Vodafone.

5. By using this app you can easily watch your favorite serials, tv shows and movies on your smart TV. Connect your smartphone with your Smart TV and remove the lazy and enjoy all your favorite shows on the big screen for free.

6. Last but not least, the app is available for both Android and IOS. You can also use it on your computer and laptops using the menu, android emulator, Nox, Bluestack, etc.

Though you need a Jio username and password, you can enjoy your favorite movies and run all channels on any network. Jio TV also takes very less storage space which makes it super lite and beneficial. Uninstall your old Jio TV app, install Jio TV , login by entering a Jio number and password, and enjoy it for free.

Here is a link to download Jio Tv for Android TV

Please note: Most of the IPTV contents are protected by copyright laws. Based on your country, please make sure you are not violating the same unintentionally. The post is for educational purpose only and do not encourage violation of any such laws that prohibits from accessing the copyright materials illegally.

Please share your thoughts about the information provided. If you like the content and feel that the information provided is helpful then please like and share the post.


How to find IP address of Mac

There are multiple ways to find an IP address on Mac computers running IOS. If your require knowing you IP address, then one of the following methods can help.

Step 1: Using terminal screen. In this process, You need to click command and space button togather to open “spotlight Search” in your Mac machine. Once spotlight Search bar appears, type “terminal” and hit return key. Your terminal window will pop open. In the command line of terminal window, type “ifconfig” and press the return key. You will get several lines of output. Scroll to find something called “en0”. You Mac IP will be listed in this section.

Step 2: Using network window. Open the spotlight Search similar to how we did in step 1. Search for word “wifi” in your spotlight search bar and hit enter. This will open the network detail window. Head to “advanced” button at bottom right corner and click it. In the next step, click on TCP/IP tab at top center. You will see your Mac IP under ipv4 heading here.

If you want to see step by step video about how to do above steps, click below to watch the video.


How to find Internal IP address in windows

At times, we need to know internal IP assigned to our PC or laptops connected over a network. This might be required to connect another device, or for a file transfer, desktop sharing etc.

Its super easy in windows operating system using ipconfig command in command prompt.

Just search cmd in your windows search and hit enter. In next step, type ipconfig and hit enter. There you go, you have your internal ip right there.

Here is a 40 seconds video with detailed steps:


How to sketch with autodraw. AI in drawings

AutoDraw is a new kind of drawing tool. It pairs machine learning with drawings from talented artists to help everyone create anything visual, fast. There’s nothing to download. Nothing to pay for. And it works anywhere: smartphone, tablet, laptop, desktop, etc.

AutoDraw’s suggestion tool uses the same technology used in QuickDraw, to guess what you’re trying to draw. Right now, it can guess hundreds of drawings and we look forward to adding more over time. If you are interested in creating drawings for others to use with AutoDraw, contact us here.

We hope AutoDraw will help make drawing and creating a little more accessible and fun for everyone.

Built by Dan Motzenbecker and Kyle Phillips with friends at Google Creative Lab.

Here is a quick video tutorial on how to use the autodraw page to enhance your drawing.

Its free and developed by Google.


Stock Market – Learn Technichal Analysis

Hi, I’m Lokesh, and if you haven’t noticed already, I am trying to build this page as a free knowledge-sharing platform for anyone who wants to enter the fascinating world of the stock market. By now, you must be thinking what’s new about this! There are already a thousand pages out there online that are doing the same. You are right about this though as that is a hard reality. So the way I am trying to make this different is by following some simple rules:

1. Keeping the information short, crispy, and easy to understand English. Saving everyone’s time.

2. Trying to make sure all concepts are backed by plenty of real-world examples.

3. Two-way interaction where readers can suggest edits.

4. For any topic that we discuss here, we will simply not go ahead and digest it. Rather we will backtest it multiple time until we are convinced ourself.

Having said all this, it requires a lot of hard work in collating this information and present it in an easy-to-understand format. I will be working gradually on this and will be open to feedback and suggestions. Each topic is supported by video tutorial for better understanding. It is highly recommended to readers to please follow the video links to ensure there remains no gaps in understanding.

So let’s begin….

Before you can jump into the market with your hard-earned money, You require to have a solid understanding of the stock in your mind. The most popular way to get information about your choice of stock is either by doing a fundamental analysis or a Technical analysis. In the subsequent sections, we will talk about how, to begin with, Technical Analysis is the most popular and widely used methodology across the Globe. When you enter the market, you would like to understand and do what most of the people in markets are doing. For example, if most of the people are buying a stock, then You will obviously want to buy that stock as well. In a similar manner, we will use technical analysis as this is the most widely used technique.


Chats Type

Candlestick Charts – Details

Technical Analysis using Candlesticks

Technical Analysis using Charts – Swing Trading

Strategies & Backtesting

Broadband, Education

Improving Your Router’s Signal Strength. It Really Works!!!

WiFi gives wireless waves for the use of internet. There are many devices that uses WiFi to communicate to the wonderful world of internet. Lack of wires make WiFi easier to access and most demanding technology. Most of us are heaving WiFi signals at our home. These signals are broadcasted by a device called Routers. When we opt for an Internet service, our ISP (Internet Service Provider) will provide us with a Router. Alternatively, we can also purchase our own Router.

Our WiFi signal varies by make and model of our Router. Depending upon Router’s brand, we can have a strong or weak signal. No matter whatever router we install at our home, there remains some grey areas where we cannot find optimal WiFi signals. Hence, we may experience slow speed in those areas of home or even no connection. These are called dark areas.

If you do a search on any of the search engine for boosting WiFi signals, you will find thousands of web page suggesting tips and tricks to boost up your WiFi signals. You will also find several device available to boost up your WiFi signals. In this blog, I am sharing with you a very handy technique that you can try at your home to boost up you WiFi signals. I have personally used this trick and the result was worth. My WiFi signals improved about 30 – 40 %

Table of Contents

Things to know: Before you go ahead with the tricks mentioned below, it is important to understand how WiFi signals are measured. WiFi signals are measured in a unit called decibel milliwatts (dBm). A signal strength less than -70 dBm is not considered good. For example, a signal strength of -80 dBm is not good and you will encounter internet issue. Please note that higher the number, lesser signal strength it is. For example -80 dBm is weaker than -70 dBm. -60 dBm is better out of these 2 signals.

How Do Routers Broadcast Signals: Home WiFi routers contains antennas. These antennas can be an internal antenna (placed inside the router cabinet) or an external antenna. The signals broadcast from WiFi routers are generally of 2.4Ghz or 5Ghz. In general 2.4 Ghz signals have an average internet speed 10-29Mbps on 802.11g standard and 150Mbps on 802.11n standard. On other hand, a 5Ghz router will have an average speed of 3-32Mbps on 802.11a standard and 210Mbps-1Gbps speed on 802.11ac standard.

Checking Your Current Signal Strength: I would suggest you to download any of the WiFi analyzer software in your phone and read the WiFi signal strength in the areas identified as dark areas. Android phone users can use “WiFi Analyzer” or NetSpot. iPhone user can use “Fing” or “WiFi Analyzer” app for the purpose. As these signals are measured in dBm and their values are negative, you should remember that a lesser negative number is a more powerful signal. Make a note of your WiFi signal strength before proceeding further.

WiFi Signal measurement graph

A good WiFi signal must not exceed -70dBm. Signal range from -60dBm to -70dBm are considered below average quality signals.

How to boost up WiFi Signals at Home

Boosting WiFi Signal using Mirror: I bet this is world’s simplest and easy to implement trick. It will cost you nothing. All you need is a small mirror to boost up your WiFi signals by up to 40% strong.

I have a Nokia Router installed by my ISP that has its antenna placed internally. I just placed a mirror at the back of the Router and WOHO!!! The signal strength is now -33dBm. This can be considered as an excellent signal strength. Please see the Image below to understand what exactly I have done.

Nokia Router with Mirror reflector

Boosting WiFi signal using Aluminium foil: Aluminium foils are commonly available in every house. We often use it to keep our food hot. This Aluminium foil works great when it come to boosting your WiFi signals. We can make a simple parabolic reflector using Aluminium foil. It works great and you will see a good difference in your WiFi signals in dark areas of your rooms.

Nokia Router with Aluminium Foil reflector

Here is how I have made a simple parabolic reflected using Aluminium foil. I just staple the foil on a hard square paper and placed it behind my Router. It works great. Here is a link to Youtube video on how to make a simple parabolic reflector using Aluminium foil.

Boosting WiFi Signal using Old Router as Repeater: This trick requires a little bit of technical understanding and you should have another working router. I would suggest an old Router that you might have and you are no longer using this. A second Router can be used as Wireless or Wired Repeater.

Essentially, a Wi-Fi repeater extends the coverage area of your existing wireless network by amplifying the signal and then transmitting that signal to a wider area. In short, it receives a wireless signal from your router and rebroadcasts it to another localized area, providing a “bubble” of additional network coverage that you can access when you’re out of range of your router’s finite coverage area.

Here is a detailed instruction of setting up a D-Link DIR-816 as a repeater.

Now that you are aware about the simple yet powerful techniques to boost up your WiFi signals at every corner of your room, its time to enjoy chatting or conferencing from balcony. Enjoy!!


Accessing Password Protected Excel VBA

In a recent assignment at my office last week, I came across a situation where I had to make some changes in the VBA code of an excel document. The excel document was something getting used from long time and there was no one having details related to password through which VBA code in that document was protected. Also there was no related supporting document available. I was in a situation where I required getting the access of VBA code without password.

After a lot of search on web and spending quite some time, I was able to access the VBA code without knowing the password. Although there are a lot of information already available on web related to the topic, however most of the information are either in bits and pieces or not very simple to understand for a non techie person.

Hence I decided to write this blog to present the information in simplest manner possible. Give it a try if you are in similar situation and I am sure this is going to work for you as well. Please follow all steps precisely as mentioned.

Before we jump into steps to access the password protected VBA, it make sense to understand how it works. When we try to access password protected VBA document, the VBE (Visual Basic Editor) will call in build system function to create the password dialogue box. This dialogue box is where the user will enter password to access the document and will click on OK. If the user enters correct password and press OK, the system function will return 1. If the user enters incorrect password or click cancel, the system function will return 0. After the dialogue box is closed, the Visual Basic Editor (VBE) will check the value entered. If the value is 1, VBE will think that the password is right and will open the document. On the other hand, if the value is 0, VBE will think that password is incorrect and will not allow access to the document. The trick that we are going to use is basically to swap the value of 0 to 1 by using a code that can be written easily or can be taken from this post and included in your excel document. Hope this basic helps in making the concept a little easier. Lets jump into the steps now.

For the ease of understanding, I have created a sample VBA document called “Password_Test”. As you can see below, when I try to open this VBAProject, it prompts for a password to be entered.

Okay, so now we will go to the steps directly.

Step 1: First step first. make sure you take a backup of your original file and keep it at a different location in your PC or Laptop so that if accidentally we corrupt the file then we have a backup readily available.

Step 2: Create a new file with .xlsm extension.

An XLSM file is a macro-enabled spreadsheet created by Microsoft Excel, a widely used spreadsheet program that comes with every edition of the Microsoft Office suite.

For ease of understanding, I have named this file as “macro.xlsm”. To create this file, open MS Excel application and then go to File->SaveAs->location and then name your file as macro.xlsm. You can also choose file type from drop down.

Step 3: Open you locked VBA project file. In our case, its “Password_Test”.

Step 4: Open the new blank file that we just created. In our case its “macro.xlsm”

Step 5: We need to insert certain code in our new created “macro.xlsm” file. Once the file is open, click “ctrl+F11” to open the Visual Basic Editor. Once your VBE is open, you will see a screen like this.

Step 6: Select VBAProject (macro.xlsm) then go to Insert and click on Module. A blank page will open on right panel of the VB Editor.

Step 7: On the blank page that open on right of VBE, copy and paste below mentioned code:

Option Explicit


Private Declare PtrSafe Sub MoveMemory Lib "kernel32" Alias "RtlMoveMemory" _
(Destination As LongPtr, Source As LongPtr, ByVal Length As LongPtr)

Private Declare PtrSafe Function VirtualProtect Lib "kernel32" (lpAddress As LongPtr, _
ByVal dwSize As LongPtr, ByVal flNewProtect As LongPtr, lpflOldProtect As LongPtr) As LongPtr

Private Declare PtrSafe Function GetModuleHandleA Lib "kernel32" (ByVal lpModuleName As String) As LongPtr

Private Declare PtrSafe Function GetProcAddress Lib "kernel32" (ByVal hModule As LongPtr, _
ByVal lpProcName As String) As LongPtr

Private Declare PtrSafe Function DialogBoxParam Lib "user32" Alias "DialogBoxParamA" (ByVal hInstance As LongPtr, _
ByVal pTemplateName As LongPtr, ByVal hWndParent As LongPtr, _
ByVal lpDialogFunc As LongPtr, ByVal dwInitParam As LongPtr) As Integer

Dim HookBytes(0 To 5) As Byte
Dim OriginBytes(0 To 5) As Byte
Dim pFunc As LongPtr
Dim Flag As Boolean

Private Function GetPtr(ByVal Value As LongPtr) As LongPtr
    GetPtr = Value
End Function

Public Sub RecoverBytes()
    If Flag Then MoveMemory ByVal pFunc, ByVal VarPtr(OriginBytes(0)), 6
End Sub

Public Function Hook() As Boolean
    Dim TmpBytes(0 To 5) As Byte
    Dim p As LongPtr
    Dim OriginProtect As LongPtr

    Hook = False

    pFunc = GetProcAddress(GetModuleHandleA("user32.dll"), "DialogBoxParamA")

    If VirtualProtect(ByVal pFunc, 6, PAGE_EXECUTE_READWRITE, OriginProtect) <> 0 Then

        MoveMemory ByVal VarPtr(TmpBytes(0)), ByVal pFunc, 6
        If TmpBytes(0) <> &H68 Then

            MoveMemory ByVal VarPtr(OriginBytes(0)), ByVal pFunc, 6

            p = GetPtr(AddressOf MyDialogBoxParam)

            HookBytes(0) = &H68
            MoveMemory ByVal VarPtr(HookBytes(1)), ByVal VarPtr(p), 4
            HookBytes(5) = &HC3

            MoveMemory ByVal pFunc, ByVal VarPtr(HookBytes(0)), 6
            Flag = True
            Hook = True
        End If
    End If
End Function

Private Function MyDialogBoxParam(ByVal hInstance As LongPtr, _
ByVal pTemplateName As LongPtr, ByVal hWndParent As LongPtr, _
ByVal lpDialogFunc As LongPtr, ByVal dwInitParam As LongPtr) As Integer

    If pTemplateName = 4070 Then
        MyDialogBoxParam = 1
        MyDialogBoxParam = DialogBoxParam(hInstance, pTemplateName, _
                   hWndParent, lpDialogFunc, dwInitParam)
    End If
End Function

Step 8: Repeat Step 6 and 7 and paste following code in “Module 2”

Sub unprotected()
    If Hook Then
        MsgBox "VBA Project is unprotected!", vbInformation, "*****"
    End If
End Sub

Step 9: We are almost done. Next you need to run your code. To run the code, click on small Play button on the menu bar on top

You will see a message like this. Click on “OK” and your locked VBA project will be accessible now. Please note: This trick will work on 64 bit MS Excel only.


How to share screen without installing any software

If we want to share our screen for work or school related presentation, we require a specialized software to share the screen. Most of the organizations and school already have licenced tool available for this purpose. Most of the screen sharing tools requires an advance preparation before you can start. For example, the software must be downloaded, installed, configured and registered before you can actually start using the same. In some organizations, access to these tools are restricted to higher management only. Forget about organization, in our day to day life we often require sharing screen with a friend or group of people when we look for a quick solution rather than going for a licenced tool.

We will look at some of the fastest screen sharing website/tools that can be setup and be ready to use in couple of clicks. Lets have a look.

  1. Dead Simple Screen Sharing – I have kept Dead Simple Screen Sharing on top of our list because it is one of the simplest way to share the screen. One can access their website by following url Dead Simple Screen sharing supports audio/video right from your browser.

How to share screen using Dead Simple Screen Sharing

Step 1: Click the ‘Share your Screen Now’ button to create the screen sharing session and click on the “Allow Microphone”

Step 2: Install the chrome extension by clicking the install extension button. Extension is only required on Google Chrome, in Firefox you can do screen sharing without the extension

Step 3: A popup will appear that will ask you to select the screen you want to share. You can share your entire screen or an application window.

Step 4: Your screen is now being shared, you can invite participants by sharing the ‘Invite URL’ or using email

2. Web Whiteboard – Although, this is not a screen sharing tool however it is considered one of the simplest and easy to use Whiteboard to draw and write together online instantly. There is no installation or tutorial required to get started with Web Whiteboard. Passwords and accounts are entirely optional. Just create an online whiteboard with one click, and share it live by sending the link to people.

How to use Web Whiteboard

Step 1: Access Web Whiteboard by opening following URL in to your browser:

Step 2: You will get option to either Signup, login or Create free whiteboard. Select as per your requirement.

Step 3: If you opt to signup, the cost is $8 per month. However if you go for a free Whiteboard, it will last for 21 days.

Step 4: Once your free whiteboard is ready, you can share the URL at the top of your browser to other people you want to join you. The URL will look somewhat like

Step 5: The whiteboard can be accessed from any browser in PC, Laptop, Tablets or Mobile phones.

3. HelloAiko Meet – This is again a simple and free tool preferred for video conferencing. The tool is free forever and do not require you to provide any credit card details. ‘Aiko Meet’ adds the power of cutting-edge Artificial Intelligent to a convenient, browser based video conferencing solution. Aiko Meet works entirely in your browser, without any extensions or installations. Aiko Meet uses TLS, the current standard in secure communications, to ensure that your conversations remain totally private

How to use Hello Aiko Meet

Step 1: Access ‘Hello Aiko Meet’ by typing following URL into your browser:

Step 2: On the page that opens, click on ‘Get Started’

Step 3: If you are a new user, you need to create a one time login account by clicking on “Signup” button and providing a user name and password. If you are an existing user, you use to “Signin” at the top right of the page.

When you signup for the first time, a room is also created for you that can be used for video conferencing services.

Step 4: Once you are login and ready, on the left hand side menu, you get options like ‘Add a Team Member’, ‘Integration with your domain’, ‘Settings’ etc.

Step 5: On the top left, there is an option to go to room. Once you click on this button, you can enter the Video Conferencing Room dedicated for you. Once inside your room, you will also get a link to your room that you can share with your participants. When a participant joins in, You receive a notification to accept or reject the request.

Step 6: on the bottom of your meeting room, you see several controls like mute/un-mute microphone, stop/start your video, share your screen, chat window etc.

Finally, hope these three free tools will definitely going to help you in your day to day work. Feel free to share your experience about the same and comment on the post.


Simplest way to understand excel vlookup function

Excel vlookup is most talked about inbuilt function available with MS excel or Libre office. This is one of the function that is definitively required if you are a working professional and have to work on some sort of spreadsheet containing data. However, there are many of us who do not have a clear understanding of the function and hence are not able to utilize this function. Often, we shy away because we do not have an understanding of this powerful function and we prefer to work manually spending hours.

In this post, we will try to understand vlookup function the easiest way. Once you have gone through this article and develop the understanding of how vlookup function is designed and how to use it, do not forget to practices it multiple time to make things clarified further.

Vlookup explained – vlookup simply means vertical lookup. That literally means that the function will lookup for a particular value vertically.

Let us understand this with an example. In the figure below, Social security Number is arranged vertically in a column. What if you need to find a social security number as 917823098 in this list? You will start from the first cell (A2) and will move vertically downwards until you match (Cell A5). Please note how you started from beginning of the data and moved vertically downwards each cell to match your SSN (917823098) in cell A5.

Wow!! That’s seems quite simple. Right?

Yes. Now that we have basic understanding of how vlookup function searches the data vertically for a match, lets take a look at the formula and its output. We will take the same example and will try to figure out if SSN 91783098 can be found using a formula? Remember, we matched the SSN manually; hence we know that SSN 91783098 exists in our list of SSN.

Here is the formula for vlookup to be used in your excel spreadsheet.

=Vlookup(‘lookup value’,’table array’,’column index number’, ‘range lookup’)

Confusing?? Let’s understand each component separately.

Lookup Value = The Value that we want to find in the list. In our case, we are looking to find SSN 91783098

Table Array = This is simply our list of SSN where we are trying to find our data (SSN:91783098)

Column Index Number = Ignore this for now. We will learn about this is a short while.

Range Lookup = Match Type. (Exact Match = FALSE or 0 or approximate match = TRUE or 1)

Hence, now we can write above formula as per our requirement and it becomes:


Look at vlookup fig below:

If no match is found that formula will return a value as #N/A

Excellent!! Whatever we did in above example was the simplest example of vlookup where we tried to find a single data in a column containing multiple data. Now we will focus to figure out how to find multiple matching data in a bunch of data. Let us consider the same example as above, however this time we have another set of data in column D. Have a look at the figure below.

As we see in this figure, we have added another group of data (Group B). Now we will try to look each data in Group A and will match with every data of Group B. We will do it as an exact match and any data in Group A not found in Group B will give output as #N/A. Let us start writing our vlookup formula in column B. Refer to figure below for clarification.

Great! We see that first SSN in Group A is not present in Group B. Let us drag our formula in B2 further down in column B until B9 to see what the results are for other SSN. Please refer figure below.

Clearly, we see that we have 3 match from Group A to Group B. We can also apply vlookup from Group B to Group A in similar manner. Have a look on figure 6 to see how vlookup results appeared when we try to match from Group B to Group A.

We apply the formula into cell E2 and will drag the formula from E2 until E9. Please do not forget to make sure you freeze the values in B2:B9 before dragging the formula by putting $ sign before the cell numbers ($B$2:$B$9). See how the vlookup gives the result for this match.

Now that we understand basics of vlookup function and how vlookup can be applied between two columns to find exact match or approximate match, we will go a little further and include more data in Group B. Our objective here is to “understand Column Index Number” that we skipped previously. In Group B, along with social Security Number, we will add First name, Last Name and Monthly Income. Group B now looks like this.

Use of Column Index Number: Column index number is used point to another column corresponding to a matching column. For example, in Group B corresponding columns for first SSN (320982233) are First Name, Last name and Monthly Income with values as John, Carter, $3500 respectively. So using column Index Number we can apply a vlookup to match first column i.e. column D containing SSN. If it matches, then we can display value of any corresponding column.

Lets understand this with an example. What we want to do is write a vlookup formula in column B to find the last name for each SSN present in Group A. We will pick each SSN from Group A, match it with SSN in Group B and the will get result as Last name if there is a match.

Here is the formula to achieve the goal: =vlookup(A2,$D$2:$F$9,3,0)

Now understand details of formula:

Formula Name = Vlookup

A2 = The value we want to look for in Group B (Lookup Value)

$D$2:$F$9 = Table array (Selecting all data where we are applying our formula. Look closely to see that this time we are including more data in table array then previous example. This is being done because we want Last name as formula result and not just a simple match)

3 = Column Index Number (We are using 3 in our formula because we see that Last name is in the 3rd column of our Table Array)

0 = For exact Match

As usual, if we do not have any match, we will get #N/A as our result. If we have a Match, we will get Last Name in Column B.

We can have different column index applied on matching SSN’s and we will get the desired results. For example, below formula will print Monthly Income in column C.


See how we are changing the Table Array selection and column Index Number to get the result.

This is all about vlookup. The formula is very simple to use and reduces a lots of effort when picked wisely. Often ignored due to not having an understanding. Please let me know if you have any related question.


How to access Jiofiber router

Since the launch of Jio giga fiber in India there is a massive demand of Jio fiber connection. The plans are comparatively cheaper and services are quite good. I am personally using Jio gigafiber plan from last 2 months and have never faced service distruption.

Jio giga fiber installation comes with their own router. Router is sleek in design and has a port for connecting a landline telephone as well apart from other lan connectors. It also has a built in Optical Network Terminator. Hence you do not require a seperate ONT box.

To access the router, you need to make sure you are connected to the same wifi. In your browser like chrome, type followin IP to access the router login page:

jio giga fiber router login page

Once you are in login page, use default username as admin and password as Jiocentrum

Jio login screen

Thats it !! Once you are logged in, you have full control of the device. Try it and let me know your experience.


How to use Whatsapp Voice to text feature

Have you ever tried using whatsapp voice to text feature? Although it has its own limitation but some times the feature seems quite usefull. I personally use this feature and encounter spelling mistakes. However, no system is fault proof. The feature is in its early days and continously evolving.

Although Whatapp has another feature where we can send voice messages. However, if you want to check historical voice message than its difficult to find the message containing the exact information you might be looking for. You require listining several voice messages befor you actually get what you were looking for.

To use the Whatsaap Voice to text feature, You need to open a chat box (one who you want to chat with). Next Click on the blank text bar (as if you want to type a message). Now you need to click on little microphone icon right to text bar. Please refer the image below to get an idea. Once Microphone icon is clicked, Whatsaap will continue to listen. You can always verify your words before clicking on send icon.

A simle but usefull feature that we igonre fequently. Feel free to share your thoughts regarding Whatsapp Voice to text feature.