Thursday, February 11, 2016

Google Search Tips 4: Finding The Exact Phrase

Use the Quotation marks when precision matters, with adding quote marks around any query will tell Google to find for occurrences of the exact phrase as it was typed. It's helpful especially when searching for people's names, song lyrics or expressions. For example "John Lenon"

Google Exact Math

Tuesday, February 9, 2016

Google Search Secrets and Tips 3 - Online Converter

Google can be used as multi unit converter such as: Area, Length,Mass, Volume, etc.
Type any conversion that you need to do in the search box. For example to convert 1 Kilometer to Mile just type 1 Kilometer Mile, then you can convert any other unit like mass, for instance Found to Kilogram buy choosing Mass in the unit.

Length conversion

Online Mass Converter


volume conversion


Sunday, February 7, 2016

Google Search Secrets and Tips 2 : Use Google as Dictionary

In the search box type define followed by any English word. You will find the definition of that word on the top of the search results.

Google Tips - Google as dictionary


Saturday, February 6, 2016

Google Search Secrets and Tips 1 : Use Google as Calculator



Type any math problem in the search box, we can type numbers and math symbols or we can spell the equation in words or type in a combination of both. For example: five plus ninety six, 45+178, 50% of 45. The result will be appeared on Google's calculator on your screen, and you may use it for any calculations.




Saturday, July 25, 2015

REMOVE DUPLICATES IN EXCEL

How To Remove Duplicates Data in Excel 2007, 2010 and 2013
1. Select any single cell or data range inside the worksheet
2. On Excel menu click Data tab, click Remove Duplicates.
Click Remove Duplicates

3. Select any Columns that contain Duplicates or Select All
Remove Duplicates Dialog Box

Before - After
Remove Duplicates Example Remove Duplicates Result

Tuesday, June 25, 2013

Running Control Panel From Command Line Windows

 
Below are the list command that we can use to manage the Windows Control Panel,
can be used by System Administrator to do admin task without login with admin account,
use the runas combination.
Example:
C:\control netcpl.cpl

Control panel tool             Command
   -----------------------------------------------------------------
   Accessibility Options          control access.cpl
   Add New Hardware               control sysdm.cpl add new hardware
   Add/Remove Programs            control appwiz.cpl
   Date/Time Properties           control timedate.cpl
   Display Properties             control desk.cpl
   FindFast                       control findfast.cpl
   Fonts Folder                   control fonts
   Internet Properties            control inetcpl.cpl
   Joystick Properties            control joy.cpl
   Keyboard Properties            control main.cpl keyboard
   Microsoft Exchange             control mlcfg32.cpl
      (or Windows Messaging)
   Microsoft Mail Post Office     control wgpocpl.cpl
   Modem Properties               control modem.cpl
   Mouse Properties               control main.cpl
   Multimedia Properties          control mmsys.cpl
   Network Properties             control netcpl.cpl
                                  NOTE: In Windows NT 4.0, Network
                                  properties is Ncpa.cpl, not Netcpl.cpl
   Password Properties            control password.cpl
   PC Card                        control main.cpl pc card (PCMCIA)
   Power Management (Windows 95)  control main.cpl power
   Power Management (Windows 98)  control powercfg.cpl
   Printers Folder                control printers
   Regional Settings              control intl.cpl
   Scanners and Cameras           control sticpl.cpl
   Sound Properties               control mmsys.cpl sounds
   System Properties              control sysdm.cpl
    

Thursday, February 7, 2013

Find the Windows Update

To Look the Installed or Applied Windows Update in the computer

Go to Start - Command Prompt then type "wmic qfe list"

Installed Windows Updated