Crunch Any Data, From Any Source, Quickly And Easily, With Excel 2013 Pivot Tables! Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours understand exactly whats going on in your business take control, and stay in control!

Even if youve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function.

Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. Youll find simple, step-by-step instructions, real-world case studies and even complete, easy recipes for solving your most common business analysis problems.

Table of Contents
Part I Learning the Basics of VB
1 Introducing the .NET Framework 4.5
2 Getting Started with the Visual Studio 2012 IDE
3 The Anatomy of a Visual Basic Project
4 Data Types and Expressions
5 Debugging Visual Basic 2012 Applications
6 Handling Errors and Exceptions

Part II Object-Oriented Programming with Visual Basic 2012
7 Class Fundamentals
8 Managing an Object’s Lifetime
9 Organizing Types Within Namespaces
10 Modules
11 Structures and Enumerations
12 Inheritance
13 Interfaces
14 Generics and Nullable Types
15 Delegates and Events
16 Working with Collections and Iterators
17 Creating Objects: Visual Tools and Portable Libraries

Part III Advanced Language Features
18 Manipulating Files and Streams
19 The My Namespace
20 Advanced Language Features

Part IV Data Access with ADO.NET and LINQ
21 Introducing ADO.NET and DataSets
22 Introducing LINQ
23 LINQ to Objects
24 LINQ to SQL
25 LINQ to DataSets
26 Introducing ADO.NET Entity Framework
27 Manipulating XML Documents with LINQ and XML Literals

Part V Building Windows Desktop Applications
28 Creating WPF Applications
29 WPF Common Controls
30 Brushes, Styles, Templates, and Animations in WPF
31 Manipulating Media and Documents
32 Introducing Data-Binding
33 Localizing Applications

Part VI Building Web Applications
34 Building ASP.NET Web Applications
35 Publishing ASP.NET Web Applications
36 Building Rich Internet Applications with Silverlight 5
37 Building and Deploying Applications for Windows Azure
38 Building Apps for Windows Phone 7.5

Part VII Networking and Exposing Data Through Networks
39 Creating and Consuming WCF Services
40 Implementing and Consuming WCF Data Services

Part VIII Advanced .NET Framework with VB 2012
41 Serialization
42 Processes and Multithreading
43 Parallel Programming and Parallel LINQ
44 Asynchronous Programming
45 Working with Assemblies
46 Reflection
47 Coding Attributes
48 Platform Invokes and Interoperability with the COM Architecture
49 Documenting the Source Code with XML Comments

Part IX Applications Deployment
50 Understanding the Global Assembly Cache
51 Setup and Deployment Projects with InstallShield for Visual Studio
52 Deploying Applications with ClickOnce

Part X Mastering the Visual Studio 2012 IDE
53 Advanced IDE Features
54 Introducing the Visual Studio Extensibility
55 Advanced Analysis Tools
56 Testing Code with Unit Tests, Test-Driven Development, and Code Contracts
Appendix
A Useful Resources and Tools for Visual Basic