Buzzing Thoughts

Your Daily Dose of News, Updates & Hacks.

Category: How Tos (page 2 of 2)

How To Clear Your Internet Browsing History

As you browse the Internet, you leave a record of your activities and important information in multiple forms. This recorder information is known as digital footprint or simply the Internet browsing history. Some of the forms/categories in which your information is stored are:

  • Search Engine History
  • AutoFill Form History
  • Cache and Cookies
  • Browser History
  • Download History
  • Login History

The names are self-explanatory and indicate the kind of details stored under each head. Most people prefer to clear Internet browsing history periodically, especially if they are using public or shared computer. It is not that you have something to hide, but it is always advisable to clear your browsing history in order to ensure that your personal details and browsing behavior don’t fall in the wrong hands.

You can clear your Internet browsing history by following simple steps as mentioned below:

How to Clear History on iPhone?

iPhone uses Safari as a default browser. For clearing your browsing history, tap on the Settings icon, go to Safari and tap ‘Clear History and Website Data.’ You can also ‘Clear Cookies and Data’ but that would imply entering your general information such as name, address, and other personal details once again.

If you have downloaded separate Google and Gmail applications, go to settings menu on that particular app and select ‘clear history.’ It will erase all your search and browsing history, resetting it to nil.

How to Clear History on Android Phones?

Though there are different browsers that you can install and use in an Android-based smartphone, there is a standard way to clear/manage browsing history. Go to settings in the phone and tap the Privacy option. Under that, select Clear Browsing Data. This option is present on the top right corner of the settings screen. A list will appear and you can select the types of data you want to clear.

Alternatively, you can clear the history from the browser app, google search and other apps that store user information.

How to Clear History on Google Chrome?

Chrome has a suite of applications that offer different features. These apps are available on both desktop/laptop and smartphone devices. More or less, the data and information on these apps can be centrally managed via History and Advanced Settings option.

You can clear your Internet browsing history from the Settings option under the Chrome app. Go to Settings by tapping on the three horizontal lines on the top right corner, tap on Privacy option, and select the information you want to clear – search engine, autofill forms, passwords, etc.

Are you still facing any problem while clearing your Internet browsing history on your cell phone, PC or laptop? Share with us your queries in the comment section below.

How to Set Up Voicemail on an Android or iPhone

Voicemail is one of the most overlooked features in a mobile device, but if used properly can save your day and prevent unwanted situations that may occur due to poor or no communication. Voicemail feature allows you to leave a voice message for your callers in case you are in a meeting or occupied in some other activity. It is a much better option than rejecting or not answering the call. At the same time, callers can also leave you a message in case if there’s anything urgent. Remember, timely and proper communication is the key to any successful business or association. And setting up voicemail can help you in this.

Setting up voicemail is a child’s play. You just need to follow few simple steps on your smartphone, record a customized message, and the voicemail service is up and ready.

Given below is a step by step process on how to set up voicemail on Android phones and iPhone.

How to Set Up Voicemail on Android Phones?

There are two ways to configure voicemail on an Android Phone.

Through Speed Dial Mechanism:

  1. The speed dial option in the Android phones’ dial pad has fixed number “1” as the shortcut for calling your carrier’s voicemail service.
  2. The voicemail number will vary from one network provider/carrier to another, but you can simply long-press number 1 on the dial pad to connect to the voicemail.
  3. Let the interactive robot on the other side guide you through the voicemail set up.
  4. You would have to follow a three step guided process that requires you to select language, create a customized greeting, verify password and subsequently activate the voicemail service.

Through Settings Option:

  1. In your phone, go to Setting and then go to Call settings
  2. Under Call settings, tap on Voicemail, then select/tap on Setup.
  3. Under the Setup, select My Carrier and verify the number. You can call on the given number and create a customized greeting for your callers as in the steps mentioned above.

How to Set Up Voicemail on an iPhone?

There are two ways to configure voicemail on an iPhone.

Through Dial Pad:

Click the dial pad on the home screen and tap the voicemail icon in the bottom right corner of the dial pad or number pad. When you tap the voicemail icon, the phone will connect the call to the voicemail center of your telephone network service provider. Follow the instructions that require you to set up a password/enter a password and create a customized greeting.

Through Visual Voicemail:

Alternatively, iPhone has an option of Visual Voicemail as well. This feature depends on the carrier plan you have chosen. If the plan allows, you can configure Visual Voicemail manually by tapping the app, and verifying the password and creating a customized greeting. An iPhone allows you to check the voice mails as you would check audio emails; simply tap the icon and play from the list of voice mails your callers have left.

In addition to these options, different phones (Android, Windows etc.) have distinct Voicemail apps that allow you to configure and sync the voicemail feature with the voicemail service provided by your carrier. An iPhone has this app pre-installed while Android users can install the app and manage their voicemail settings from there.

In case you want any further assistance or have any query, you can share the same in the comment section below.

How to Use VLOOKUP Function in Excel

Excel is widely used in many offices for maintaining employee data, company accounts, and other important details in a systematic order. But, finding particular information from a large data-set may sometimes be difficult for an employee. It is therefore advised to use VLOOKUP function in excel to filter large data arranged in different tables by selecting an appropriate category based on the given condition.

If you’re finding it difficult to use or access VLOOKUP function in Excel, here’s a quick guide that could make your task easier. Follow the below mentioned steps if you’re not familiar with the Excel’s VLOOKUP functionality:

1. To start with, a complete database must be available so that the required data can be sorted out well. Below is an example of a table with unique categories:

VLOOKUP

2. Every database contains an exceptional identifier. In the above table, “Item code” is a distinctive identifier.

3. To use Excel’s VLOOKUP functionality, the column header must be different from the other columns and it must be the first column of the database.

4. To use the VLOOKUP function, the following information must be available:

  • Lookup_value: The value which you want to look for
  • Table_array: The cells in the table which form the complete table
  • Column_index: The column number to retrieve the information or result
  • Range_lookup: TRUE for approximate match or FALSE for an exact match

5. Add an extra column which pulls out the information from the LOOKUP table.

VLOOKUP

6. Column E is added as an example above.

7. Place the cursor on the first blank cell in the column. In the image above, it is E2 cell.

8. Select Function from the insert menu. In the search for a function text box, type “VLOOKUP” and click on go.

9. Select VLOOKUP from the list and click on OK.

10. After clicking OK, the Function Arguments dialog box appears which allows you to define the values.

VLOOKUP

11. In the LOOKUP value, write D2 which represents in stock to look up the value as 5.

12. In the table_array, select the ranges from where the data must be used.

13. Things to know while using a table array:

  • On the left hand side, the column which has to be referred must always be present
  • Duplicate values must not be present.
  • The cell reference need not be changed for the lookup table while dragging and implementing the same formula for various cells

14. In the column_index, add the column value which has to be used.

15. In the range_lookup, if exact match is required then add False else choose True. Based on the user’s requirement, the range_lookup value can be chosen.

VLOOKUP Function

There are numerous ways of using Excel’s VLOOKUP functionality and it depends on your individual requirements to use the same. The above example is the simplest way you can retrieve data from a large dataset. Through VLOOKUP function, users can look for any information present in the database and can also merge the data from different tables and use them collectively.

In case you have any queries about the above, please leave us a comment below.

Newer posts

© 2017 Buzzing Thoughts

Theme by Anders NorenUp ↑