Power Query for Power BI and Excel shows how to use Microsoft Power Query to extract data from multiple data sources, filter that data, aggregate it and clean it, and finally load it into Microsoft Excel.
With Practical SharePoint 2010 Branding and Customization, learn how to quickly and easily create aesthetically pleasing, highly usable branded and customized SharePoint websites both internally and externally.
Practical SharePoint 2010 Information Architecture is a guide and tool set for planning and documenting the scope, navigational taxonomy, document taxonomy, metadata, page layouts and workflows for a successful SharePoint 2010 project.
Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010. You'll learn how to build database applications, create Web-based databases, develop macros and VBA tools for Access applications, integrate Access with SharePoint, and much more.
Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including coverage of new features in Excel 2007. Covering object-oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code.