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
Wednesday, November 16, 2011
Grr how do you show Percentage Changes
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
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
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
Take a look at the above link for lots of specialist Chart types not normally available in Excel.
thanks
JJ
Friday, November 11, 2011
IF ISERROR and VLOOKUPs
=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
IF ISERROR VLOOKUP
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
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 !
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
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
Sunday, September 18, 2011
Pivot Tables ( Consolidating multiple sheets)
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
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:
JJ
Monday, August 08, 2011
Just for fun !!
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
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
Have a look at this new seminar on the Apples approach to the Cloud
http://events.apple.com.edgesuite.net/11piubpwiqubf06/event/
JJ
http://events.apple.com.edgesuite.net/11piubpwiqubf06/event/
JJ
Thursday, July 28, 2011
Saturday, June 04, 2011
Want a £15 PC, the size of a memory stick ?? its on its way !
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.
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.
Sunday, May 15, 2011
FIVE Thousand page views,
Thanks, app fans, over 5K hits and still rocking !!Brilliant !!!
JJ
(Just watched GaGa Live at Big Weekend, wow Excellent!!) LOL
JJ
(Just watched GaGa Live at Big Weekend, wow Excellent!!) LOL
Looking for a FREE Shared Meeting Planner ???
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
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 ???
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
it looks and feels like MS Project so go for it, great for shared team projects, web based.
Jamie
Thursday, March 10, 2011
Office 2010 Roll out guides
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
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 !
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
http://www.microsoft.com/learning/en/us/certification/mos.aspx#certifications
Wednesday, January 26, 2011
According to the Stats
The stats never lie !
my most popular page for hits is the Access Input mask properties page.
so there you go !
my most popular page for hits is the Access Input mask properties page.
so there you go !
Want a Presentation Overview of Office 2010
http://www.imcreative.nl/quickmigration/office2010/demoukuk/course.html
Then try this link above ..
so cool !!
Then try this link above ..
so cool !!
First glance at Windows 7 for your Phone
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
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
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
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
http://pages.ebay.com/Excel_Plugin/
manage up to 5,00 entries right there in Excel to your Ebay account !!
manage up to 5,00 entries right there in Excel to your Ebay account !!
Merge and Mail in 2010
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.
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
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.
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.
Monday, December 27, 2010
Wow, over 2 thousand page views !!
"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
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
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.
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.
Friday, November 12, 2010
mass emailer for Excel
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
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
Tuesday, October 19, 2010
Office 2003 to Office 2010 guides
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
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
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 !
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
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
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
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
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 ......
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
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
Tuesday, August 10, 2010
Office 2010 is here ....
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
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
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
Friday, April 16, 2010
Skyping !
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
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
Tuesday, March 30, 2010
Getting the month end date in Excel
You need the month end dates for a range of dates on invoices, no problem in ExcelThe 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 :
Saturday, March 27, 2010
Happy with your IT Manuals ?
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
then use www.happymanuals.co.uk for all your training manual needs.
Register then download, then pay a small fee.
JJ
Free WINZIP
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
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
Sunday, March 21, 2010
http://www.nationaltrust.org.uk/main/w-bonus-day.pdf
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 !
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 !
Tuesday, March 16, 2010
Desktop Wallpaper needs a Spring Clean ?
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
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/
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://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/
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
Tuesday, December 15, 2009
Visual Basic for Access & other things SQL Database related
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
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
Sunday, November 22, 2009
Want a better set of IT Training Manuals ?
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
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/
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
e.g.
Slideology
The Backchannel: How Audiences are Using Twitter and Social Media and Changing Presentations Forever
Made to Stick
Presentation Zen
JJ
Monday, November 09, 2009
Friday, October 09, 2009
Windows 7 - 13 Days to launch !!!
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
The countdown is on! With Windows 7 releasing October 22, here's everything you need to be prepared.
Get started
Wednesday, October 07, 2009
Want hundreds of FREE Office 2007 PPT's
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 ..)
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 ..)
Saturday, October 03, 2009
Moving to 2010 !!
Link to main Office 2010 website from Microsoft
http://www.microsoft.com/office/2010/
Friday, October 02, 2009
Office 2010 videos
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
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
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 !!
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
Have a look at the link below:
http://www.mymsoffice.net/
contains links to videos on Office 07
Thanks
J
http://www.mymsoffice.net/
contains links to videos on Office 07
Thanks
J
The Office Values - Microsoft UK Training with David Brent
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
LOL
http://www.youtube.com/watch?v=oKyV-l8i5lg
Jamie
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
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
Wednesday, September 30, 2009
WOLC the WOLC, TALK the TALK
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
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
Thursday, September 17, 2009
JJSurf IT Training Ltd hits the waves !
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
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
Tuesday, August 04, 2009
Free to Fly !!
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
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
Friday, March 13, 2009
Geek T-shirts
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.
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.
Monday, March 09, 2009
PowerPoint Heaven ..in the Spring
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.
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.
Friday, February 06, 2009
Blog changes
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
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
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
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
Thursday, January 08, 2009
Wednesday, September 03, 2008
Microsoft Video Website
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
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
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
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
Tuesday, July 15, 2008
PowerPoint Delivery Shortcuts ....
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
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
Friday, May 16, 2008
Blog from your Email to your Blogsite DIRECT !
Yes,
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
Wednesday, April 23, 2008
Office 2007 Certification Program [MCAS/MCAP]
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
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
Thursday, March 06, 2008
You turn your back and ...
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
Well not quite on general release yet but it's coming soon , watch out !!
http://blogs.msdn.com/ie/
JJ
Any Office Zealots out there ??
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
Plus its now moved onto a SharePoint platform !
http://www.officezealot.com/Pages/index.aspx
enjoy !!!
JJ
Groovy Project
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
http://blogs.msdn.com/project
more links to useful blogs, telling us all about the funky stuff in 2007 products !!!
JJ
MSDN Excel Bloggers
MSDN provide a wealth of MS Office related Blogs, so try one for Excel for a start :
http://blogs.msdn.com/excel/
JJ
http://blogs.msdn.com/excel/
JJ
Office 2007 Bible
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
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
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
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
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!)
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!)
Monday, February 04, 2008
The Missing Manuals
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
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
Monday, January 28, 2008
TOP TIPS for Office
http://www.microsoft.com/uk/atwork/tips/default.mspx
Use this link above to gain access into a wealth of top tips and shortcuts/useful things to know in Office via our friends at Microsoft !
Jamie
Use this link above to gain access into a wealth of top tips and shortcuts/useful things to know in Office via our friends at Microsoft !
Jamie
Want a copy of Office Ultimate 2007 ??
SAVE £500 on Office 2007 !!!!!!!!
http://www.theultimatesteal.co.uk/
As long as you are a registered student you can get a FULL version of Office 07 for £38.95 as opposed to £549 !
http://www.theultimatesteal.co.uk/
As long as you are a registered student you can get a FULL version of Office 07 for £38.95 as opposed to £549 !
Do you know your RSS from your elbow?
see the link below for all info re RSS and Blog elbows !
http://www.microsoft.com/uk/atwork/rss.mspx
thanks,
Jamie
http://www.microsoft.com/uk/atwork/rss.mspx
thanks,
Jamie
Fed up with the backs of envelopes? Try OneNote instead
"OneNote is a really easy way to take notes, manage and share them. You can input your own notes, grab pages from the Internet, import and annotate documents from other Office programs and organise the information to suit the way you work. You can even include audio and video notes.
Everything is stored in searchable electronic notebooks. Set up sections within a notebook, or multiple notebooks for different projects. Using hyperlinks between sections or notebooks means you can quickly access and deal with complex information. And it's all on one screen.
Take a trial Why not try OneNote for yourself? Download the trial today, and get ready to be even more productive!
Watch the demo If you'd like to find out more about OneNote's features, check out the demo. You may never buy another notebook again." - Taken from the "At Work" MS Office newsletter Jan 08
Everything is stored in searchable electronic notebooks. Set up sections within a notebook, or multiple notebooks for different projects. Using hyperlinks between sections or notebooks means you can quickly access and deal with complex information. And it's all on one screen.
Take a trial Why not try OneNote for yourself? Download the trial today, and get ready to be even more productive!
Watch the demo If you'd like to find out more about OneNote's features, check out the demo. You may never buy another notebook again." - Taken from the "At Work" MS Office newsletter Jan 08
Friday, January 11, 2008
Duplicates Addin for Excel
The previous Link is for EXCEL
and it works a treat on column data when you are checking for duplicate data between the columns or rows or a highlighted area of your sheet !
Please think about donating to the creators !
JJ
and it works a treat on column data when you are checking for duplicate data between the columns or rows or a highlighted area of your sheet !
Please think about donating to the creators !
JJ
The Duplicate Master
Happy New Year folks !!!
Having trouble finding duplicates and highlighting them or maybe you want to remove or delete them via a utility.
Then try this Add-in below, you will need to be able to install addins to your PC for this to work.
http://members.iinet.net.au/~brettdj/
Cheers
Jamie
Having trouble finding duplicates and highlighting them or maybe you want to remove or delete them via a utility.
Then try this Add-in below, you will need to be able to install addins to your PC for this to work.
http://members.iinet.net.au/~brettdj/
Cheers
Jamie
Wednesday, December 12, 2007
Creating GRaphical Indicators in MS Project
Hi again
Have a look at my latest posting , below I ahve placed a link to TechTrax website that explains the different types of graphical indicators within Project and how to set them up.
You can have "Traffic Light Indicators" for tasks overbudget or slipping dates, etc and Drop down menus (combo boxes) to allow the end user to only choose from the given list, e.g. Task Name , Dept ( Custom Field) etc.
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=403
Thanks
Jamie
PS have a Merry Xmas and New Year to all the bloggers out there !
Have a look at my latest posting , below I ahve placed a link to TechTrax website that explains the different types of graphical indicators within Project and how to set them up.
You can have "Traffic Light Indicators" for tasks overbudget or slipping dates, etc and Drop down menus (combo boxes) to allow the end user to only choose from the given list, e.g. Task Name , Dept ( Custom Field) etc.
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=403
Thanks
Jamie
PS have a Merry Xmas and New Year to all the bloggers out there !
Subscribe to:
Posts (Atom)