Tag Archives: How-to-guide

How to convert standard date mm-dd-yyyy format into mm/dd/ format

Excel by default use MM-DD-YYYY format during filling the date in any cell. But most of the person use different format to fill the date of birth in Excel. Sometime we need to fill the date in different format as compared to standard format. In that situation it will take lot of time to do this job manually. In this guide we have to discuss how to quickly convert standard date mm-dd-yyyy format into mm/dd/ format using Find and Replace command. Read More

How to use Countif function with wildcards in Excel

Countif is an important function which is used to count number of cells which meet the given single condition or criteria. You can use Countif function to count number of cells which have any number, text or dates that match the given specific condition. But sometime we need to use wildcards for partial matching in the given range of cells in active worksheet. In that situation you must know how to use Countif function with wildcards in Excel Read More

Save your parking location Using Google Maps on Android or iPhone

Google Maps has been added a new latest feature which is quite useful for all Android and iPhone users. You can easily save your parking location using Google Maps on Android or iPhone. This feature allows you to quickly save the parking location of your vehicle. With Google Maps you can easily navigate any places, remind you about the location and many more. Now, this feature allows for Android and iPhone users to save your car parking location. Read More

How to Delete Duplicate Songs from iTune library

Did you know how to find and delete duplicate songs from iTune library. There are lot of music lover around the world. They have to store lot of songs in his device. During playing the songs you feel some duplicate songs repeat and repeat. In that situation it is not easy to find and delete duplicate songs from iTune library on manual basis. Here we’ll discuss any important trick which allows you to quickly find and delete duplicate songs from iTune library. Read More

Beauty of Goal Seek feature in Excel to Find the Answer

Goal Seek feature in Excel is an important part of What-If-Analysis. it is an important feature of Excel which allows you how to one value in the formula impacts to other cell value. Goal Seek is the best tool used to find the result by adjusting an input value. There are lot of situation in which you can use Goal Seek feature during preparing different kind of reports. If you have more than one variable values and you want to change the final result value but want to apply effect only for one cell. Read More

How to determine which system apps can be disable on Android phone?

There are lot of apps are running in the background on your Android phone. Most of the system apps which is already installed when you unpack your new handset while others are installed by the users from Google Play Store. Apps occupied lot of space and reduce the system performance in that situation it is not so easy how to determine which system apps can be disable on Android phone? Read More

Latest Nearby Friends feature on Facebook

Nearby Friends feature on Facebook allows you to find your friend location when they are nearby. You can easily use Nearby Friends feature on Facebook at your smartphone.You can easily track your all Facebook friends real time location at your Smartphone. You can also quickly meet your nearby Facebook friends. Facebook is a very popular and free to use social networking website. It allows his registered users to create profiles, upload photos and video, send messages. Read More

How to Hide Blue Ticks and Last Seen of WhatsApp

When you read any received messages on WhatsApp two blue sticks shown on sender WhatsApp account. That means his messages is read by receiver on his WhatsApp account. Sometime you need to hide blue ticks and last seen of WhatsApp account. In that situation lot of person have to turn off read receipts or turn off last seen feature from Privacy option of his WhatsApp number. Read More

Latest 7 Excel Tricks which makes you an Excel Expert

Excel plays an important role during daily working on different worksheets. If you have a big data than you must have to use given latest 7 Excel tricks which makes you an Excel expert. Most of the novice Excel users don’t about these tricks. But after using these tricks your working speed is faster than others. You can also gain lot of knowledge about the Excel. If you want to become an expert on Excel then you must know about the different Excel tips and tricks.  Read More

How to check Who is Visited or Viewed My WhatsApp Profile?

WhatsApp is very popular instant messaging app around the world. Many WhatsApp users check another WhatsApp user profile like photo, location and other things. Most of the person want to know how to check who is visited or viewed my WhatsApp profile today? But WhatsApp does not have this feature to give you this type of information at your device. But there is no need to worry today we have to discuss how to know or check who is visited or viewed my WhatsApp profile with the help of third party app. Read More