Office Hackery

Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How to Compare Two Excel 2010 Worksheets

1 comment
There are several freewares to compare excel sheets and most of them are worth to try. If you already using Excel 2010, you can compare worksheets with this free add-in which allows comparison of values and formulas between two excel spreadsheets. The xc Excel Compare Tools add-in supports Excel 2010 and Excel 2007.



After installation, just go to the Add-Ins tab and hit Compare. On the xcCompareTools dialog, select the first spreadsheet and the second spreadsheet, then select if you want to compare the value or formula and lastly hit the Compare Sheet button to start the comparison.


Download xc Excel Compare Tools via [Google Code]

1 comment :

Post a Comment

Clear Recent Jumplist Items In Windows 7

No comments
One of the new feature in Windows is the Jumplist. It contains the most recent items that have been opened and the program functions. The recent items that are displayed can be a security and privacy risk. There is no shortcut or easier way to delete all items at once but you still can clear it with these simple steps.

Clear Recent Jumplist Items In Windows 7

1. Open your Windows Explorer (Press "WinKey + E")
2. On the address bar, copy and paste the following URL.
%APPDATA%\Microsoft\Windows\Recent\AutomaticDestinations
3. The Windows Explorer should show you the recent jumplists items. Although there is no way to identify which file correspond to a specific jumplist, you can try by opening each file using a Text Editor.
4. To clear all recent items, just delete all items on the directory.

No comments :

Post a Comment

Add 3D effects on Your Windows Desktop

No comments
If you have watched the Minority Report movie starred by Tom Cruise and amazed with the computer effect where Tom is browsing a hologram 3D computer in the air then you might liked this app. Ofcourse it is far more low tech than the movie but at least it can bring the 3D effect on your Windows machine. T3Desk is an alt-tab alternative that gives you 3D windows arrangement and more. With T3Desk running, "3Dmized" windows will appear in three dimensions and transparent on your screen and have the ability to be flipped, zoomed, moved, swiveled in almost anyway you want.

Add 3D effects on Your Windows Desktop

You can drag windows and dock them to the four sides of the monitor and you can maximize Windows 7's Aero Peek to see which windows are on the virtual desktop.

T3Desk is light on memory, free and for Windows Only.

Download T3Desk via [technif.com]

No comments :

Post a Comment

Instantly Transform Picture to Standard Passport Photo Online

2 comments
In a 3rd World country like the Philippines, application for passport is definitely not instant and not walk in the park. So any shortcut that can help you squeeze extra time is very much welcome. To save you time from going to a photo booth, you can try having your existing pictures transform into a standard passport photo online. With idphoto4you.com, you can upload a picture up to 6MB in size. Just select the photo of yours, select your country then hit the upload button to start the creation process.

Instantly Transform Picture to Standard Passport Photo Online

The website uses face detection technology to detect the starting location to crop the uploaded photo. If face detection is successful, the web app will automatically crop the photo to fit the standard passport of the country you selected.

Transform Your Picture in to Standard Passport Photo

2 comments :

Post a Comment

Cut and Convert Video/Audio using MediaCope

No comments
There is a lot of Video/Audio editing software out there but I found Media Cope very interesting and useful. Aside from being free, it can also do a lot of stuff beyond an ordinary converter, like playing audio & video files, cut them according to your needs or import them to other formats. It also have a photo cutter, resizer, slideshow and much more.

Cut and Convert Video/Audio using MediaCope

Media Cope can play file formats mp3, avi, divx, mov, mkv, flac, rmvb, flv, vob, wma and mp4. It can convert your video to various format such as mp4, 3gp, wmv, mov, divx, mpg, flv and etc. Media Cope is a freeware for Windows only.

Download Media Cope via [developers website]

No comments :

Post a Comment

How to show the Date Picker in MS Access 2007

No comments
Here is a video tutorial that I stumbled upon on YouTube. The video demonstrate the ability of MS Access 2007 to include Date Picker on your Access forms.

No comments :

Post a Comment

How to Create a Virtual Drive of a Folder in Windows

No comments
If you frequently use specific folders then you might as well assign a drive letter to it to easily access it from your Windows Explorer. There is an old and unpopular DOS command that can do this. Using "subst" you may assign easy to remember drive letters to any specific local folder. Here is an example that assign drive "Z" to my Music folder.

Open your command prompt then type:
subst z: "j:\Songs Collection"


Running the command above created a new drive Z as shown below.

How to Create a Virtual Drive of a Folder in Windows

Take note that the subst command cannot be used with mapped network folders and these virtual drives are temporary and will be gone as soon as you restart your system. To make it permanent, you can add the subst command on your autoexec.bat.

No comments :

Post a Comment

Windows 7 Logon Screen Editor

No comments
Although Windows 7 logon background is cool, after sometime we get bored and will try to customize it. With a small application called Thoosje's Logon screen Editor you can change the default windows 7 logon screen in seconds. Aside from allowing you to choose your own background image, it also comes with wide collection of beautiful and eye-candy logon screens.

Windows 7 Logon Screen Editor

Thoosje's Logon screen Editor can also reverts back to the default screen so you don't have to worry if you are not satisfied with the changes.

This freeware supports both 32-bit and 64-bit of Windows 7. The installation file is about 2MB in size.

Download Thoosje's Logon screen Editor via [thoosje.com]

No comments :

Post a Comment

Reskin your Windows 7 Taskbar with AeroWorks

No comments
Most of the available tweaks to reskin Windows 7 today requires patches. If you don't want this but still want to play around with your Windows 7 or Vista taskbar skin then you can try AeroWorks free edition. AeroWorks allows you to change taskbar background and special effects. Seven skins are already included and ready to use. You can add your own images and special effects by clicking on the Choose Base and Choose FX buttons.

Reskin your Windows 7 Taskbar with AeroWorks

Unlike other tweaks, AeroWork doesn't modify your system and if your not satisfied with the changes, you can always roll it back anytime.

Download AeroWorks via [deviantart.com]

No comments :

Post a Comment

Always Open Application in Maximized Window

No comments
If you want your application to always open in maximized mode instead of having it maximize over and over again then this shortcut trick can help you.

1. Locate the shortcut you want to be maximized always. Right-click and select properties.

Always Open Application in Maximized Window

2. Under the Shortcut tab change the Run dropdown to Maximized.

Your done! Enjoy a maximized window. Always...

No comments :

Post a Comment

Automatically Login and Lock Windows 7

No comments
Auto Login and Lock Windows 7In most Windows version, you can always disable the logon screen by tweaking it a bit. But a system without password at startup can open up security concerns so it is still better if Windows ask you for a password. But with the logon screen enabled, it takes some time to load windows services and all other startup programs. So how can you make it boot faster without sacrificing security? Your system should auto login and then auto lock Windows. This can be achieve through the Auto Logon & Lock tweak, so that when you hit the Power button and return a few minutes later to login, you won't need to wait for all those startup programs to load.

Some of the benefits from this tweak:
- Faster boot time.
- Automatically resume downloads etc. when your PC reboots due to a power failure or crash.
- It password protects Safe Mode as well. Existing auto logon methods leave Safe Mode unprotected.
- It locks the desktop before Explorer is started. Other methods auto-lock using an autorun/start up entry which leave the PC logged on and unlocked until the autorun entries are executed (which can even take several minutes).

To install the tweak on your system, follow these steps:
1. Download Auto Login and Lock app.
2. Run "Lock.exe" from the archive to test if the application runs without errors. If successful, your desktop should be locked. Logon again and Windows Explorer should be open.
3. Copy the files "Lock.exe" and "LockCMD.exe" to your Windows directory. (Ex: C:\Windows).
4. Run "lockcmd.reg" from the archive and click Yes in the dialog box. You must run this while logged on to the account which you want to enable auto logon for.
5. Click Start and type "netplwiz.exe" on the Run dialog then press Enter.
6. Uncheck the checkbox "Users must enter a user name and password to use this computer" and click OK. Enter the Username and Password of the account you want to enable auto logon for.
7. Restart your PC to test it.

Auto Login and Lock is tested on Windows Vista (32-bit & 64-bit), Windows 7 (32-bit & 64-bit).

No comments :

Post a Comment

Monitor Flight + Hotel Price Drops with Travelocity Desktop

No comments
As the popular saying goes "Work hard and Play harder", people have to balance work and living life. If your a travel savvy like me who consider traveling as personal playing field then you should know about this free app. Travelocity Desktop application is a tool for travelers which can deliver Flight + Hotel hot deals directly to your desktop when the price drops to your favorite destinations, so you can negotiate a deal as soon as it's available.



This free program is an Adobe AIR-based desktop app for Windows, Mac, and Linux. It saves your preferred city of origin and destination, then automatically refreshes anywhere depending on your preferred refresh duration (from 4 to 24 hours). You can also manually refresh the content anytime you like. Aside from hot deals alerts, you can also do other things like find hotels on a map in your favorite destinations to see exactly where you want to stay and share deals with your friends easily on Facebook or Twitter.

Install Travelocity Desktop Application via [Travelocity.com]

No comments :

Post a Comment

Change Windows Settings/Profiles With Quick Config

No comments
For novice windows users, changing system settings are quite complicated specially when you use laptop on different work places. For example, if you need to change network connection settings, you have to dig down to control panel, find the right network protocol, and set the right properties. You have to re-configure your computer everytime you plugin your laptop on a different network. But you can do it in a snap using Quick Config.

Change Windows Settings/Profiles With Quick Config

Quick Config is a free tool that can help you to change various settings of your Windows computer. It is convenient for users who travels often with their laptop to working places, home and office and want to be able to change network connection settings, set default printer and etc. with just one click. The freeware is compatible with Windows XP, Windows Vista and Windows 7.

Download Quick Config via [intelloware.com]. This app is also available as portable app which you can run from USB drive.

No comments :

Post a Comment