Need some sample data to play around with Excel 2007 ?

Then try Mr Excel ...

http://www.mrexcel.com/miraclesfiles.html

These files are from the Book : Excel 2007 Miracles Made Easy by Bill Jelen.

Download a Sudoku Solver here !

"Yes you can solve Sudoku in seconds with MS Excel !"

thanks to Mikes spreadsheet of VB magic !

download from :
http://www.mikeoldroyd.com/

PowerPoint Links

Need some professional backgrounds and templates, then check out these links below :
obviously a lot of these sites you will have to pay for the goods !!

http://www.ppted.com/

http://www.powerfinish.com/

Also check out Microsoft Office Online site for some free templates !

http://office.microsoft.com/en-gb/templates/results.aspx?qu=powerpoint&av=TPL000

And also check out :

http://www.presentationhelper.co.uk/free_powerpoint_template.htm

free templates !

Note in PowerPoint 2007 you can have access to a wide range of pre set templates and colour combinations, it makes a lot of the older templates look "out-dated" by comparison.

Thanks

Jamie

Microsoft At Work Website

Useful tips and tricks for Office lovers everywhere !

http://www.microsoft.com/uk/atwork/default.mspx

First look at Office 2007

Try this website for a first look at the advances with MS Office 2007 !
Its a huge new version with lots of great time saving and impressive features across all the applications :
http://www.microsoft.com/uk/office/newday/default.mspx?nav=v1xcsubmenuxi0&WT.mc_id=Online

Good luck

Office Books anyone ?

Web page detailing MS Office books available !

http://www.mousetrax.com/books.html#office

Monthly Training Journal

Hi try MouseTRax for training resources, I found some good help here on all MS Office related apps. You can subscribe for free to get a monthly magazine !

http://www.mousetrax.com/TechPage.html

Cheers
Have a nice Summer break for those of you going on holiday in 2007 !! :)

Jamie

Red RAG to a bull [ Red Amber Green Graphic Indicators]

Hi all
Just done a Project 2003 course and we discovered you can set up graphical indicators for your Project Tasks or overall Project status such as a red dot for Warning, Amber and green dot aswell !

I will document the process in a later Blog, but its a New Custom Field then choose Graphical indicators, when the user selects a drop down option such as R, A or G it uses a graphic instead of text.

A more interactive approach lets you copy a Number column such as Cost or Variance and Paste link it over the top of the indicator column so it keeps changing dependant on the numbers linked to it.

more to follow ...

Jamie

Outlook Keyboard Shortcuts

In a hurry with E-Mail , then peruse the shortcuts below :

Function keys

F1 -- Open Help
F3 -- Open Find dialog or Find pane.
F4 -- Expand dropdown menus, use arrow keys to select from list
F5 -- Refresh the current window (Outlook 2003) - Send/Receive in older versions
F6 -- Move to next window element
F7 -- Run spell check F9 -- Send/Receive


Number Keys

Ctrl+1 -- Inbox
Ctrl+2 -- Calendar
Ctrl+3 -- Contacts
Ctrl+4 -- Tasks
Ctrl+5 -- Notes
Ctrl+6 -- Folder list
Ctrl+7 -- Shortcuts
Ctrl+8 -- Journal
Ctrl+Y -- Folder picker dialog

Print a list of shortcut keys from within Word ..

Ever wondered how to get your own list of keyboard shortcuts ???

Read on .....

1. On the Tools menu, point to Macro, and then click Macros.
2. In the Macros in box, click Word commands.
3. In the Macro name box, click ListCommands.
4. Click Run.
5. In the List Commands dialog box, click Current menu and keyboard settings.
6. Click OK.
On the File menu, click Print.

MOS SOS !!

Become MOS qualified and be the best !!

http://www.microsoft.com/learning/mcp/officespecialist/default.mspx

JJSURF

Demystify a few computer terms and get on with your life

Crabby to the rescue to bust some jargon !
http://office.microsoft.com/en-gb/help/HA010429491033.aspx

JJSURF and Crabby Office Lady.

Put Word to work for you!

Five handy tips for use with MS Word courtesy of Microsoft :
http://office.microsoft.com/en-gb/word/HA101154421033.aspx

JJSURF

Pretty Ribbons ....

Here's the Ribbon. Note the expandable Groups such as Clipboard and Font. The Office button at top left gives you access to the File Open, Save, Print commands plus others.

Home , Insert Page Layout etc are positioned across the top of the Ribbon.

Dont worry you will soon get used to it !!!

JJSURF

The Crabby Office Lady is alive and well !!!

Yes folks she's still around dishing out advise, like it or not check out her latest Office ravings below :

http://office.microsoft.com/en-gb/help/FX101679371033.aspx

JJSURF

You can use Shift Control + H to open a Word, Excel or PowerPoint document from within MS Outlook.. give it a try !!

JJSURF

Looking to Office 2007 .... the keyboard !

Keyboard shortcuts in the 2007 Office System Whatever your reason for preferring keyboard shortcuts, take this training course and get the low-down on new and and easier ways to use the keyboard with Microsoft Office 2007.

Downloads from Pearson Site for Excel

All the downloads, half the strain !!!

http://www.cpearson.com/excel/download.htm

Date Arithmetics !

Another link from C Pearson below for date calcs !

http://www.cpearson.com/excel/datearith.htm

VBA code for date related calcs

Try this link below if you are looking into Date calcs within Excel using VB Code, there is some useful stuff in here to try out !!

http://www.cpearson.com/excel/DateTimeVBA.htm


Jamie