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