Author: Aniruddh

  • Free Space by deleting the Windows Old files

    If you have installed newer version of Windows or reinstalled the your windows without formatting the drive, then you will notice a folder called Windows.old. This folder contains the files of your previous Windows files. It is very difficult to remove this folder manually. However you can use Windows built in feature called Disc cleanup to remove this folder. Ideally Windows.old folder is not required as it will be transferred to your newer version of Windows. Having said that, have a quick check on this and confirm that you have the data in your required place.
    Windows Disc Cleanup utility is also useful for removing temporary files,files in Recycle Bin etc . This will free up your hard disc drive. This will be very useful when you start getting notification on disc full.

    Steps to Clean up Windows.Old folder to free the space

    1. Go to ‘my computer’ by clicking desktop icon or by start menu. If you  are using Windows 8, then use Windows+E shortcut key to get My computer. 
    2. Right click on the drive where you have installed Windows.
    3. Click on properties from the menu list.
    4. In the General Tab, you will find a icon called Disc cleanup. Click on that.
    Disc Cleanup windows
    Disc cleanup

    5. Click on Clean Up System files.

    Windows drive cleaning
    Disc Cleanup menu

    6. The new Pop up menu comes out. In that select the Previous Windows Installation,Temporary Windows Installation files checkbox. You can even select Windows Update cleanup and Windows Upgrade Log files.
    7. Click on Ok to start clean up your temporary data.
    8.  It will take few seconds and the Windows.old folder is removed from your disc.

  • 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.