Friday, April 24, 2015

it's been (ahem) a while ....

It's been ahem a while, I am now full time with Activia training so I don't have chance to publish anything on my Blogsite, more is the pity. anyway go visit us on

Jamie J

Friday, June 28, 2013

Shortcuts to copy a filtered or sub totalled selection of data

Once you have setup a Subtotal sheet you are ready to capture the data you are looking at using copy but it copies ALL the data not just the results from your subtotal.

In Excel 2007 and 2010 its hard to find a way to copy visible data only

Use the QAT menu dropdown to customise the menu and find the command called SELECT Visible Cells, add it to your toolbar.

Or use the shortcut below:

ALT +; to select the data then  CTRL + C then go to Sheet 2 then CTRL + V to paste.

Thursday, July 26, 2012

Blogging from Windows Live Writer

Using Live writer to create a blog post.



Adding pictures is a breeze !Thumbs up

Office 365 / 13 is here for preview install

Based on Office 2010 but Cloud integrated its Microsoft's new toy for users.

Install is quick and easy so go for it and see what it can do for you !!


Windows 8 Release Preview is here to download

GULP over 3GB for the 64 bit version, I hope you have fast broadband, I get Infinity on the 17th Aug.

Experts Exchange

Have a look at this useful website , experts exchange ideas and post solutions.

Friday, January 20, 2012

wow 10,273 page views, thanks everyone !!


Catch me on LinkedIn

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

Friday, November 18, 2011

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

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

That pipe key defined

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

press again to reveal data.


donate for wiki

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

The # key and its history

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

weird !


Whats that key for again ??

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



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,
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 !!!


Charts and MORE Charts

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



Friday, November 11, 2011

Another IF ISERROR example



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.


dynamic searching with VLOOKUPS, MATCH and INDEX


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.


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.

Download the template to play with it for yourself.


Search This Blog

Desktop Applications Training Blog

Jamie Johnson
JJSurf IT Training Ltd