Wednesday, January 31, 2007

The Wow starts now !!!

Yes folks Windows Vista is launched today so go and take a look at the link below :

please visit

Monday, January 29, 2007

John Walkenbach - Excel Guru !

Check out Johns website, he is the author of many books including The Dummies guides - Excel VBA Programming for Dummies !

His site is: htttp://

also author of : "The Excel 2003 Bible" and "Excel 2003 Power Programming with VBA."

Keyboard Shortcuts are back in fashion

Most people love a few keyboard shortcuts to help speed up things in Word, Excel and other applications.
I will be compiling a list for each application although quite a few work on all packages.

So get ready to be aware of what F5 does in Excel and F9.
What does CTRL + Scroll wheel do in Excel ?
WOW it zooms in to the worksheet ( very handy for a trainer with the projector).

"Shortcuts are back in fashion as many will testify, if your cordless mouse battery packs in on the train you will wish you paid attention to those keyboard shortcuts !"

Using dynamic and static dates in Excel

hi again,
We all need to put dates and times into Excel to "timestamp" orders, deliveries and sales invoices etc.

The dynamic functions:
try putting 10,000 into a cell and format it with CTRL + 1 .
Set it to a date format. What date do you get ??? Strange but true !
Excel operates using the 1900 date system, so its 10,000 days after 1st Jan 1900. Hence 18th May 1927.

So with this in mind we can put calcs into your worksheets.

Try :

=TODAY() for todays date
=NOW() for current date and time

These will update automatically each time you recalc the sheet or open it next day !

Static Dates
If you want to time stamp your sheets use the following :

CTRL + : snapshot of current Date
CTRL + SHIFT + ; snapshot of current Time

Nicknames in Outlook

If your wondering how to save the predictive typing when you type in someones email address then its called "Nicknames" in Outlook. Its saved to a file called Outlook.NK2, so search your pc for this type of file using *.nk2

Copy it to a memory stick and keep a backup or transfer it to your new PC.


Get into the groove ....

Use this link below to have a look at Microsoft Groove, a great new collaboration tool from Microsoft :


MS Office Newsletter

Hi. I receive this newsletter every month and thought you might like to take a look. The latest issue can be found here - If you like what you see and want to get it yourself just sign up!

Sunday, January 28, 2007

Google Docs and Spreadsheets

Don't forget other options are closing in on Microsoft !
Have a try at Google's offerings !!!

A Blog of MS Office tips, tricks and golden nuggets !

Hi all, welcome to my blog !

I will be compiling an ongoing blog of MS Office training "extras" to complement the training courses I deliver for QA-IQ.

This will be split into Windows, Excel, Word, Access and PowerPoint, plus other packages like Project, OneNote etc.

Thank you !


Search This Blog

Desktop Applications Training Blog

Jamie Johnson
JJSurf IT Training Ltd