Date Picker for Excel Sheets

Found a nice add-on for Microsoft Excel 2007 that allows you to add a date picker in a excel sheet cell.
It comes really handly when you need to quickly add a date (Current date or any other) in a excel sheet cell. This add-on gives some options to customize as well
like using a cell icon etc.



For details check out MS Excel Date Picker

Download add-on at MS Excel Date Picker add-on download

What is MAC address and how to find it?

What is MAC address?
The MAC address is a unique value associated with a network adapter. MAC stands for Media Access Control.
The MAC address (also known as the physical address) is your computer's unique hardware number. When you're connected to the Internet from your computer (or host as the Internet protocol thinks of it), a correspondence table relates your IP address to your computer's physical (MAC) address on the LAN. This is how the router knows where to send IP packets destined for your system. MAC addresses are also known as hardware addresses or physical addresses.

MAC addresses are 12-digit hexadecimal numbers (48 bits in length). By convention, MAC addresses are usually written in one of the following two formats:

MM:MM:MM:SS:SS:SS

MM-MM-MM-SS-SS-SS

The first half of a MAC address contains the ID number of the adapter manufacturer. These IDs are regulated by an Internet standards body (see sidebar). The second half of a MAC address represents the serial number assigned to the adapter by the manufacturer. In the example,

00:A0:C9:14:C8:29

The prefix

00A0C9

indicates the manufacturer is Intel Corporation.

How do I find my computer's MAC address?
It's quite easy to find your PC's MAC address -
The list below summarizes options to find a computer's MAC address:
* Windows 95 and newer: winipcfg
* Windows NT and newer: ipconfig /all
* Linux and some Unix: ifconfig -a
* Macintosh with Open Transport: TCP/IP Control Panel - Info or User Mode/Advanced
* Macintosh with MacTCP: TCP/IP Control Panel - Ethernet icon

Also check this link
and this link.

Data Recovery Software with free License

In addition to one of my earlier post on Data Recovery tools for free, Here is another option to recover your lost data.
iCare Data Recovery Software is dedicated in most frequently data recover like formatted hard drive, MBR (Mast Boot Record) corrupted, bad boot sector, drive inaccessible, partition unreadable, partition deleted, software operation failure like Partition Magic caused data loss, Ghost failure, virus attacked, etc.
iCare Data Recovery can easily recover files from wrong formatted drives, unexpectedly file deletion, raw drive or raw file system, virus attack, partition deleted, software crash etc. It can recover any deleted files like photos, documents, mp3, outlook file, presentations, and it also works with any type of storage media like hard drive, removable hard drive, digital camera sd card, usb drives, ipod, memory card etc.

You can download the full version of this software from here - Download the Full version here

And the License code is : “2K1XB2X964MPHOCJ8M1RYIJF0OVHFOFH”

Edit your PDF Files for Free

If your looking for basic editing of your PDF files, Open Office comes very handy. Extremely easy to install and use.
Open office version 3 and above support editing of PDF files. You can download the latest Open Office here. As of date, the latest release is Open Office version 3.2.
Once you download and install Open Office, you would need to download and install 'Sun PDF Import Extension'. It can be downloaded here. To install for windows, you can simply download and dbl-click on the downloaded '.oxt' file. Or else you can open new document (or spreadsheet etc) in Open Office -> go to Tools -> Extension Manager, and install it.
Open 'Draw' (File -> New -> Drawing), then in Draw, simply open the PDF file to edit it.
Best part about Open Office PDF editor is, it retains all the original formatting.

Run Command In Windows

A comprehensive list of various Run command.

To access go to run (Win + R )

•Accessibility Controls : access.cpl
•Accessibility Wizard : accwiz
•Add Hardware Wizard : hdwwiz.cpl
•Add/Remove Programs : appwiz.cpl
•Administrative Tools control : admintools
•Adobe Acrobat (if installed) : acrobat
•Adobe Designer (if installed) : acrodist
•Adobe Distiller (if installed) : acrodist
•Adobe ImageReady (if installed) : imageready
•Adobe Photoshop (if installed) : photoshop
•Automatic Updates : wuaucpl.cpl
•Bluetooth Transfer Wizard : fsquirt
•Calculator : calc
•Certificate Manager : certmgr.msc
•Character Map : charmap
•Check Disk Utility : chkdsk
•Clipboard Viewer : clipbrd
•Command Prompt : cmd
•Component Services : dcomcnfg
•Computer Management : compmgmt.msc
•Control Panel : control
•Date and Time Properties : timedate.cpl
•DDE Shares : ddeshare
•Device Manager : devmgmt.msc
•Direct X Control Panel (If Installed)* : directx.cpl
•Direct X Troubleshooter : dxdiag
•Disk Cleanup Utility : cleanmgr
•Disk Defragment : dfrg.msc
•Disk Management : diskmgmt.msc
•Disk Partition Manager : diskpart
•Display Properties control : desktop
•Display Properties : desk.cpl
•Display Properties (w/Appearance Tab Preselected) control : color
•Dr. Watson System Troubleshooting Utility : drwtsn32
•Driver Verifier Utility : verifier
•Event Viewer : eventvwr.msc
•Files and Settings Transfer Tool : migwiz
•File Signature Verification Tool : sigverif
•Findfast : findfast.cpl
•Firefox (if installed) : firefox
•Folders Properties control : folders
•Fonts control : fonts
•Fonts Folder : fonts
•Free Cell Card Game : freecell
•Game Controllers : joy.cpl
•Group Policy Editor (XP Prof) : gpedit.msc
•Hearts Card Game : mshearts
•Help and Support : helpctr
•HyperTerminal : hypertrm
•Iexpress Wizard : iexpress
•Indexing Service : ciadv.msc
•Internet Connection Wizard : icwconn1
•Internet Explorer : iexplore
•Internet Properties : inetcpl.cpl
•Internet Setup Wizard : inetwiz
•IP Configuration (Display Connection Configuration) : ipconfig /all
•IP Configuration (Display DNS Cache Contents) : ipconfig /displaydns
•IP Configuration (Delete DNS Cache Contents) : ipconfig /flushdns
•IP Configuration (Release All Connections) : ipconfig /release
•IP Configuration (Renew All Connections) : ipconfig /renew
•IP Configuration (Refreshes DHCP & Re-Registers DNS) : ipconfig /
registerdns
•IP Configuration (Display DHCP Class ID) : ipconfig /showclassid
•IP Configuration (Modifies DHCP Class ID) : ipconfig /setclassid
•Java Control Panel (If Installed) : jpicpl32.cpl
•Java Control Panel (If Installed) : javaws
•Keyboard Properties control : keyboard
•Local Security Settings : secpol.msc
•Local Users and Groups : lusrmgr.msc
•Logs You Out Of Windows : logoff
•Malicious Software Removal Tool : mrt
•Microsoft Access (if installed) : access.cpl
•Microsoft Chat : winchat
•Microsoft Excel (if installed) : excel
•Microsoft Frontpage (if installed) : frontpg
•Microsoft Movie Maker : moviemk
•Microsoft Paint : mspaint
•Microsoft Powerpoint (if installed) : powerpnt
•Microsoft Word (if installed) : winword
•Microsoft Syncronization Tool : mobsync
•Minesweeper Game : winmine
•Mouse Properties control : mouse
•Mouse Properties : main.cpl
•Nero (if installed) : nero
•Netmeeting : conf
•Network Connections control : netconnections
•Network Connections : ncpa.cpl
•Network Setup Wizard : netsetup.cpl
•Notepad : notepad
•Nview Desktop Manager (If Installed) : nvtuicpl.cpl
•Object Packager : packager
•ODBC Data Source Administrator : odbccp32.cpl
•On Screen Keyboard : osk
•Opens AC3 Filter (If Installed) : ac3filter.cpl
•Outlook Express : msimn
•Paint : pbrush
•Password Properties : password.cpl
•Performance Monitor : perfmon.msc
•Performance Monitor : perfmon
•Phone and Modem Options : telephon.cpl
•Phone Dialer : dialer
•Pinball Game : pinball
•Power Configuration : powercfg.cpl
•Printers and Faxes control : printers
•Printers Folder : printers
•Private Character Editor : eudcedit
•Quicktime (If Installed) : QuickTime.cpl
•Quicktime Player (if installed) : quicktimeplayer
•Real Player (if installed) : realplay
•Regional Settings : intl.cpl
•Registry Editor : regedit
•Registry Editor : regedit32
•Remote Access Phonebook : rasphone
•Remote Desktop : mstsc
•Removable Storage : ntmsmgr.msc
•Removable Storage Operator Requests : ntmsoprq.msc
•Resultant Set of Policy (XP Prof) : rsop.msc
•Scanners and Cameras : sticpl.cpl
•Scheduled Tasks control : schedtasks
•Security Center : wscui.cpl
•Services : services.msc
•Shared Folders : fsmgmt.msc
•Shuts Down Windows : shutdown
•Sounds and Audio : mmsys.cpl
•Spider Solitare Card Game : spider
•SQL Client Configuration : cliconfg
•System Configuration Editor : sysedit
•System Configuration Utility : msconfig
•System File Checker Utility (Scan Immediately) : sfc /scannow
•System File Checker Utility (Scan Once At Next Boot) : sfc /scanonce
•System File Checker Utility (Scan On Every Boot) : sfc /scanboot
•System File Checker Utility (Return to Default Setting) : sfc /
revert
•System File Checker Utility (Purge File Cache) : sfc /purgecache
•System File Checker Utility (Set Cache Size to size x) : sfc /
cachesize=x
•System Information : msinfo32
•System Properties : sysdm.cpl
•Task Manager : taskmgr
•TCP Tester : tcptest
•Telnet Client : telnet
•Tweak UI (if installed) : tweakui
•User Account Management : nusrmgr.cpl
•Utility Manager : utilman
•Windows Address Book : wab
•Windows Address Book Import Utility : wabmig
•Windows Backup Utility (if installed) : ntbackup
•Windows Explorer : explorer
•Windows Firewall : firewall.cpl
•Windows Magnifier : magnify
•Windows Management Infrastructure : wmimgmt.msc
•Windows Media Player : wmplayer
•Windows Messenger : msmsgs
•Windows Picture Import Wizard (need camera connected) : wiaacmgr
•Windows System Security Tool : syskey
•Windows Update Launches : wupdmgr
•Windows Version (to show which version of windows) : winver
•Windows XP Tour Wizard : tourstart
•Wordpad : write

Check Strength of Your Password

Your online accounts, computer files, and personal information are more secure when you use strong passwords to help protect them.

Here is a small yet useful utility from Microsoft to check the strength of your password.

So each time you decide to change your password for any kind of account, you can use this password strength checker from Microsoft.

Time to sheild your Windows OS

Microsoft has announced new patches for "critical" Windows bugs that are actively being exploited on the internet, allowing an attacker to take control of your system remotely. Here's how to keep your Windows system protected -

1. Keep your WINDOWS OS updated
Verify that you have the most recent security updates from Microsoft and that AutoUpdate is on.

a) Start Internet Explorer and go to http://update.microsoft.com
b) Check the box at the top right to see Automated Update status. If needed, click to turn ON Automatic Updates from Microsoft.
c) Hit "Express" to install all outstanding high-priority updates.
d) If needed, be sure to reboot to finalize the install of the updates.

2. Keep your ANTIVIRUS and FIREWALL updated

3. Update BROWSERS and APPLICATIONS.
All softwares that interacts with the internet are updated regularly by the publisher as vulnerabilities are discovered. This includes products such as internet browsers, social networking software, mobile device operating system and apps (such as iPhone), Adobe products like Acrobat and Flash, and media players. Staying current with the latest versions is crucial to your system security.