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

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

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

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

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 ??

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

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

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

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

dynamic searching with VLOOKUPS, MATCH and INDEX

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

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

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

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

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

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

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

J Walks legendary Excel/VB help site

http://spreadsheetpage.com/

enjoy !!!
JJ

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.

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

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