JJSurf IT Training Blog

2012-01-20T16:10:00.002Z

wow 10,273 page views, thanks everyone !!

Jamie

Catch me on LinkedIn

2012-01-20T16:02:00.001Z

Hi folks,
You can keep up with me on LinkedIn also follow the link below:

http://uk.linkedin.com/in/jjsurf

wikiversity .. a place to learn for free and its fun

2011-11-18T12:34:00.001Z

http://en.wikiversity.org/wiki/Introduction_to_Programming/About_Programming

this link takes you to page 1 of the programming course on wikiversity

That pipe key defined

2011-11-18T12:30:00.001Z

http://en.wikipedia.org/wiki/Vertical_bar

Rarely used but much loved the pipe key, I use it in Excel to reveal formulas with CTRL + `

press again to reveal data.

thanks
J

donate for wiki

2011-11-18T12:27:00.001Z

https://wikimediafoundation.org/w/index.php?title=L11_1114_WMUK_Jimmy/GB&utm_source=B11_1114_Foundation_WMUK_Jimmy&utm_medium=sitenotice&utm_campaign=C11_1114_WMUK&language=en&uselang=en&country=GB&referrer=http%3A%2F%2Fen.wikipedia.org%2Fw%2Findex.php%3Ftitle%3DSpecial%253ASearch%26search%3Dpipe%2Bkey

the above gibberish takes you to a link to donate to wikipedia, please consider it to maintain a great service.
J

The # key and its history

2011-11-18T12:25:00.001Z

http://en.wikipedia.org/wiki/Number_sign

Did you know some people call it the pound key ? also the Octothorp ????

weird !

:)
J

Whats that key for again ??

2011-11-18T12:23:00.001Z

http://www.computerhope.com/keys.htm

the above link simply explains what all the keys on your keyboard are called and what they typically do for you !

Simples

JJ

Grr how do you show Percentage Changes

2011-11-16T20:49:00.001Z

This is not an obvious one but I was aksed how can I show a percentage CHANGE between two values,
eg.
Sales in 2009 were 75K and by 2010 had risen to 125K what is the % change ?

The Formula you can use is as below:

Thus returning a value of 67%

nice one !!!

JJ

Charts and MORE Charts

2011-11-16T20:46:00.001Z

http://processtrends.com/downloads.htm

Take a look at the above link for lots of specialist Chart types not normally available in Excel.

thanks

JJ

Another IF ISERROR example

2011-11-11T16:02:00.001Z

IF ISERROR and VLOOKUPs

2011-11-11T15:50:00.001Z

=IF(ISERROR(VLOOKUP(E6,CostTable,2,FALSE)*E6),0,VLOOKUP(E6,CostTable,2,FALSE)*E6)

use the above to solve your Excel 2003 Vlookup error requirements, this enables SUM calcs to still give you an answer and replaces error cells with zeros.

J

dynamic searching with VLOOKUPS, MATCH and INDEX

2011-11-11T15:31:00.001Z

http://office.microsoft.com/en-us/excel-help/dynamic-searching-using-vlookup-match-and-index-HA001154902.aspx

IF ISERROR VLOOKUP

2011-11-11T15:29:00.001Z

http://www.exceltip.com/images/screenshots/810.gif

Another problem was how to use an IF ISERROR combo in Excel 2003 as this was much simplified
in Excel 2007/10 with the IFERROR Function.

see the screen shot above for a solution.

JJ

Waterfall Charts, wet your appetite !

2011-11-11T15:05:00.001Z

A recent question about waterfall charts in Excel got me thinking "How do they do that ?"
so after a little searching here is a great link to a fix for it in Excel.

http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/

PS
Download the template to play with it for yourself.

Jamie

Pivot Tables ( Consolidating multiple sheets)

2011-09-18T22:50:00.001+01:00

Pivot Tables can be tricky to new users but probably THE MOST POWERFUL thing in Excel.
This week I was stumped on how to consolidate using Excel 2010 when creating a Pivot.
When you go to Insert Pivot, there are now NO OPTIONS to get your data from a set of multiple worksheets. So unless you consolidate first it seemed a no go .

However upon researching it the only way to get the Excel 2003 options for Pivot Wizard is to use a magic shortcut :

ALT D then P, then you get the typical Pivot Table Wizard screen with mutiple sheet options, HEY PRESTO !

Insert Pivot only gives you these options in 2007 and 2010:

thanks !

JJ

2011-09-18T22:42:00.002+01:00

Testing out the NEW Blogger Interface and it seems very strange but useful !!

Just for fun !!

2011-08-08T12:52:00.002+01:00

try:

www.selfcontrolfreak.com for a bit of graphical fun, the mouse controls what happens within the video.
Try number 1 he swats the mouse away, try and touch his nose.

J

Apple iCloud Seminar Video

2011-08-08T12:46:00.000+01:00

Have a look at this new seminar on the Apples approach to the Cloud

http://events.apple.com.edgesuite.net/11piubpwiqubf06/event/

JJ

J Walks legendary Excel/VB help site

2011-07-28T11:29:00.001+01:00

http://spreadsheetpage.com/

enjoy !!!
JJ

Want a £15 PC, the size of a memory stick ?? its on its way !

2011-06-04T21:09:00.000+01:00

http://www.raspberrypi.org/

Early days but a veteran coder of Elite on the BBC micro fame is paving the way for a new device to allow children to easily learn to code rahter than just use apps.

FIVE Thousand page views,

2011-05-15T22:51:00.000+01:00

Thanks, app fans, over 5K hits and still rocking !!Brilliant !!!

JJ
(Just watched GaGa Live at Big Weekend, wow Excellent!!) LOL

Looking for a FREE Shared Meeting Planner ???

2011-05-15T22:48:00.002+01:00

Then again, LOOK NO FURTHER !!
try out www.doodle.com for web based , interactive meeting setups for multiple people spread across the land.
I had a look and its great !

JJ

Looking for a FREE Project Gantt Planner App ???

2011-05-15T22:45:00.001+01:00

Then search no further, you can use www.smartsheet.com for free, thats right ! totally free !!
it looks and feels like MS Project so go for it, great for shared team projects, web based.

Jamie

Money Saving Expert Blogsite

2011-03-10T21:24:00.001Z

Martins Blog Site can be found here.

enjoy saving some dosh

How many Spreadsheets do you have ????

2011-03-10T21:22:00.000Z

this is a bit of fun:

Click here for the lowdown by Martin Lewis

JJ

Office 2010 Roll out guides

2011-03-10T17:32:00.000Z

You can now download for free the Office 2010 Quick Reference Guides, Word, Excel, PowerPoint, Outlook, Access and OneNote.

The Presentations, making the switch to Office 2010 for Word, Excel, PowerPoint, Outlook, Access and Visio.

The Interactive guides are available here too, well worth a look

MOS 2010 Certification is here !

2011-03-10T17:15:00.002Z

Get certified to show your boss or prospective employer you know your STUFF in Office 2010

http://www.microsoft.com/learning/en/us/certification/mos.aspx#certifications

According to the Stats

2011-01-26T15:49:00.002Z

The stats never lie !

my most popular page for hits is the Access Input mask properties page.
so there you go !

Want a Presentation Overview of Office 2010

2011-01-26T15:42:00.002Z

http://www.imcreative.nl/quickmigration/office2010/demoukuk/course.html

Then try this link above ..

so cool !!

Digg the News !!!

2011-01-26T15:29:00.001Z

http://digg.com/news

First glance at Windows 7 for your Phone

2011-01-26T15:10:00.000Z

Hello ?? Hello ? Microsoft calling ........beeeeeeeeeeeeeeeeep

http://blogs.office.com/b/office_blog/archive/2011/01/06/ces-a-look-at-office-on-a-windows-phone-7.aspx

Office 2010 Manual from Inside Out

2011-01-26T15:08:00.002Z

Dive into the essential features in Microsoft Word 2010, Excel® 2010, OneNote® 2010, Outlook® 2010, and PowerPoint® 2010 with Office 2010 Inside Out. This supremely organised reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. Let the experts help you become at ease and proficient with every program in the Office family.

As always, Office Insiders can order Office 2010 Inside Out for the special price of £25.50 (RRP £42.50). So grab a bargain for the New Year!

http://click.email.microsoftemail.com/?qs=1b5f72c72cdbb026f0b823f42f3f03675f9c43c57e44ccdbf498e736d62e852cc9ac9676d63492d5

Ebay plug-in for Excel

2011-01-26T15:07:00.001Z

http://pages.ebay.com/Excel_Plugin/

manage up to 5,00 entries right there in Excel to your Ebay account !!

Social scenes in 2010

2011-01-26T15:06:00.000Z

http://office.microsoft.com/en-gb/outlook/social-connector-for-microsoft-outlook-HA101794273.aspx

Merge and Mail in 2010

2011-01-26T14:59:00.000Z

Merge them, mail them
http://office.microsoft.com/en-gb/word-help/use-mail-merge-to-create-and-print-letters-and-other-documents-HA101857701.aspx

Mail merge in Word and Outlook 2010 is the easy way to create standard documents for a large group of contacts. If you're sending a new year release or a marketing mailout it's simple to prepare personalised material for your clients or a subset of them if you prefer. It's not just letters - emails, envelopes or mailing labels are just as quick to do. Find out how.

Conversations in Outlook 2010

2011-01-26T14:56:00.000Z

How to converse in Outlook 2010

http://office.microsoft.com/en-gb/outlook-help/video-introduction-to-conversations-VA101822182.aspx

Conversations are a way of grouping your emails so you can easily follow what's going on in a particular topic - even if you've filed individual emails in separate folders. And if you don't need to keep following something, you can even clean it up and Outlook automatically puts the emails in your delete folder.

Wow, over 2 thousand page views !!

2010-12-27T21:09:00.000Z

"thats great news, over 2 thousand page views, many thanks people.
I will promise to keep adding new things going into 2011 as I have been neglecting the site on favour of twitter as its quick on the move to keep up to date but blogs are brilliant to educate and train/inform people and help you out with your apps issues."

Jamie J
xxx

Happy New Year for 2011

2010-12-27T20:44:00.000Z

Happy New Year fellow bloggers and tweeters as this year draws to an end I wish you all health wealth and good fortune and fun for the coming year 2011.
I have had many challenges over 2010 and many memorable moments during my travels.
January was quietish but Feb I popped over to Amsterdam to deliver Excel training to a corporation I have worked with before, this was a good laugh as I had a mixed bunch of Dutch, English, Italian and Belgians on the courses.
My work has taken me far and wide across the UK, only recently down to Stonehenge for a few days work teaching Windows basics and Excel stock order systems.
Many a trek to Milton Keynes now completed I am actually starting to remember the islands !!
Manchester is imprinted on my brain aswell now.
Birmingham sees my company more than most and we are moving offices with one client I work with to new facilities which will be good.

So good luck all and enjoy your PC experiences in 2011.

All things Word and Wonderful, all blogs great and small !

2010-11-12T12:44:00.002Z

http://www.shaunakelly.com/word

enjoy
J

mass emailer for Excel

2010-11-12T11:27:00.002Z

http://www.rondebruin.nl/sendmail.htm

this is VERY useful as it allows you to email to multiple people with attachments and TO, CC settings from a database list in Excel 97 - 2010.
install the add-in and away you go, it really works !!!

I had this a few years ago and its just as good now

J

test via Outlook 2010 to Blogger

2010-10-19T14:14:00.000+01:00

Fingers crossed this works !!!

Jamie Johnson

Office 2003 to Office 2010 guides

2010-10-19T14:01:00.000+01:00

http://bit.ly/cAxXMe

Use the link above to get your hands on some Official Microsoft QRG's for your shiny new Office 2010 software.

JJ

Spotify for instant access to millions of tracks

2010-10-19T13:47:00.000+01:00

Playing with http://www.spotify.com/ allows you to search and listen to tons of tracks via its friendly interface.
Imagine you have your iTunes Library but suddenly there are millions of tracks to choose from, thne you have Spotify.

OK after your trial period runs out of about 20hrs then its £6 or so per month but that wouldnt even buy you 1 CD at todays prices.
I searched for a lot of stuff and it nearly always came up with the goods, The Hurts, Vampire Weekend, Elvis, Beatles, Ultravox, Sisters of Mercy, whatever !!!

You can tag them as favourites and create groups of tracks to play whenevr you like.

ENJOY !

iTunes Remote Control using your iPhone

2010-10-19T13:41:00.001+01:00

Wow, this is fun.
I can control my iTunes application on my PC and listen to my favourite tracks, search, change the volume, pause, listen to Albums, Podcats, Playlists all via my Apple iPhone.

Download the FREE app from the App Store called "Remote" and then connect to your Library remotely.

Within seconds you will be able to crank up your speakers and listen to any of your iTunes Library via the phone.
I can see this developing so with blue tooth speakers downstairs I can easily listen to my favourite music via the iPhone, Awesome !!!

JJ

New improved Blogger.com

2010-10-19T13:01:00.000+01:00

New improved Blogger.com website makes it easier to Preview prior to posting your Blog Posts, so check it out on
http://www.blogger.com/ and click that preview button.
You can post from email aswell or a mobile phone or even from Word or Wordpress.

JJ

It's been a while ......

2010-10-19T11:16:00.001+01:00

Hi there folks !
It's been quite a while but I have been busy with my Contract work, since setting up my own IT Training Company: www.jjsurf.co.uk I havnt had much time to update my blog aswell as my constant twittering on www.twitter.com/jjsurf but today I will be posting some things on Office 2010 and other interesting tech.

Many thanks

Jamie

Office 2010 is here ....

2010-08-10T15:02:00.002+01:00

Yes its here and a lot of people are liking it so far.
www.microsoft.com/office2010 Download a trial here.

BACKUP
Note:
Make sure you backup your user files on a regular basis, I had a crisis call from the family after pictures were deleted by mistake in Picasa, luckily the recycle bin came to the rescue as they had been deleted also from the Camera card.

JJ

Lynda.com

2010-08-10T14:57:00.003+01:00

Hi there, its been a while as I have been very busy on Train the Trainer assignments.

Anyway if you are short of time for training why not have a look at Lynda.com for all your web based video training needs.

some of the content is free to begin with so you can see if you like the style.

enjoy,

Jamie

Skyping !

2010-04-16T12:26:00.000+01:00

Just set up Skype and tested it out with a landline call, great quality through my speakers and the end user agreed the call was very clear.

I will be testing the video once my contacts accept my Skype requests.

www.skype.com for the FREE download, Skype to Skype is FREE over your BBand, Skype to LandLine is about 12p per minute in the UK.

Cheers
Jamie

Getting the month end date in Excel

2010-03-30T10:16:00.004+01:00

You need the month end dates for a range of dates on invoices, no problem in Excel

The calculation uses DATE to format the cell with Y M D and we add a month then take 1 day off it to get month end :

Happy with your IT Manuals ?

2010-03-27T10:44:00.001Z

Need some Training Manuals pronto ?

then use www.happymanuals.co.uk for all your training manual needs.

Register then download, then pay a small fee.

JJ

Free WINZIP

2010-03-27T10:35:00.001Z

Want a Free copy of Winzip ???

http://www.trialpay.com/checkout/?c=aeee19dbebf71b8adc4a35f072102b43&tid=RHy3zTu

then use the link above, subscribe to the offer and get Winzip in free with the deal , saves you £22

JJ

More followers needed

2010-03-21T10:14:00.000Z

Follow me !!!

as we march towards Office 2010 and Windows 7 !!!

see you there

http://www.nationaltrust.org.uk/main/w-bonus-day.pdf

2010-03-21T10:11:00.000Z

Fancy a FREE weekend pass to some National Trust properties ?

http://www.nationaltrust.org.uk/main/w-bonus-day.pdf

use this link and print out the voucher PS ONLY for weekend of 20/21 March 2010 and NOT all National Trust properties

enjoy !

Desktop Wallpaper needs a Spring Clean ?

2010-03-16T09:53:00.001Z

http://www.smashingmagazine.com/2010/02/28/desktop-wallpaper-calendar-march-2010/

Look no further as here is a link to a massive amount of March Desktop backgrounds and they even come with a built in calendar if like me you never got round to buying one in December !

great !!

Jamie

http://www.jamessenior.com/

2010-03-16T09:41:00.000Z

Social Web Guy and Web Evangelist has a new platform, check it out.
http://www.jamessenior.com

All things web and ASP with lots of useful stuff thrown in as well

thanks James

Jamie

http://mthomas.co.uk/the-powerpoint-comma-bug/

2010-03-16T09:23:00.002Z

The comma bug when linking in PPT,
thanks to Mike Thomas for this one, If you hyperlink to a slide with a comma in its title the hyperlink just doesnt work, so follow the work-around to fix it.

http://mthomas.co.uk/the-powerpoint-comma-bug/

cheers

Jamie

Visual Basic for Access & other things SQL Database related

2009-12-15T20:41:00.003Z

www.functionx.com

Use the above link for a fantastic array (joke) of programming information, I especially like the VBA stuff in here, many hours of really useful help and worked examples of code you can copy and paste and test/run in your own systems to see exactly how it works.

well done !

Jamie

Want a better set of IT Training Manuals ?

2009-11-22T00:10:00.002Z

Then try www.watsoniapublishing.co.uk

I have just got their MS Project 2007 manuals Level 1 and 2 and they are very, very detailed, excellent reference and training sources. The files are downloadable from their site and you can order individual manuals or as many as you need for a class in colour or b/w.

JJ

http://www.speakingaboutpresenting.com/

2009-11-22T00:04:00.002Z

http://www.speakingaboutpresenting.com/ this link takes you to a nice blog with lots of help and links to useful Presentation books.
e.g.
Slideology

The Backchannel: How Audiences are Using Twitter and Social Media and Changing Presentations Forever

Made to Stick

Presentation Zen

JJ

2009-11-09T10:52:00.001Z

Windows 7 - selling well and people are happy !!!

Windows 7 - 13 Days to launch !!!

2009-10-09T10:39:00.000+01:00

Get ready for Windows 7
The countdown is on! With Windows 7 releasing October 22, here's everything you need to be prepared.
Get started

Want hundreds of FREE Office 2007 PPT's

2009-10-07T11:55:00.001+01:00

http://office.microsoft.com/en-us/training/HA101926501033.aspx
yes thats right FREEEEEE templated PPT Presentations on all aspects and every package in the MS Office 07 suite for u 2 use !

Jamie

(well maybe not hundreds ..)

Useful link for Office 2007 Manuals

2009-10-07T11:47:00.000+01:00

http://eu.wiley.com/WileyCDA/Section/id-302479.html?query=microsoft%20office%202007

Moving to 2010 !!

2009-10-03T23:07:00.001+01:00

Link to main Office 2010 website from Microsoft

http://www.microsoft.com/office/2010/

Direct link to Office 2010 "First look-see" from Microsoft(C)

2009-10-02T15:29:00.001+01:00

http://www.microsoft.com/officebusiness/office2010/

Office 2010 videos

2009-10-02T15:26:00.001+01:00

You have got to be joking, I am sure many clients of mine are still thinking of going to 2007 or not just yet and here is 2010 !!!

Well have a look maybe its a case of skiping 07 and going straight to 2010 and the same with Vista, go straight to Win 7 ????

cheers again for the link on Chris's site

http://blogs.technet.com/chrisp/archive/2009/07/21/introducing-microsoft-office-2010.aspx

Mail Merge - Compare Word 2007 v Open Office

2009-10-02T15:22:00.002+01:00

Lets do a comparison MS Word 07 v a rival in the form of Open Office

Thanks to Chris P for this gem, check out his blog aswell.

http://blogs.technet.com/chrisp/archive/2007/05/08/microsoft-office-word-2007-and-openoffice-org-2-2-0-mail-merge-comparison.aspx

YOU only pay for what you get, dont skimp if its your business !!

Link to an Office Blog

2009-10-02T14:38:00.000+01:00

Have a look at the link below:

http://www.mymsoffice.net/

contains links to videos on Office 07

Thanks
J

The Office Values - Microsoft UK Training with David Brent 4

2009-10-02T14:35:00.001+01:00

final part

http://www.youtube.com/watch?v=IXdKMoFqHWA

J

The Office Values - Microsoft UK Training with David Brent 3

2009-10-02T14:34:00.001+01:00

next part :

http://www.youtube.com/watch?v=pEOz7nxky6Y

J

The Office Values - Microsoft UK Training with David Brent 2

2009-10-02T14:31:00.000+01:00

Part 2 of the David Brent videos !! ha haaa

http://www.youtube.com/watch?v=XKXz2qDTiBU

Jamie

The Office Values - Microsoft UK Training with David Brent

2009-10-02T14:26:00.001+01:00

here is a bit of fun from Mr David Brent and the gang on Microsoft.
LOL

http://www.youtube.com/watch?v=oKyV-l8i5lg

Jamie

2009-10-02T14:19:00.001+01:00

Listen and watch Jensen Harris from Microsoft who is discussing the reasoning and development processes behind the new (ish) Office 2007 Interface design and how it came about
NOTE : its split into ten minute sections so you will need to get the next one from you tube

Here is the link to part 2 where it gets more interesting :

http://www.youtube.com/watch?v=IYg647Jx7Y8

very useful !!!

part 3 :
http://www.youtube.com/watch?v=7i3E-ZfMVNQ
Jamie

WOLC the WOLC, TALK the TALK

2009-09-30T15:52:00.002+01:00

Dont forget the World Of Learning Conference is on today and tommorrow at the NEC, Bham and is full of all your favourite IT Training and Development needs.
I shall be there to make new contacts and see what's happening out there in the current world of training.

Many key companies and trainers will need to think of new dynamic approaches to training as the reccession bites and budgets are at rock bottom.

Smart Training is required and cost effective approaches to training your staff.

Courses are being condensed as TIME is a costly asset for Managers, a day out of the office for 2 or 3 delegates is difficult as work demands have doubled and even tripled for our poor IT workers as other staff have been made redundant or have been given other duties to juggle.

Good Luck

JJSurf IT Training Ltd hits the waves !

2009-09-17T15:14:00.001+01:00

Hi all,
Don't forget to check out my new website on www.jjsurf.co.uk
I shall be developing this a little bit as time goes by but it contains all my contact details.

If you need IT Applications Training give me a call. I am Midlands based but can travel if required. I cover all MS Office apps plus a few extras. My CV is downloadable via the website.

email : jjsurf@btinternet.com

Thanks again

Jamie Johnson
MCT, TAP, MCAS and MOS Master

Free to Fly !!

2009-08-04T20:35:00.001+01:00

Having been freed today of my Corporate Bondage, I am now free to fly as a Freelance IT Trainer and Contractor.

So onwards and upwards !!!

Many thanks to all my colleagues old and new and keep watching this space for news and help on everything Microsoft Office related.

Plus I will be expanding a little into Technology, everyone loves a bit of Gadge !! now and again !!

Jamie

Geek T-shirts

2009-03-13T12:02:00.001Z

Hi all,
While I am waiting here for Visio 2007 to install I am perusing the web and came across a link to cafepress, here you can find all manner of geeky, nerdy T shirts so I have put a link for you below ... go on you know you want to click it ...

http://t-shirts.cafepress.com/geek_mens-clothing?fp=25198913

J.

PowerPoint Heaven ..in the Spring

2009-03-09T16:44:00.003Z

Hi all , Spring has springed and daffodils are everywhere again !

Why not revamp and spring clean your dusty PowerPoint slides with a few squirts of elbow grease and a little help from the following sites :

http://www.pptheaven.mvps.org/

http://www.fotosearch.com/

http://www.istockvideo.com/

http://www.freestockfootage.com/

Happy Spring Cleaning !!!

J.

Blog changes

2009-02-06T13:03:00.001Z

New Year - New Template !!

I thought I would just refresh the Blog site and change templates to a more wintery, icy feel especially in these times of snow and ice we are all having.

KEEP WARM !!

Jamie

BT Vault for useful files - EXCEL

2009-02-06T12:53:00.002Z

Hi everyone, many thanks for your comments on the Blog DBUI who ever you are !!

I have now sorted out some web space to post files for you all, so use the link below to gain access to EXCEL TOOLS, to begin with. it contains Duplicate Master and Excel Dictionary.

http://digitalvault.bt.com/invite/login?c=383730393732&i=17852a-11ef224ac95-gemini05&t=d966a1c919f343f8&r=mg&lang=en

More to follow,

enjoy

Jamie

2009-01-08T12:06:00.001Z

Happy New Year 2009 to all Bloggers ...

Jamie

Microsoft Video Website

2008-09-03T22:39:00.003+01:00

http://preview.microsoft.com/video/

A new site , here you can watch videos about new MS Products inc Office and Vista.
Check it out on the above link.

JJ

Microsoft Office Labs

2008-09-03T22:20:00.001+01:00

Fancy doing some undercover Microsoft Research into new products and up and coming ideas/software betas ???
then have a look at this link below ...

http://www.officelabs.com/Pages/About.aspx

go to the home page once you have looked at the about page.

... dont tell anyone else !

Jamie

PowerPoint Delivery Shortcuts ....

2008-07-15T09:28:00.002+01:00

When the pressure is on and you need to deliver the goods during your Presentation don't forget the following shortcut blags :

F5 to run the Presentation, shift F5 to run from current slide in PPT 02 and 03/07

1. Use B or W to Blackout oe Whiteout the screen during talk time or using a whiteboard.
2. Use Spacebar to progress the slides and backspace if someone asks a question and you need to go back to a previous slide.
3. ESC quits the presentation
4. You can use N for next and P for Previous slide
5. dont forget Annotations, right click and choose a pen colour to then write notes on ths slides during delivery and save them at the end of your presentation for further use later !

Good luck and relax/smile and crack a few jokes ....

JJ

Blog from your Email to your Blogsite DIRECT !

2008-05-16T16:46:00.004+01:00

Yes,

Hi Folks

I have now discovered you can email from anywhere you have web access straight into your blog site, either as a draft or straight to live !! via a configurable email address on blogspot.

Very useful !!

This message was emailed via Outlook 2007 to the Blog site !

Jamie

Office 2007 Certification Program [MCAS/MCAP]

2008-04-23T10:21:00.001+01:00

Hi all,
If you are now happily playing with Office 2007 then isnt it time you got some qualifications on it ?
try out this MS Link below to take you to the new certification for Office 07 and Vista via Certiport, we at QA-IQ use them to test and take exams with for our delegates and our own staff !

http://www.certiport.com/Portal/desktopdefault.aspx?page=common/pagelibrary/mbc_mcas.html

Jamie

You turn your back and ...

2008-03-06T22:59:00.001Z

IE8 is on the doormat ...

Well not quite on general release yet but it's coming soon , watch out !!
http://blogs.msdn.com/ie/

JJ

IE for the Web !

2008-03-06T22:55:00.000Z

Internet Explorer has it's own blogsite, oohh get you !

http://blogs.msdn.com/ie/

Vista Blog for the masses !!!

2008-03-06T22:51:00.000Z

Link below for Vista News

http://windowsvistablog.com/blogs/windowsvista/

Any Office Zealots out there ??

2008-03-06T22:44:00.001Z

This site has some up to the minute office news and interesting articles.
Plus its now moved onto a SharePoint platform !

http://www.officezealot.com/Pages/index.aspx

enjoy !!!

JJ

News for Developers and Microsoft people from Redmond, USA

2008-03-06T22:42:00.001Z

http://reddevnews.com/default.aspx

Visio and Infopath Blogs

2008-03-06T22:14:00.001Z

http://blogs.msdn.com/visio
http://blogs.msdn.com/infopath

I still keep finding 'em !! :)

JJ

Groovy Project

2008-03-06T22:10:00.001Z

http://blogs.msdn.com/groove
http://blogs.msdn.com/project

more links to useful blogs, telling us all about the funky stuff in 2007 products !!!

JJ

More Blogs from those nice MSDN people

2008-03-06T22:05:00.001Z

http://blogs.msdn.com/access/
http://blogs.msdn.com/outlook
http://blogs.msdn.com/powerpoint

MSDN Excel Bloggers

2008-03-06T22:03:00.001Z

MSDN provide a wealth of MS Office related Blogs, so try one for Excel for a start :

http://blogs.msdn.com/excel/

JJ

Office 2007 Bible

2008-03-06T21:57:00.002Z

http://pschmid.net/blog/2006/10/09/58

Use this link above to peruse the why's and wherefore's of Office 2007, from it's innception to it's features and menu's.

Many thanks to it's contributor's and collaborator's. [it is their views, so take that into account !]
This was from 2006

Jamie

2008-03-06T21:04:00.001Z

Microsoft keyboard shortcuts
The following table contains keyboard shortcuts for use with Microsoft keyboards.
Press this key To do this
Windows logo key Open or close the Start menu
Windows logo key +BREAK Display the System Properties dialog box
Windows logo key +D Display the desktop
Windows logo key +M Minimize all windows
Windows logo key +SHIFT+M Restore minimized windows to the desktop
Windows logo key +E Open Computer
Windows logo key +F Search for a file or folder
CTRL+Windows logo key +F Search for computers (if you are on a network)
Windows logo key +L Lock your computer (if you are connected to a network domain), or switch users (if you're not connected to a network domain)
Windows logo key +R Open the Run dialog box
Windows logo key +T Cycle through programs on the taskbar
Windows logo key +TAB Cycle through programs on the taskbar by using Windows Flip 3-D
CTRL+Windows logo key +TAB Use the arrow keys to cycle through programs on the taskbar by using Windows Flip 3-D
Windows logo key +SPACEBAR Bring all gadgets to the front and select Windows Sidebar
Windows logo key +G Cycle through Sidebar gadgets
Windows logo key +U Open Ease of Access Center
Windows logo key +X Open Windows Mobility Center

UAC is a pain in the AC

2008-03-06T20:57:00.001Z

There you are with your brand spanking new Vista laptop and everything is fine but every time you want to do something a little more “adventurous” the screen dims and you have to click Continue to the security prompt just to run a utility. Its YOUR LAPTOP why keep asking for raised privileges all the time just to run stuff in the Control Panel !

Well with help from the Dummies Guide to Vista ! I managed to switch off this annoying facility, its probably great for users on a network where the stressed out admin guys are sick of users trying to install games and screen savers etc but if its your own machine why have all the extra security ?

Its called UAC, “User Account Control” and it can be disabled for all users via:

Control Panel – Administrative Tools – System Configuration -Tools – Disable UAC
(Requires a reboot unfortunately!)

The Missing Manuals

2008-02-04T17:08:00.000Z

Hi all,
I have discovered after a lengthly flick through most of the Office books at "Borders" that the missing manuals books are very good. I have purchased Access 2007 and Project 2007 to start with and these say on the front :
"The book that should have been in the box". This is true, it's got a wealth of useful extras, background help, interesting utilities that I have not come across in other manuals. they are written in a nice relaxed style, brave enough to even say when a facility is rubbish or never took off.

Check them out ...

The Access 2007 book covers macros, VB, SQL ,all the basic Objects and Database theory as well.
Jamie