Browse by Tags

• Excel
• How To's
• Hyper-V
• Microsoft
• PowerPivot
• Software
• SQL Server 2008
• Training

• Microsoft Virtual Labs – PowerPivot for Excel 2010

  Want to try out PowerPivot for Excel 2010 yourself, but don’t have time or resources to build a demo system? Now you can get 2 hours in a virtual lab (Powered by Hyper-V) to get to grips with it: Click here to connect to the Lab (IE Only since it needs... Posted Nov 19 2009, 11:35 AM by EdGillett with | with no comments Filed under: Office, Microsoft, SQL Server 2008, PowerPivot, Training, Hyper-V

• Finding MS Query cell ranges in Excel

  Recently I've had the problem of picking up an Excel workbook which uses MS Query to connect to a SQL datasource and pull back lots of data in to literally hundreds of data grids. We had to point the grids at a new datasource, but the problem is that... Posted Mar 10 2008, 04:28 PM by JohnGamble with | with no comments Filed under: Office, How To's, Excel, Microsoft

• How to update an Office Addin over the internet

  When you're offering an add-in through your website you usually have no connection to the people who are using your programming work. It is not unusual that you have discovered (or been pointed at) bugs in your code or that you've done some updating... Posted Feb 05 2008, 11:56 AM by BenSavage with | with no comments Filed under: Software, Office, Microsoft