Innovative Technology

Hi Friends Today we are going to learn about how to count unique value in excel  # 1 First we need to Catch Unique value in excel lets see the Excel table below for catch the unique value Follow the step one by one First, Select the work area of the column then select Data - >  Advanced -> Select the Step 3-> Then press Unique record Only then press ok Result Output  Then count the Unique Value simple Formula  =COUNTIF(B2:B30,D2) Thanks  By VASU

1. How Create Table using  Short cut key Press like that "+--+-----+---+" Press Enter 2. Create Line A . Press "----------" key Then Press Enter   with out Bold B. Press "shirt + ______" Key Then Press Enter with Bold Line C. Press "=======" Key then Press Enter  D. Press Hash Key "##########" Then Press Enter  E. Press Star Key "******" Then Press Enter  F. Press "`````````````````````````" Then Press Enter  3.How to create Right Arrow  A. Press two Equal Key  " == "+ ">" Then Press Enter  B. Press two Equal Key   "<"+" == "   Then Press Enter  C. Press two "  --> " Then Press Enter D. Press " <---" Then Press enter                              E. Press "<=>" Then Press Enter  F . Press " :) "," :( ", ":| ...

1. Anti Gravity http://antigravitygoogle.com/ Type google search bar " Anti Gravity  " 2.Sphere the google web site http://mrdoob.com/projects/chromeexperiments/google-sphere/ 3.No internet connection play the Game  Press Space bar 4.do a barrel roll Type google search bar " do a barrel roll " press enter 5. No Gravity Google http://mrdoob.com/projects/chromeexperiments/google-gravity/ 6. Pac Man Google Doodle Type in google search bar : "Pac Man Google Doodle" 7.  Zerg rush it's Game. Type in Google Search Bar  : "Zerg Ruch" 8. Google Guitar http://elgoog.im/guitar/ 9.Google Underwater http://elgoog.im/underwater/ 10.google snake http://elgoog.im/snake/ Thanks By VASU

Telegram  Vs  WhatsApp  S.No Telegram WhatsApp 1 Telegram was found by the  Russian  entrepreneur Owner by Face book 2  messages -T ext , Image, Voice, videos Any type ,Files  and voice calls M essages , T ext , Image, Voice, videos Any type ,Files and voice calls, as well as video calls 3 Videos file size : Maximum up  to 1.5 GB videos File size : Maximum up  to 67 MB 4 Secret chats - Automatic Destroyed No - Secret chats 5 Group Members : 75000 Group Member  : 257 6 Cloud Based messages - Telegram cloud messages and media remain on the servers at least until deleted by all participants. No Cloud Based messages 7 Feature - Bots, Channels, Stickers, Drafts, Secret chats, Voice calls Feature - Groups, Broad cast. Video Call, Voice call 8 Platform : Android, iOS, Windows Phone, Win...

Excel Super short cuts   1.The string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.  =PROPER(A1) 2.The string that you wish to convert to uppercase. =UPPER(A1) 3.Use  CONCATENATE , one of the  text functions , to join two or more text strings into one string.   =CONCATENATE(A3,B3) 4. Delete blank space in excel  5. The  Format Painter  copies  formatting  from one place and applies it to another.

hi Friends today we discuss about how to convert web page to PDF file format. We need Chrome Browser  for this Technique. Open the chrome Browser  Search your need  Short cut key "Ctrl + P " or right click the Mouse -> press print "Option"  click the left side button " change "  Select the "Save as PDF" Option Finally click the save button to save "PDF format "                                     Thanks By VASU