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

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

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

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

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