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 the Excel workbook here www.wiseowl.co.uk/videos/excelvba/powerpivot-data-model.htm
Download the Access database here www.wiseowl.co.uk/training/exercises/ex-2720.htm
Download SQL script here www.wiseowl.co.uk/training/exercises/ex-2363.htm
The PowerPivot Data Model allows you to combine data from a variety of sources into one single object in a workbook - you can then use this model to create pivot tables using the joined data. This video explains how to create and edit the PowerPivot data model using dat from Excel worksheets, Access databases and SQL Server databases. You'll learn how to create a data model, how to add and remove tables and how to import or create relationships between the different tables in the model. The final part of the video explains how to create a single data model which combines data from Excel, Access and SQL Server.
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!