http://excelusergroup.org/media/g/video/default.aspxenCommunityServer 2008 SP1 (Build: 30619.63)http://excelusergroup.org/media/p/2439.aspxTue, 08 Jul 2008 22:08:30 GMTafdc21cc-1618-45b1-a950-e47bb94e6e94:2439Nick Hodge0<p>This is just a short video showing how easily Excel 2007 deals with duplicate data. A task that whilst not tricky in earlier versions, was certainly more time consuming!</p> <p>If this is received well,&nbsp;I may do a few more &#39;shorts&#39;</p>http://excelusergroup.org/media/p/2134.aspxFri, 16 May 2008 22:13:45 GMTafdc21cc-1618-45b1-a950-e47bb94e6e94:2134Nick Hodge4<p>This file shows data being brought in from an Access database, into Excel 2007, using MS Query (ODBC) and parameters that are based in cells on the worksheet and update the query by changing these.</p> <p>&nbsp;</p>http://excelusergroup.org/media/p/981.aspxFri, 15 Feb 2008 21:33:33 GMTafdc21cc-1618-45b1-a950-e47bb94e6e94:981Nick Hodge1<p>This is the first of a series of pivot table videos, showing how to build and manipulate them using external data. Specifically an Access Database.</p> <p>It is also a trial for me to see how it works and how popular they are. In this first one,&nbsp;I apologise for the typewriter-like keyboard presses. I have a laptop with internal microphone.</p> <p>Hope you enjoy this and I&#39;ll try and get around to a few more, on this subject and others.</p>