Friday, 1 August 2014

Pivot Table in Excel

Pivot Table in Excel:

Pivot Table in Excel

Select whole table and Go-to insert tab and click on pivot table. 

Drag and drop column accordingly.

On pivot table you are able to Filter and conditional formatting and chart also.
Read More
Posted on 8:00:00 am

Index formula in excel

Index Formula:

index formula in excel

Array: is a range of cells or an array constant.

    If array contains only one row or column, the corresponding row_num or column_num argument is optional.
    If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array.

Row_num : Selects the row in array from which to return a value. If row_num is omitted, column_num is required.

Column_num : Selects the column in array from which to return a value. If column_num is omitted, row_num is required.

Read More
Posted on 8:00:00 am

index match formula in excel

index match formula in excel:

index match formula in excel

If there is a different scenario in vlookup.

Primary key column is on right side vlookup are unable to fetch data. so here we use index match combined to get resultant data.
Read More
Posted on 7:05:00 am

Match Formula in Excel

 Match Formula in Excel:

 Match Formula in Excel

 MATCH(lookup_value, lookup_array, [match_type])

    lookup_value : Required. The value that you want to match in lookup_array. For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.

The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.

    lookup_array:  Required. The range of cells being searched.
    match_type:  Optional. The number -1, 0, or 1. The match_type argument specifies how Excel matches lookup_value with values in lookup_array. The default value for this argument is 1.
Read More
Posted on 7:03:00 am

Wednesday, 30 July 2014

Top five best free antivirus and internet security 2015

Top five best free antivirus and internet security:

Top five best free antivirus and internet security

Antivirus is very important software for PC/Laptop/Mobile/Tablets including both personnel and business purpose.
Generally people have brought free antivirus best alternative for those who don’t want to pay for Antivirus but still wants good and effective solution.Here are the list of free best antivirus which is widely used now a days.

Choose as per your interest.

Free Avast Antivirus:

Avast is most widely used antivirus. It's audio detection feature is very good that is "Caution! virus has been detected ". Boot time scan is very attractive feature.Best free antivirus protection against dangerous viruses, worms, Trojans and spyware.

Free Avg Anitvirus:-

AVG is also very effective antivirus available free of cost.

Free Avira 2014 Antivirus:-

Avira is also counted as trusted brand in the list of antivirus. It's interface and size is very simple and easy to use. Avira removes malware and protects your system against the latest strains of viruses, worms, Trojans and more and keeps your PC clean. It provide regular update of definition.

Free Microsoft Security Essentials :-

 Its also preferred by many users due to its simplicity and effectiveness.It protect your computer devices against viruses, spyware, and other malicious software.

Panda Cloud Antivirus Free Edition

Panda is heavy antivirus.It provides real-time protection against viruses, spyware, adware, rootkits.

Read more about technology 
Read More:
Lava Iris X-8 best price smartphone
Lenova A 6000 plus & Lenova 7000
Earn Money Online
5 Best Foods for Stronger Bones
The Best Juice Drink
Some treatment for Mouth Blister

Read More
Posted on 1:45:00 pm
Categories: ,

Tuesday, 29 July 2014

HP Pavilion 15-n201ax Laptop

HP Pavilion 15-n201ax Laptop:(Rs. 42,091) If you are hungry for latest technology grab this product. Hp Pavillion 15-n201ax laptop is best laptop for gaming with 2GB graphics card and 2GHz clock speed. Super fast speed having 8GB Ram and Hard disk capacity of 1TB means huge space for movies.

HD display with resolution of 1366x768 pixel. It comes with APU Quard Core A10 processor and window 8.1 inbuilt.Light weight 2.28 Kg overall.
More attractive features:
· Screen Size 15.6 inch
· Read/Write Speed 8x
· Hardware Interface SATA
· Expandable Memory Upto 8 GB
· Cache 4 MB
· Sound Dual Speakers, DTS Sound+
Reviews: Best laptop for business/personnel and students purpose. HP is most trusted brand of laptop and provide manufacture warranty . Read Terms before buying!!

Read More
Posted on 12:29:00 pm
Categories: , ,

Monday, 28 July 2014

Microsoft Word shortcut keys

Microsoft Word shortcut keys:Microsoft Word shortcut keys

Microsoft world 2007/10/12 shortcuts keys for keyboard. Shortcuts are very helpful to work faster with Ms office word. Take a look and try some shortcuts

Key Board Shortcut Details
Ctrl + 0 Adds or removes 6pts of spacing before a paragraph.
Ctrl + 1 Single-space lines.
Ctrl + 2 Double-space lines.
Ctrl + 5 1.5-line spacing.
Ctrl + A Select all contents of the page.
Ctrl + B Bold highlighted selection.
Ctrl + C Copy selected text.
Ctrl + D Open the font preferences window.
Ctrl + E Aligns the line or selected text to the center of the screen.
Ctrl + F Open find box.
Ctrl + I Italic highlighted selection.
Ctrl + J Aligns the selected text or line to justify the screen.
Ctrl + K Insert link.
Ctrl + L Aligns the line or selected text to the left of the screen.
Ctrl + M Indent the paragraph.
Ctrl + P Open the print window.
Ctrl + R Aligns the line or selected text to the right of the screen.
Ctrl + S Save the open document. Just like Shift + F12.
Ctrl + T Create a hanging indent.
Ctrl + U Underline highlighted selection.
Ctrl + V Paste.
Ctrl + X Cut selected text.
Ctrl + Y Redo the last action performed.
Ctrl + Z Undo last action.
Ctrl + Shift + L Quickly create a bullet point.
Ctrl + Shift + F Change the font.
Ctrl + Shift + > Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ] Increase selected font +1pts.
Ctrl + Shift + < Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [ Decrease selected font -1pts.
Ctrl + / + c Insert a cent sign (¢).
Ctrl + Shift + * View or hide non printing characters.
Ctrl + <left arrow> Moves one word to the left.
Ctrl + <right arrow> Moves one word to the right.
Ctrl + <up arrow> Moves to the beginning of the line or paragraph.
Ctrl + <down arrow> Moves to the end of the paragraph.
Ctrl + Del Deletes word to right of cursor.
Ctrl + Backspace Deletes word to left of cursor.
Ctrl + End Moves the cursor to the end of the document.
Ctrl + Home Moves the cursor to the beginning of the document.
Ctrl + Spacebar Reset highlighted text to the default font.
Ctrl + Alt + 1 Changes text to heading 1.
Ctrl + Alt + 2 Changes text to heading 2.
Ctrl + Alt + 3 Changes text to heading 3.
Alt + Ctrl + F2 Open new document.
Ctrl + F1 Open the Task Pane.
Ctrl + F2 Display the print preview.
Ctrl + Shift + > Increases the highlighted text size by one.
Ctrl + Shift + < Decreases the highlighted text size by one.
Ctrl + Shift + F6 Opens to another open Microsoft Word document.
Ctrl + Shift + F12 Prints the document.
F1 Open Help.
F4 Repeat the last action performed (Word 2000+)
F5 Open the find, replace, and go to window in Microsoft Word.
F7 Spellcheck and grammar check selected text or document.
F12 Save as.
Shift + F3 Change case from lower upper and sentence case
Shift + F7 Runs a Thesaurus check on the word highlighted.
Shift + F12 Save the open document. Same as Ctrl + S.
Shift + Enter Create a soft break instead of a new paragraph.
Shift + Insert Paste.
Shift + Alt + D Insert the current date.
Shift + Alt + T Insert the current time.
Read More
Posted on 3:25:00 pm
Categories: ,

Sunday, 27 July 2014


MOTO X (2nd generation):


  • Android v4.4.4 (KitKat) OS
  • 2 MP Secondary Camera
  • 2 GB RAM
  • Dual Ring LED Flash
  • 2.5 GHz Qualcomm Snapdragon 801 MSM8974-AC Quad Core Processor
  • 5.2-inch Capacitive Touchscreen
  • 13 MP Primary Camera 

MOTO G(2nd generation) : Price down

  • 1 GB RAM 
  • Dual Sim (GSM + GSM) 
  • 1.2 Ghz Qualcomm Quad Core Processor 
  • 5-inch HD Screen 
  • Expandable Upto 32GB 
  • Android v4.4.4 (KitKat) OS 
  • 8 MP Primary Camera and 2 MP Secondary Camera

Read More
Posted on 12:58:00 pm
Categories: ,

Friday, 25 July 2014

Jolla will sell its Sailfish OS smartphone in India within the next month

Jolla will sell its Sailfish OS smartphone in India within the next month:

Jolla will sell its Sailfish OS smartphone in India within the next month

Smart phone market in India is growing rapidly.“India is the rising smartphone market of the world"Jolla deals with Snapdeals to sell their smartphone with Sailfish OS in India from next month.

This smart phone has following features:
  • Display-4.5-inch IPS qHD(540x960p) .
  •  1.4GHz Qualcomm Snapdragon dual-core processor .
  •  1GB of RAM
  • 16GB storage expandable via microSD card. 
  •  2100mAh battery.
  •  8MP rear camera alongside an LED flash.
  •  2MP front-facing camera as well.
  • One of the USPs of the phone is changeable 'The Other Half' smart covers that also change the phone's user interface theme. 
It runs Sailfish OS, which is based on MeeGo, the same OS that was last seen on Nokia's N9 smartphone. In fact, Jolla was founded by a group of ex-Nokia employees who were involved with the development of MeeGo based devices at the company. Lets see what happened.

Read More
Posted on 2:29:00 pm
Categories: ,

Magic of V-Lookup

Magic of V-lookup:Magic of V-Lookup

Solution of following questions.
  • How to use vlookup

  • Working of Vlookup?

  • Introduction to vlookup?

As the name implies, V-Lookup, stands for Vertical Lookup, which is used to find specific information column wise vertically that has been stored in excel sheet.

Let’s study the Formula/Syntax of V-lookup function. It consists of four parts.

Lookup_value - This is the index which we have to search in the table.

Table_array, col_index_num - This is table array in which we search the look up value . This argument is a named range or a reference to a range of cells. Here, in above our table range is cell H2 to J7.

Col_index_num- Enter the column number of the table_array from which you want data returned from means which data you want to print as result. In above example, column index is 2 since value of name is 2nd position.

  A logical value (TRUE 1 or FALSE 0 only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value.

    If TRUE(1) or if this argument is omitted, VLOOKUP will use an approximate match if it cannot find an exact match to the lookup_value. If an exact match is not found, VLOOKUP uses the next largest lookup_value.
    If FALSE(0), VLOOKUP will only use an exact match to the lookup_value. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, an #N/A error is returned.
Read More
Posted on 12:00:00 am
Categories: ,

Thursday, 24 July 2014

Learn java script.

Calculate n^n using java script.

Learn java script.
Program 1: 

var a = parseInt(prompt("Enter your number"));

 var b = a;

 var i;

 for (i = 0; i <= b; i++)


a = a * b;  

 a = a / (b * b);  

alert("the number is: " + a);
var a = prompt("Enter value for Table:"); 
var i; 
for (i = 1; i <= 10; i++) 

c = i * a; 

Print Table in javascript:

Program 2:

var a = prompt("Enter value for Table:");  

var i; for (i = 1; i <= 10; i++) 


c = i * a; alert(c); 


Read More
Posted on 12:50:00 pm

BUY MI3 Rs. 13999

  BUY MI3 (METALLIC GREY) :Rs. 13999

Flip kart site is down due to technical issue after selling is started from 22 July 2014.
Mi3 is stock out on flipkart after 39 minutes, may be available soon on flip-kart. Click on buy now button to check availability of Mi3. Mi3 smartphone has many attractive features. some of them as follows take a look.
  1. 5-inch LCD Capacitive Touchscreen 
  2. Full HD Recording 
  3. Wi-Fi Enabled 
  4. 13 MP Primary Camera 
  5. 2.3 GHz Qualcomm Snapdragon 800 8274AB Quad Core Processor 
  6. 2 MP Secondary Camera 
  7. Android v4.4.2 OS 
  8. Internal Storage Capacity of 16 GB

This product is Permanently discontinued.

Read More
Posted on 7:55:00 am
Categories: , ,

Wednesday, 23 July 2014

Amazon Fire Phone, 32GB (AT&T)

Amazon Fire Phone, 32GB (AT&T): $0.00 – $649.00:

Amazon Fire Phone, 32GB (AT&T)

Amazon launched its first smart phone with attractive features.

  1.     A 2.2 GHz quad-core Snapdragon 800 processor.
  2.     2GB of RAM.
  3.     4.7" HD LCD display, with 1280 x 720 resolution.
  4.     13MP camera.
  5.     Fire phone records in 1080p at 30 fps from both front and rear-facing cameras.
  6.     Adreno 330 graphics processor.
  7.     Battery size: 2400mAh ,Fire phone delivers up to 285 hours of standby time, up to 22 hours of talk time, up to 65 hours of audio playback, and up to 11 hours of video playback.
  8.     Fire OS 3.5.
  9.     32 GB or 64 GB external

Read More
Posted on 12:13:00 pm
Categories: , ,

Hide folder in windows without using software.

Open notepad copy the below code and save file as "tanuj.bat"

Hide folder in windows without using software.

title Folder tanuj
if EXIST “Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}” goto UNLOCK
if NOT EXIST tanuj goto MDLOCKER
echo Are you sure u want to Lock the folder(Y/N)
set/p “cho=>”
if %cho%==Y goto LOCK
if %cho%==y goto LOCK
if %cho%==n goto END
if %cho%==N goto END
echo Invalid choice.
ren tanuj “Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}”
attrib +h +s “Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}”
echo Folder locked
goto End

echo Enter password to Unlock folder
set/p “pass=>”
if NOT %pass%==password goto FAIL
attrib -h -s “Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}”
ren “Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}” tanuj
echo Folder Unlocked successfully
goto End
echo Invalid password
goto end
md tanuj
echo tanuj created successfully
goto End
You may use .bat to .exe converter to protect your password.
Read More
Posted on 2:30:00 am
Categories: ,

Tuesday, 22 July 2014

Find Prime No. Using Java Script

Find Prime No. Using Java Script

Find Prime No. Using Java Script

Java script has  very simple code for browser. Generally java script is used to restrict user. But you can learn java script by playing with coding.


var num =prompt("Enter a number");
parseInt(num);var i;var b=0; if(num==1)
alert("A prime number is a number which has only two factors, 1, and itself. But in the case of 1, there is only one factor: 1. So, 1 is not a prime number");
var result = num%i;
} }
alert("Prime no.");
alert("Not Prime");

Read More
Posted on 12:46:00 pm

MobiKwik offer

MobiKwik offer (online recharge offers/cash back shopping site):

Mobikwik is online recharge site, which provide best cash back on online recharges.
Here we are discussing some best offer and their details.
MobiKwik Offer -1
Rs. 10 cashback on adding a minimum amount of Rs. 100 in  your MobiKwik wallet.
Terms and Conditions
       This offer is valid across all platforms, including on website and can be redeemed only once(for new user). 
  Add Rs 100 to your MobiKwik wallet first before applying coupon code.
Coupon Code: MOBIOOM

MobiKwik offer-2
What you get: 10% discount on all purchases made on when you pay using MobiKwik wallet at the time of checkout.
Coupon Code: MOBIKWIK01

MobiKwik offer-3

MobiKwik recently launched an offer for Windows Phone users. Get  Rs. 60 cashback on adding a minimum of Rs. 100 to your MobiKwik wallet.
How to avail it?
·         First you have to Download MobiKwik app from the Windows store.
·         Add Rs 100 to your Mobikwik wallet.
·         Apply the Promo Code: MOBIWP to get an instant cashback of Rs. 60!
Read More
Posted on 8:35:00 am

Top 5 expensive car in the world

Top 5 expensive/Great car in the world:

When we talking about technology the first world comes in mind is Smart phones, but when live technology is only found in cars. Here are some most expensive cars are listed.

These are the extremely example of technology power and style.

1. Lamborghini Veneno $4M:-

The first world comes to see the image is WOW!!
You are absolutely right here because, its live example of style speed and technology."It's awesome".

Lamborghini Veneno $4M:-


2.W Motors Lykan Hypersport $3.4M:

Lykan Hypersport is the first sports car from Lebanon manufactured by W Motors. 
The highest speed that can be touched using this car is 245 miles per hour. It can accelerate from 0 to 100 Km/h in under 3 seconds. 

W Motors Lykan Hypersport $3.4M

3.Koenigsegg One:1. $2.0M:

This Sports car is the perfect example of look,style,design and beauty of vehicle.

4.Lamborghini Reventon $1.61M:

This one is also the great car . See its looks and speed. It come with unforgettable look.

Impact of Social Media Technology
Cyber Crime

Read More
Posted on 1:30:00 am
Categories: ,