Friday, November 18, 2011

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

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

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

Friday, November 11, 2011

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

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

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

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

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

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.

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

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

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

Thursday, March 10, 2011

Money Saving Expert Blogsite

Martins Blog Site can be found here.

enjoy saving some dosh

How many Spreadsheets do you have ????

this is a bit of fun:

Click here for the lowdown by Martin Lewis

JJ

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

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

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 !

Want a Presentation Overview of Office 2010

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

Then try this link above  ..

so cool !!

Digg the News !!!

http://digg.com/news

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

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

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

Social scenes in 2010

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.

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.

Search This Blog

Desktop Applications Training Blog


Jamie Johnson
JJSurf IT Training Ltd
http://www.jjsurf.co.uk/