If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link [ Ссылка ] to make a donation. Thanks for watching!
By Andy Brown
[ Ссылка ] - You can download the files that you need to follow this tutorial from [ Ссылка ].
PowerPivot has a very particular recommended way in which you should handle dates, which involves creating a calendar table in Excel or (better) SQL Server. This tutorial shows you how to create and use calendar tables, and also how to add in your own aggregator columns for things like working days.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, PowerPivot, SQL, Reporting Services, Analysis Services, Integration Services and other .NET, SQL Server and Microsoft Office applications.
