Buzzing Thoughts

Your Daily Dose of News, Updates & Hacks.

Page 3 of 3

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.

Top 3 Squarespace Alternatives In 2016

When deciding which ecommerce platform to use for your next online store, it can sometimes be difficult to find the perfect match as per your needs and preferences. While Squarespace is certainly one of the top ecommerce platforms for creating and managing ecommerce sites, there may be reasons why you would prefer to go with another platform. To help you find the right match, I explored various ecommerce platforms and shortlisted the top 3 ecommerce platforms that can be used as an alternative to Squarespace.

 

Shopify

Widely considered as a market leader in its space today, Shopify is definitely a strong alternative to Squarespace. The platform offers a range of features including seamless third party integration, point-of-sales application, content management functionalities, multi-level security and 24/7 customer support that probably make it a worthwhile option for most ecommerce needs.  Whether you are planning to build a new ecommerce site or migrate an existing one, Shopify has it all in terms of an easy setup, user-friendly dashboard and unlimited customization options.

It comes with three different packages priced at $29, $79 and $299, and you can choose the plan that best suits your needs and budget. The platform offers 12 free templates for creating multiple sites to those who are not willing to go premium.

Some key USPs include:

  • Point-of-sales feature that allows you to sell both online and offline
  • Seamless third-party integration for improved functionality
  • 24/7 customer support through email, live chat and phone

Click Here to Try Shopify for FREE!

 

BigCommerce

BigCommerce is an another ecommerce platform that comes with a plenty of features and add-ons that make it one of the most preferred choices for many big & small companies. It offers a powerful and user friendly interface that allows you to build and manage your ecommerce site efficiently and effectively. Similar to Shopify, the platform offers user-friendly dashboard and numerous customization options through which even a non-technical person can build a site within a few minutes. BigCommerce offers three different packages priced at $29.95 (standard plan), $79.95 and $199.95.

Some key USPs include:

  • More than 100 in-built features coupled with an even larger number of apps/add-ons
  • Clean, user-friendly templates that save you all the complexities and confusion
  • It comes with free hosting and tons of free and premium themes

Click Here to Try BigCommerce for FREE!

 

wooCommerce

wooCommerce is a free WordPress shopping cart plugin which you can integrate to any WordPress theme. It is fully customizable and can be a good Squarespace alternative if you are using the WordPress CMS as the basic platform for hosting your site. wooCommerce is also an ideal choice for those who already have a WordPress site and want to add ecommerce functionalities in it. The plugin comes with pre-installed payment gateways and other standard ecommerce platform features.

Some key USPs include:

  • Offers more than 300 free and paid extensions for improved functionality
  • It has built-in coupons, up-selling, cross-selling, and sales pricing functionalities
  • It is 100% free to download and install

Click Here to Try wooCommerce for FREE!

 

Conclusion

There are many alternatives to Squarespace and it totally depends on your needs and budget to choose one amongst them. While Shopify has been around longer than other ecommerce platforms/plugins, BigCommerce and wooCommerce provide you with a few additional features at lesser prices.

In case you have any further queries about the above, feel free to leave me a message in the comments below.

Newer posts »

© 2017 Buzzing Thoughts

Theme by Anders NorenUp ↑