Author: Roberta Stone

Infographic: 7 Essential Excel Tricks Every Office Worker Needs to Know

MS Excel is a spreadsheet program for calculation, pivot tables, graphing tools and a macro programming language for Visual Basic. It is commonly used by Accountants or anyone whose job involves computation and data analysis.

To be called as an Excel expert, you need to know the tricks and methods to use this program easily. These tricks include shortcuts, formulas, formatting and many more.

If you want to be an expert in Excel, learn these 7 essential tricks that you can use in your studies, office works and in business.

Recommended: Keyboard Ninja: Type Fast and Access Everything In Seconds

excel-tricks-infographic
Source: Internet

Showbox BlueStacks: Download & Install Showbox on PC via BlueStacks

Watching movies and TV shows is one of the best type of entertainment for people while travelling or when having some free time! Since people also have a hobby of watching the latest as well as classical movies. Since a new movie is released every week, it is nearly impossible to keep a track of them and watch each and every one of them in the theaters. Thus, to solve this issue, you can make use of Showbox, which provides with an extensive library of movies and TV shows which you can stream for free!

There are many other similar websites and applications which also provide with movies and tv shows. However, most of them can be used only when you purchase its subscription or renew it one expired.

Update: Showbox isn’t that good of an app to use, instead you should use mobdro. You can download mobdro from its official website. Rest the tutorial is pretty much the same.

Features of using Showbox on Bluestacks include:

1. It provides with all the features which are available on its application for smartphones for free!

2. You can use any media player installed on your computer to stream the videos, if you do not wish to use its default media player.

3. You can also download your favorite videos so that you can watch then when offline.

Some of the prerequisites for installing Showbox on Bluestacks are:

1. Windows XP or 7, 8, 10.

2. A minimum of 2GB RAM in your PC.

3. 4GB space is available on your hard disc.

4. Bluestacks Android emulator installed on your computer.

5. A good internet connection.

Steps to install Showbox on Bluestacks are as follows:

Step 1- First, you must download the APK file of Showbox from its official website and then, launch the Bluestacks Android emulator which you have installed on your PC..

Step 2- Now, navigate to the location where you had downloaded the APK file of Showbox. Right-click on it and click on ‘Open with‘ and then select ‘Bluestacks APK handler‘ to start the installation process.

Step 3- Once the installation process is completed, search for the icon of Showbox in the list of all the apps in your Bluestacks Android emulator. When you find the icon, double-click on it to launch Showbox on your PC over Bluestacks.

Step 4- Once the app is successfully installed and launched, you can search and stream any movie or show on your PC. The quality and buffering time of the video will depend on your internet connectivity.

Conclusion:

This is all you need to know about Showbox on Bluestacks before you start using it! If you gave any queries, then please let us know about it in the comments section below.

Productivity Apps That You Need Right Now

Productivity apps help people improve their everyday life and their way of living overall. There are tons of apps that offer different kinds of benefits but not all of them live up to their promise. Some are just adware and some just want to take money from you. But the question is if it really worth every penny.

Productivity apps that suit you

Not all apps that promise improvement in your lifestyle are really what they say they are. And not all apps that available in Google Play will suit your lifestyle. There are people that actually download and install apps just because they sound too good to be true. And then there are people who download and install apps and end up not using them anyway. For instace many of my friends have downloaded shareit for pc and tubemate for pc from this site, but they hardly use these apps.

Aside from the fact that it is just a waste of storage, it is also a waste of your time. The worst part is that your phone might end up performing really slow because your installed app drains your CPU, RAM, and battery resources in the background.

We decided to list some of the apps that are actually useful for certain people. These apps are intended for specific people with the specific requirement of their lifestyle.

Productivity apps

There are other apps not mentioned above that improves productivity in the workplace like Shareit which is a fast and hassle-free file sharing app that works on Android and iOS. You can use it smoothly share photos, documents, videos, and any other files on mobile and PC. You can download Shareit for pc for free.

Source: Internet

Also read: Keyboard Ninja, Jim Boggia, The Magic Numbers

 

Fix “Unidentified Network” Issue On Windows 10

Unidentified Issue

One of the most common issues of Windows operating system is the Unidentified Network problem. When these words appear on your network status, you will never get an internet connection no matter how you refresh your web browser. But since this is a common issue, you can expect that there are already a couple of sure ball solutions that you can use to fix this.Unidentified Network Issue

The Unidentified Network problem is usually a cause of typical errors. These errors could be due to recent software update, loose connections, and a bug from the router itself. So we will try to tackle all of those within this article. Hopefully, one of them is your solution. So before we go straight to the fix that you need, please be reminded to follow the instruction exactly as it is stated. And do not try bypass or do any shortcuts to prevent creating more issues. Let’s start.

How to Fix Unidentified Network Issue on Windows 10

Things to do first:

We have prepared a couple of methods to make sure that you will be able to fix the Unidentified Network issue when you leave this article. But before we continue, let’s make sure that the problem is not from the simplest problems first.

  • Check the LAN cable if it is properly connected to the LAN port of both the computer and the router or modem.
  • Restart your PC because it might be the cause of a bad boot.
  • Restart your modem and router to make sure that it is not just due to overheating or power interruption.
  • Speaking of power, check the power cords of the router or modem and see if there is some damage or something.
  • Turn off your Antivirus. There is a possibility that it is just a cause of an oversensitive detection mechanism of the software.
  • Call your ISP customer service hotline for some unannounced maintenance within your area.
  • Make sure that your internet bill is paid and updated.

Method 1: Reinstall Network Adapter Driver

  1. Sometimes, driver software is the culprit for this type of error. To check for this problem, hover your mouse to the bottom leftmost corner of your screen right exactly where the Windows Start icon is located.
  2. Right-click on it to display a list of services.
  3. Find the Device Manager and left-click on it to launch its own window.
  4. On the Device Manager window, click on the Network Adapters line.
  5. If it shows your network adapter but with a yellow icon on the side, that means the driver is not compatible, damaged, or suffered an error.
  6. If that is the case, right-click on that network adapter and hit Uninstall.
  7. Make sure to check the delete the software driver for this device.
  8. Do a system restart.
  9. See if you are now able to connect to the internet
  10. If not, install a new updated driver for your network adapter.
  11. In case you do not have a saved copy of the driver software of your network adapter on your local drive, you may download one from the manufacturer’s website.
  12. After the download, install the driver and then restart.

Method 2: Adding IP Address Manually

If you have not touched your IP address settings, it is likely that your computer is using a DHCP IP address or an automatic assigning of IP address for a period of time. So here is what you should do if the Unidentified Network issue pops up.

  1. From your main desktop, press the Windows key + R on your keyboard.
  2. The Run window will appear. Type in NCPA.CPL and press Enter key.
  3. You should see your network adapter. Double-click on it to launch the Ethernet Status window.
  4. Click on the Properties to open a new window and scroll down to see the TCP/IPv4.
  5. Double-click on it to launch the IPv4 Properties.
  6. On the General tab, choose the Use The Following IP Address.
  7. Type in a new IP address such as 192.168.1.21 or 192.168.1.22 or higher. (Subnet mask of 255.255.255.0 and default gateway 192.168.1.1 should be kept unchanged.)
  8. On the Use The Following Server Addresses, type 8.8.8.8 for the Preferred DNS Server and 8.8.4.4 for the Alternate DNS Server.
  9. Click OK to close all the windows you have opened.
  10. Now the DNS servers and the IP address will take effect. Your internet should be working by now.

Method 3: Reset Winsock

If the above methods still do not work, this last one should make you smile as this is the best method to fix this type of issue.

  1. On your main desktop, put your mouse on the Start icon on your leftmost corner of the screen and right-click.
  2. You should see the Command Prompt (Admin) or the Windows PowerShell (Admin). Click on it to launch the Command Prompt service.
  3. Type netsh winsock reset and press Enter key.
  4. Then type netsh int ip reset and press Enter key again.
  5. Now type ipconfig /flushdns and press Enter for the last time.
  6. Close the Command Prompt window and restart your PC.
  7. After the reboot, your internet should now be working properly.

In Conclusion

Always remember to reboot your Windows PC each time you make changes to make sure that it will take effect. Also, there are instances that a recent Windows 10 update is the problem. If that is the case, the third method should work as your solution.

If not any of these methods ever worked for you then the problem is much bigger than you think. We will advise that you see or bring your Windows PC to an expert to diagnose and fix the real issue. It could be that the LAN port is physically damaged or there is more there than meets the eye.

If you have queries regarding this article, please do leave a message in the comment section for your questions and concerns. We will be more than happy to answer all of them. And if you know someone that experiences the same issue, do share them this article to help them out.

Keyboard Ninja: Type Fast and Access Everything In Seconds

How many words can you type in a minute? If your average typing speed comes around 20 words then you probably just learned to get used to the QWERTY style keyboard. Or perhaps you just do not want to bother to be a fast-typer at all. But what if you can be a different kind of fast without breaking a sweat? What if you could be a keyboard ninja?

What is a keyboard ninja?

A keyboard ninja is some who knows all the shortcuts and key combination of the keyboard. It helps to access almost all the features from obvious to hidden features of Windows operating system. A simple CTRL + C means you can copy the highlighted file or words. Then use CTRL + V to paste them anywhere you want to. But that is just a tip of the iceberg.

In this infographics, you will learn a ton more. And probably somewhere along the line, you will be surprised to learn some couple of shortcuts that you did not know exist.

Are you excited now? Go and on more.

Keyboard Ninja

Source: Internet