If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
Download Excel workbook here www.wiseowl.co.uk/videos/excelvba/pivot-tables-introduction.htm
Download SQL script here www.wiseowl.co.uk/training/exercises/ex-2363.htm
This video explains how to create an Excel pivot table based on a SQL Server database. You'll learn how to create connections to external data sources, how to edit connection strings and how to create a pivot cache using the external connection. The video also shows you how to create views in SQL Server Management Studio, along with how to write basic SQL statements in your VBA code to create flexible queries that you can use to create pivot tables.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!