Author: Aniruddh

  • HTC One Tutorial On Adding And Syncing Contacts With Email Accounts Or Social network accounts

    HTC One is one of the most popular smartphone in the market right now. It comes with lot of features. Like many other Android smartphones, this phone too supports adding and syncing your data with email accounts and social networking sites such as facebook. The advantage of syncing your data with email accounts or social network sites is you will have a backup of your contacts,calendars and some other information. It will also help you to transfer or access your important data from other devices.

    HTC One Contact syncing

    Adding email account or Social networking accounts to HTC One

    As said earlier you  can sync your contacts, calendars etc from web to phone and vice versa in HTC One. First have your account which you want to sync ready and follow the below procedure.
    1. Go to Settings by sliding the notification panel. Choose Accounts&Sync
    2. Tap on to + to add the new account
    3. From the drop down list, select the account you want to add. It has google, facebook etc. Choose the accounts you want to add
    4. Sign in to your account if want to use your already exist account or create new account.
    5. Follow the onscreen instruction to complete the process.
    6. In settings-> Accounts&Sync , tap the auto sync On/Off to switch automatic sync of all your accounts.

  • How to Download Micromax Drivers And PC Suites

    Micromax is one of the leading mobile manufacturer in India. It has released many aggressively priced Smartphones with decent specification. PC suite or the drivers for Micromax mobiles is required for connecting your phone to PC. So here is a simple guide to download Drivers for your Micromax mobiles from the official website. These Micromax Drivers will be useful for USB tethering.  You can read my post on How to use Micromax Mobile as modem.

    Downloading Micromax Drivers for Mobiles

    You download free Micromax Drivers from the official support. Below the instructions to follow to download the free drivers for Micromax smartphones.
    Micromax Drivers

    1. Visit the Micromax Phone essential download page by clicking here.
    2. Select your Smartphone model from the drop down list under “SELECT YOUR PHONE TO FIND COMPATIBLE DOWNLOADS” Label.
    3. You will get a list of all available Download for your Micromax mobile.
    4. Click on Driver to download start downloading.
    5. Once downloading completed, install the driver.

    Micromax PC Suite

    Micromax currently not providing the PC suite like Samsung Kies for Samsung mobiles. However, you can use many third party applications to use as a PC suite for your Micromax Mobiles. My favourite is Airdroid application.
    AirDroid Application is a free app which you can download from the Play store. Once you download, just register a account in that. Launch the app on your phone and you will get a URL. Enter that URL name in your browser. Enter your login credentials. You will get a complete access to your phone. Using AirDroid application you can do following Tasks.

    • Read SMS or Send SMS from PC using the phone.
    • Manage your camera.
    • Manage contacts.
    • A complete file explorer through which you can view your files.
    • Install or uninstall apps.

    Micromax Driver/PC suite supported Devices

    Micromax do provide driver for its current set of smartphones running on Android OS. Though as i mentioned earlier, there is no official free Micromax Mobile PC suite. Having said that, installing the drivers for Micromax mobiles does the major tasks of PC suite. By installing Micromax drivers, you can tether Micromax Android phones, transfer files and even sync contacts using the third party PC suites. Below are the some of the devices compatible with Micromax Drivers and PC suite and follow above procedure.

    • Micromax A100 – PC Suite/Driver Free Download.
    • Micromax A110 – PC Suite/Driver Free Download.
    • Micromax A111 – PC Suite/Driver Free Download.
    • Micromax A115 – PC Suite/Driver Free Download.
    • Micromax A116 – PC Suite/Driver Free Download.
    • Micromax A25 – PC Suite/Driver Free Download.
    • Micromax A27 – PC Suite/Driver Free Download.
    • Micromax A30 – PC Suite/Driver Free Download.
    • Micromax A35 – PC Suite/Driver Free Download.
    • Micromax A44 – PC Suite/Driver Free Download.
    • Micromax A45 – PC Suite/Driver Free Download.
    • Micromax A50 – PC Suite/Driver Free Download.
    • Micromax A51 – PC Suite/Driver Free Download.
    • Micromax A54 – PC Suite/Driver Free Download.
    • Micromax A57 – PC Suite/Driver Free Download.
    • Micromax A62 – PC Suite/Driver Free Download.
    • Micromax A65 – PC Suite/Driver Free Download.
    • Micromax A68 – PC Suite/Driver Free Download.
    • Micromax A72 – PC Suite/Driver Free Download.
    • Micromax A80 – PC Suite/Driver Free Download.
    • Micromax A84 – PC Suite/Driver Free Download.
    • Micromax A87 – PC Suite/Driver Free Download.
    • Micromax A88 – PC Suite/Driver Free Download.
    • Micromax A89 – PC Suite/Driver Free Download.
    • Micromax A89 – PC Suite/Driver Free Download.
    • Micromax A90S – PC Suite/Driver Free Download.
    • Micromax A91 – PC Suite/Driver Free Download.
    • Micromax Asadas – PC Suite/Driver Free Download.
    • Micromax C115 – PC Suite/Driver Free Download.
    • Micromax C190 – PC Suite/Driver Free Download.
    • Micromax C260 – PC Suite/Driver Free Download.
    • Micromax E390 – PC Suite/Driver Free Download.
    • Micromax GC200 – PC Suite/Driver Free Download.
    • Micromax GC222 – PC Suite/Driver Free Download.
    • Micromax GC333 – PC Suite/Driver Free Download.
    • Micromax Q1C – PC Suite/Driver Free Download.
    • Micromax Q36 – PC Suite/Driver Free Download.
    • Micromax Q55 – PC Suite/Driver Free Download.
    • Micromax Q76 – PC Suite/Driver Free Download.
    • Micromax X099 – PC Suite/Driver Free Download.
    • Micromax X101 – PC Suite/Driver Free Download.
    • Micromax X103 – PC Suite/Driver Free Download.
    • Micromax X104 – PC Suite/Driver Free Download.
    • Micromax X104C – PC Suite/Driver Free Download.
    • Micromax X222 – PC Suite/Driver Free Download.
    • Micromax X234+ – PC Suite/Driver Free Download.
    • Micromax X234C – PC Suite/Driver Free Download.
    • Micromax X263 – PC Suite/Driver Free Download.
    • Micromax X268 – PC Suite/Driver Free Download.
    • Micromax X269 – PC Suite/Driver Free Download.
    • Micromax X272 – PC Suite/Driver Free Download.
    • Micromax X279 – PC Suite/Driver Free Download.
    • Micromax X286 – PC Suite/Driver Free Download.
    • Micromax X287 – PC Suite/Driver Free Download.
    • Micromax X293 – PC Suite/Driver Free Download.
    • Micromax X294 – PC Suite/Driver Free Download.
    • Micromax X295 – PC Suite/Driver Free Download.
    • Micromax X320 – PC Suite/Driver Free Download.
    • Micromax X321 – PC Suite/Driver Free Download.
    • Micromax X322 – PC Suite/Driver Free Download.
    • Micromax X322 – PC Suite/Driver Free Download.
    • Micromax X324 – PC Suite/Driver Free Download.
    • Micromax X325 – PC Suite/Driver Free Download.
    • Micromax X327 – PC Suite/Driver Free Download.
    • Micromax X335 – PC Suite/Driver Free Download.
    • Micromax X340 – PC Suite/Driver Free Download.
    • Micromax X350 – PC Suite/Driver Free Download.
    • Micromax X368 – PC Suite/Driver Free Download.
    • Micromax X396 – PC Suite/Driver Free Download.
    • Micromax X445 – PC Suite/Driver Free Download.
    • Micromax X446 – PC Suite/Driver Free Download.
    • Micromax X454 – PC Suite/Driver Free Download.
    • Micromax X455 – PC Suite/Driver Free Download.
    • Micromax X456 – PC Suite/Driver Free Download.

    If you are any issues in downloading the free Micromax Drivers feel free share it in the comment section.

  • Using Dynamic Named Formula in Excel

    It is a useful concept which saves you a lot of time when you are working with multiple formulas in bigger data range.  The Dynamic named Ranges means the range that isn’t fixed and it can be increased or decreased automatically as per the size of the data. This can be achieved using named ranges feature of Excel without using VBA macros. We will understand this better with a simple example.

    Using Named Formula Ranges in Excel

    Below is the sample data of a sales shop which continuously updates on daily basis.
    Excel Tips and Tricks Examples
    You want to create a name for the data in Column A without referring to empty cells. In simple words, reference to the Dateofpurchase changes every day as you add a new transaction.   In this scenario you can create a dynamic named formula that changes automatically as you enter new data or delete existing data.

    Steps to Create Dynamic Named Formula

    1. Goto Formulas->Defined names-Define Name to display the New Name Dialog box.
    2. Enter DateofPurchase in the Named Field.
    3. Enter the following formula in the  Refers to Field and Click Ok to Close Name Dialog box.

    =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A),1)

    Dynamic Named Formula Creation
    The above step creates a named Formula that uses the excel OFFSET and COUNTA functions to return a range that changes based on the number of non empty cells in column A.To test this let us use a simple COUNTA function

    =COUNTA(Date_Of_Purchase)  

    As you can see, the value changes when you add a new transaction or delete a transaction. This is very useful when you work on large data. Because it uses dynamic memeory allocation, it increases the calculation speed of the formulas. You can see actual difference when you use this with multiple VLOOKUP formula on a large Data range.
    Note:
    The Above shown method works only when you have non empty data range. That is, the range should not contain blanks in between.

  • Handling Error Displays in Excel Formulas

    Sometimes when we use a formula in an Excel worksheet it returns error values such as #N/A, #REF! or #DIV/0!. In some situations we want to know whether the formula returns error values. In some scenarios we do not want to show error values. For example when we create a templates in excel with VLOOKUP, then there will be a error values. To make it look neat, removing error values is an good idea.

    To hide or not to display error values, there primary ISERROR function with IF or direct IFERROR function in Excel 2007 or later will be useful. So let us see simple example so that, you will understand better.

    Different Excel Formulas to Hide Error Values

    Below is the sample data and based on this table we will try different ways to hide error messages.

    IF and ISERROR examples
    In the above data, Column D calculates the average price of the products. For this we have used =B2/C2 formula.
    Method 1: Using ISERROR Function with IF condition 
    As you can see from the above table, the formula returns an error if the cells used in the calculation are empty. If you want to hide that error value then use IF function to check an error value using along with ISERROR function. Then the formula becomes
    =if(error(B2/C2),””,B2/C2)
    How it works:
    ISERROR function retunrs true if the argument evaluates to an error.  Then IF function retunrs an empty string otherwise IF function returns the calculated value. You can use this logic with any formula which returns error value such as division, VLOOKUP in Excel etc.
    Using the IFERROR Function
    This formula does the same thing as above. But here it it formula evaluates only once.  This will help you to make your worksheet faster.
    The Formula becomes as below.
    =IFERROR(B2/C2,””)
    Do note that, IFERROR function is first introduced in Excel 2007. So previous versions of excel do not support this function.

  • Steps to Fix Windows 8 Booting Issue after Installing Ubuntu Or Vice Versa

    Today to troubleshoot battery not charging issue due to over heating on my Dell laptop running on Windows 8, I have decided to load the Ubuntu OS onto my system. Ubuntu is known as one of the best free Linux operating system available today. I have downloaded the Ubuntu and installed in a new partition on my hard disk. It got installed properly without any issues. I was able to boot and work on Ubuntu OS. But when I restarted my PC, Windows 8 is not loading! However I was able to boot on Ubuntu. I am new to Ubuntu eco system, so I did research on forums to fixing this problem. My Windows 8 partition is intact and the only problem is, GRUB is not working as expected. After a some 8 to 10 minutes of research on forums, I got a very simple and quick solution to it. So I am sharing the same solution to you which worked for me.

    Steps to Fix Windows 8 Booting Issue after Installing Ubuntu

    Fixing Boot Issues of Windows 8
    Boot-Repair Tool
    To Fix this, there is a simple program called Boot-Repair. It is a small and very useful tool to fix issues such as, you can’t boot Ubuntu after installing Windows or another Linux distribution, or when you can’t boot Windows after installing Ubuntu, or when GRUB is not displayed anymore, some upgrade breaks GRUB, etc.  Below are the steps to fix the boot loader. Ensure you are connected to the Internet before starting below steps.
    1. First you need to install the Boot-Repair Tool. To do this, first open Terminal by pressing Keyboard shortcut Ctrl + ALT + T. In the terminal enter the code given below. (You can copy and paste the code in Terminal. To do so, just copy the codes given below and go to the Terminal, right click on the mouse and select Paste. The Ctrl+V shortcut doesn’t work in Terminal..)

      sudo add-apt-repository ppa:yannubuntu/boot-repair && sudo apt-get update

    It will ask for your admin password. Enter it. It will download all the required repositories. Once it completes , enter the below code in the Terminal.

    sudo apt-get install -y boot-repair && (boot-repair &) 

    2. It will finish installing the Boot-Repair tool.
    3.Launch ‘Boot-repair’ by typing ‘boot-repair‘ in a terminal
    4.Then click the “Recommended repair” button. It will take some time to repair. Once the repair is finished, note the URL (paste.ubuntu.com/XXXXX) that appeared in a paper, then reboot. My problem is resolved at this stage.
    5. If you still face issue then, indicate the URL which you have noted down to people who help you by email or forum which is provided in the last screen of the repair process.

    Steps to Fix Ubuntu Booting Issue after Installing Windows 8

    This one I have not tried. However, I am just quoting the solution provided in the forum. Here  I assume that you have installed Ubuntu first and then installed Windows 8. Now you cannot boot on to Ubuntu. In this case, first boot your computer on a Ubuntu live-CD or live-USB.Then follow the same procedure mentioned above. It updates GRUB and you will be able to access Ubuntu.