Wednesday 30 September 2015

100+ UseFul cmd Command

Here, I'm sharing a list of some useful commands for windows command prompt. Few commands may work only on windows XP not on Windows 7/Vista.
1.Add Hardware Wizard - hdwwiz.cpl
2. Add/Remove Programs - appwiz.cpl
3. Administrative Tools - control admintools
4. Bluetooth Transfer Wizard - fsquirt
5. Calculator - calc
6. Certificate Manager - certmgr.msc
7. Character Map - charmap
8. Check Disk Utility - chkdsk
9. Clipboard Viewer - clipbrd
10. Command Prompt - cmd
11. Component Services - dcomcnfg
12. Computer Management - compmgmt.msc
13. Control Panel - control
14. Date and Time Properties - timedate.cpl
15. DDE Shares - ddeshare
16. Device Manager - devmgmt.msc
17.Direct X Troubleshooter - dxdiag
18. Disk Cleanup Utility - cleanmgr
19. Disk Defragment - dfrg.msc
20. Disk Management - diskmgmt.msc
21. Disk Partition Manager - diskpart
22. Display Properties - control desktop
23. Display Properties - desk.cpl
24. Dr. Watson System Troubleshooting Utility - drwtsn32
25. Driver Verifier Utility - verifier
26. Event Viewer - eventvwr.msc
27. Files and Settings Transfer Tool - migwiz
28. File Signature Verification Tool - sigverif
29. Findfast - findfast.cpl
30. Firefox - firefox
31. Folders Properties - control folders
32. Fonts - control fonts
33. Fonts Folder - fonts
34. Free Cell Card Game - freecell
35. Game Controllers - joy.cpl
36. Group Policy Editor (for xp professional) - gpedit.msc
37. Hearts Card Game - mshearts
38. Help and Support - helpctr
39. HyperTerminal - hypertrm
40. Iexpress Wizard - iexpress
41. Indexing Service - ciadv.msc
42. Internet Connection Wizard - icwconn1
43. Internet Explorer - iexplore
44. Internet Properties - inetcpl.cpl
45. Keyboard Properties - control keyboard
46. Local Security Settings - secpol.msc
47. Local Users and Groups - lusrmgr.msc
48. Logs You Out Of Windows - logoff
49. Malicious Software Removal Tool - mrt
50. Microsoft Chat - winchat
51. Microsoft Movie Maker - moviemk
52. Microsoft Paint - mspaint
53. Microsoft Syncronization Tool - mobsync
54. Minesweeper Game - winmine
55. Mouse Properties - control mouse
56. Mouse Properties - main.cpl
57. Netmeeting - conf
58. Network Connections - control netconnections
59. Network Connections - ncpa.cpl
60. Network Setup Wizard - netsetup.cpl
61. Notepad - notepad
62. Object Packager - packager
63. ODBC Data Source Administrator - odbccp32.cpl
64. On Screen Keyboard - osk
65. Outlook Express - msimn
66. Paint - pbrush
67. Password Properties - password.cpl
68. Performance Monitor - perfmon.msc
69. Performance Monitor - perfmon
70. Phone and Modem Options - telephon.cpl
71. Phone Dialer - dialer
72. Pinball Game - pinball
73. Power Configuration - powercfg.cpl
74. Printers and Faxes - control printers
75. Printers Folder - printers
76. Regional Settings - intl.cpl
77. Registry Editor - regedit
78. Registry Editor - regedit32
79. Remote Access Phonebook - rasphone
80. Remote Desktop - mstsc
81. Removable Storage - ntmsmgr.msc
82. Removable Storage Operator Requests - ntmsoprq.msc
83. Resultant Set of Policy (for xp professional) - rsop.msc
84. Scanners and Cameras - sticpl.cpl
85. Scheduled Tasks - control schedtasks
86. Security Center - wscui.cpl
87. Services - services.msc
88. Shared Folders - fsmgmt.msc
89. Shuts Down Windows - shutdown
90. Sounds and Audio - mmsys.cpl
91. Spider Solitare Card Game - spider
92. SQL Client Configuration - cliconfg
93. System Configuration Editor - sysedit
94. System Configuration Utility - msconfig
95. System Information - msinfo32
96. System Properties - sysdm.cpl
97. Task Manager - taskmgr
98. TCP Tester - tcptest
99. Telnet Client - telnet
100. User Account Management - nusrmgr.cpl
101. Utility Manager - utilman
102. Windows Address Book - wab
103. Windows Address Book Import Utility - wabmig
104. Windows Explorer - explorer Keep Learning. Keep Rocking. & Keep Visiting :)

How Can I Get All My Deleted WhatsApp Messages Back?

To Recover Recent Chat Messages
You can recover almost everything which is below 7 days old in WhatsApp. In fact, it is amazingly simple. All you have to uninstall WhatsApp and install it again. A backup is automatically created by WhatsApp daily at 4 am. The application stores that data in your phone’s external memory i.e. your SD card. When you reinstall WhatsApp, it will prompt you to restore your messages back. All you have to tap ‘Restore’ button and get all your messages back.
To Recover Messages Older than 7 Days
It is quite more complex to recover older messages in this application. But it is still possible to get them back. You can do it in two ways – first is manual method and next one is using a third party software.
Manual Recovery
*. Go to the ‘Databases’ folder of your memory card – go through Memory Card – WhatsApp – Databases. In this folder, you will find different chat files named something like “msgstore-date format.db.crypt”. The date format must be YYYY-MM-DD.
*.First of all, you have to rename that msgstore file. Give it name “Old” or something which is related to filename.
*.Then review all the files located below. These files must be named in different dates. Choose your desired files and get the one deleted by you by mistake and then rename it back with older file name.
*.Get back to main screen. Delete and reinstall the application. When installed, it will prompt you to restore files, tap the option and your desired file will be restored and saved as “msgstore.db.crypt”.
*.Remember that your recent chat history shall be removed when you restore the older file. You cannot merge the recent chat messages with recovered, earlier chat files. You have to repeat the process again to get your recent messages back and it will again delete old one and place a new file.
*.Second Option – Third Party Tool
This option is a lot faster than previous one. All you have to use any free-to-use software. With this service, you can find all the contents of WhatsApp databases and extract all your desired messages. All you have to choose your desired messages from your memory card on your Smartphone and click Scan button. The scan process may consume several minutes according to your file size. When scanning is done, click ‘Recovered Registers’ and read all your chat messages.

Tuesday 29 September 2015

How to access multiple Gmail accounts in same browser

*.First loginto your gmail account
*.After logging in Open:- Account Setting (From sub-menu you get clicking on image on Right top )
*.Now click onAccount Overview
*.then inSecuritysection ClickEdit inMultiple Sign-inoption
*. Now selectOnandtick all three check boxesand click onSave
*. Nowsignoutfrom your gmail account andloginagain.
*.And click on Your Google Profile Image (right top) and click onSwitch Profile
*.Now click on:-Sign in to another account
*. Now simply log in to your second gmail account
*. Now you have added two mail id’s to your gmail account to switch your account just Click on Switch account by clicking on your mail id on top right and then select one you want to access.
Note:- this trick will only work for gmail account .. it will not work on other Google accounts like blogger, adsense , picasa .

Use Kaspersky internet security 2012 Lifetime without license key:-

*.First of all disconnect your internet connection and Remove modem or Disconnect that Ethernet Cable. it is very necessary that to get lifetime Key of Kasper sky internet security 2012 .(copy this post and save it to notepad)
*.Delete the existing key (If You Have)
*. Now Open Kaspersky 2012 product Then Click on (Either KIS or KAV) settings
*.Un-check the “Enable protection” Check box
*.Go Then “Options’ In the settings window itself , And uncheck Below Line
*.a) “Enable Self-Defense”
*.”Disable External service control”
*. Goto Start>Run>Type “regedit”>
Now enter then find
HKEY_LOCAL_MACHINE>SOFTWARE>KasperskyLab>environment.
From Right list >> double click on “ProductStatus”
Then , in the “Value Data” Field . replace “Released” with “Beta” and click OK
*.Now again Open Kaspersky 2012 product And Go settings Now Check Below these check boxes :-
*.i)”Enable protection” (In “Protection” sub menu)
*.ii)”Enable Self-Defense” (In “Options” sub menu)
*.iii)”Disable External service control” (In “Options” sub menu)
*.Click on “OK”
*.Close the error message saying that “Protection is not running” .
Couse ot Error massage that, you have not installed any key and the product is not registered also
*. Restart your PC !
NOTE:- You must Restart your PC Other then it will not work properly
Now , after restart , Open Your Kaspersky product .
Then click On License” (Somewhat in the middle in the bottom)
Click on “Activate new license”
then click on “Activate Beta License”
then click on “Next”
From Now You will Not Blacklist you will get 30 Days Genuine Key .Just click on Activate beta license and click on .Next . That’s it The kaspersky server will give u an new 30 days genuine key . So Enjoy!!!

Monday 28 September 2015

How to enable hibernate option in windows 10

1. Open the Control Panel (icons view), and click/tap on the Power Options icon. Or just type down “Power Options” in CORTANA searchbox and click on “Power Options”.
2.
Click on the “Choose what the power buttons do” link on the left hand menu.
3.
Click on the “Change settings that are currently unavailable” link at the top.
4.
If prompted by UAC, click/tap on Yes.
5.
Enable or Disable
To Enable Hibernate:
a) Check the “Hibernate” box under Shutdown settings, and click/tap on Save changes.
To Disable Hibernate:
a) Uncheck the Hibernate box under Shutdown settings, and click/tap on Save changes.

Friday 18 September 2015

Excel Formulas You Should Definitely Know:

1. SUM
Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)
The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. You can use cell references as well in this formula.
The above shows you different examples. You can have numbers in there separated by commas and it will add them together for you, you can have cell references and as long as there are numbers in those cells it will add them together for you, or you can have a range of cells with a colon in between the 2 cells, and it will add the numbers in all the cells in the range.
2. COUNT
Formula: =COUNT(A1:A10)
The count formula counts the number of cells in a range that have numbers in them.
This formula only works with numbers though:
It only counts the cells where there are numbers.
**Learn more about the COUNT function in this on-demand, online course. FREE preview**
3. COUNTA
Formula: =COUNTA(A1:A10)
Counts the number of non-empty cells in a range. It will count cells that have numbers and/or any other characters in them.
The COUNTA Formula works with all data types.
It counts the number of non-empty cells no matter the data type.
4. LEN
Formula: =LEN(A1)
The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.
Notice the difference in the formula results: 10 characters without spaces in between the words, 12 with spaces between the words.
5. TRIM
Formula: =TRIM(A1)
Gets rid of any space in a cell, except for single spaces between words. I’ve found this formula to be extremely useful because I’ve often run into situations where you pull data from a database and for some reason extra spaces are put in behind or in front of legitimate data. This can wreak havoc if you are trying to compare using IF statements or VLOOKUP’s.
I added in an extra space behind “I Love Excel”. The TRIM formula removes that extra space. Check out the character count difference with and without the TRIM formula.
6. RIGHT, LEFT, MID
Formulas: = RIGHT(text, number of characters), =LEFT(text, number of characters), =MID(text, start number, number of characters).
(Note: In all of these formulas, wherever it says “text” you can use a cell reference as well)
These formulas return the specified number of characters from a text string.RIGHT gives you thenumber of characters from the right of the text string, LEFT gives you the number of characters from the left, and MID gives you the specified number of characters from the middle of the word. You tell the MID formula where to start with the start_number and then it grabs the specified number of characters to the right of the start_number.
I used the LEFT formula to get the first word. I had itlookin cell A1 and grab only the 1st character from the left. This gave us the word “I” from “I love Excel”
I used the MID formula to get the middle word. I had itlookin cell A1, start at character 3, and grab 5 characters after that. This gives us just the word “love” from “I love Excel”
I used the RIGHT formula to get the last word. I had itlookat cell A1 and grab the first 6 characters from the right. This gives us “Excel” from “I love Excel”
7. VLOOKUP
Formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
By far my most used formula. The official description of what it does: “Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify…”. ( See the full explanation of VLOOKUP) Basically, you define a value (the lookup_value) for the formula to look for. It looks for this value in the leftmost column of a table (the table_array).
Note: If at all possible use a number for the lookup_value. This makes it a lot easier to make sure the data you are getting back is a correct match.
If it finds a match of the “lookup_value” in the left column of the “table_array” it will return the value in the column you specify using the “index_num”. The “index_num” is relative to theleft mostcolumn. So, if you have the table_index look in column A and you want what is returned to be what’s in column B the “index_num” would be 2 because the leftmost column, column A in this case, is the 1st column in the table array and column B is the 2nd column (hence the 2 for the index number). If you want what is in column C to be returned you’d put 3 for the index_num. The “range_lookup” is a TRUE or FALSE value. If you put TRUE it will give you the closest match. If you put FALSE it will only give you an exact match. I only use FALSE when using the VLOOKUP formula.
Example:
You have 2 lists: 1 with a sales person’s ID and the sales revenue for the quarter. Another with the sales person’s ID and the sales person’s name. You want to match up the sales person’s name to the sales person’s revenue numbers for the quarter. They are all jumbled around so to manually match this, even for a small number of salesmen would leave room for a high margin of error and take a lot of time.
The first list goes from A1 to B13. The 2nd list goes from D1 to E25.
In cell C1 I would put the formula =VLOOKUP(B18, $A$1:$B$13, 2, FALSE)
B18 = the lookup_value (the sales person’s ID. This is a number that appears on both lists.)
$A$1:$B$13 = the “table_array”. This is the area I want the formula to search the leftmost column (column E in this case) for the “lookup_value”. I went to F because if it findsmatchin column E, I want it to return what’s in column F. (The money signs are there so that the table_array will stay the same no matter where the formula is moved or copied to. This is called an absolute reference.)
2 = the index_num. This tells the formula the number of columns away from theleft mostcolumn to return in case ofmatch. So, if you find a match between the lookup_value and the leftmost column of the table array, return what’s in the same row in the 2nd column of the table (the 1st column is always the leftmost column. It starts at 1, not 0).
FALSE= tells the formula I want it to only return the value if it’s an exact match.
I would then copy and paste that formula along all the cells in column C next to the first list. This would give me a perfectly aligned list with the sales person’s ID, sales person’s revenue for the quarter, and the sales person’s name.
In order to get a nice neat list of Sales Person ID, Sales Person Name, and Sales Person Revenue all next to each other I used the VLOOKUP formula to compare1 listto another.

Wednesday 16 September 2015

10 useful tips for google chrome

1. Save Web Pages as PDF
You don't have to use PDF converter
Extension on Chrome. Google Chrome has its
own PDF converter. Open any website and
press Ctrl+ P on your keyboard ( Cmd+P
on Mac ) a window will pop up click
Change under Destination, select save as
PDF and save.
2. Custom Keyboard Shortcuts
Google Chrome has variety of keyboard
shortcuts and you can assign your own
shortcuts for opening extensions and Apps.
To assign custom shortcuts type chrome://
extensions in the Google Chrome Address
bar then click Enter this will open the
extension page. Scroll to the bottom of
the page and you will find Keyboard
Shortcuts .
3. Install unapproved Chrome Apps and
Extensions:-
Google Chrome won't allow you to install
Extension that not listed in the Chrome
webstore .to install unapproved extensions
go to the Extension page and turn on
Developer mode now drag and drop the
extension into the chrome extension page.
4. Speed up Slow Google chrome
After several hours of continues chrome usage
.Google chrome may run slow, there is two
ways to fix this problem you can close your
browser and restart it. Sometimes it won't
work, so Go to Tools > Task Manager .
Chrome task manager will open sort the list
by memory and choose the websites and
extension that uses more memory and press
end process
5. Change your Current location
Some websites such as Google maps ask the
browser for your location. you can change
your location to anywhere around the world.
Open Tools > Developer tools and choose
console > emulation and enter anyplace
value of latitude and longitude.
6. View all your Saved Passwords
If you want to view your saved Passwords,
Open any websites login Page, Open the
developer tools by pressing ctrl+Shift+I and
select the password field on the page and
change the input type from password to text.
If you find this difficult just open
" chrome://settings/passwords " and you
will find all of your saved passwords .
7. Compose Emails from Chrome Address bar
If you want to compose a new email, you
don't have to open the Gmail and compose
mail. Just go to your Chrome browser
address bar and type the command
" mailto: leopixel@gmail.com" this will open
the Gmail compose window on your current
Page .
8. Use Google Chrome as Video player
You can use your google Chrome as a
Media Player .from your hard drive Drag
video files , audio files , text files and even
PDF files to the chrome and view them
without any additional application.
9. Add more Bookmarks to bookmark bar
If you wanted to add more bookmarks to
the chrome bookmark bar ,just right click on
any of your bookmark and select edit and
remove the name of your bookmark and
save it ,now chrome will show your
bookmarked sites favicon, now you can add
many bookmarks on the bookmark bar.
10. View websites while Offline
If a website you are trying to access is
offline you can view the websites cached
version from your previous use .to access a
cached version of any web page. Click on
the address bar and type cache before the
URL and press Enter. You will see the web
page's cached version if there is one.

Monday 14 September 2015

How to download torrent file through IDM

*.Open the site ZBIGZ.com and land to its homepage
*.There you can see an option of upload torrent. Click on it and upload your .torrent file then click on GO.
*.You will have to wait for some time. It takes a time to cache your file.
*.Now when caching of your file being done, click on the button “Transfer” to download the file.
*.IDM – Internet Download Manager must be installed in your system.
*.Now your torrent file will be downloaded via IDM i.e Torrent to IDM
If you don’t have IDM – Internet Download Manager installed in your system don’t worry, it will be downloaded directly via browser’s default download manager.

Wednesday 2 September 2015

Online Virus Scan for your Computer

In Your computer have Virus? Then scan virus online without any software, just go to the site
http://virusscan.jotti.org/