Excel tables: a complete guide for creating, using and automating lists and tables

Description

Title Page -- Copyright page -- Preface/ Forward/ Intro -- First Chapter -- Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables -- Foreword -- Introduction -- 1 What Are Tables? -- 2 Table Behavior and Anatomy -- 3 Working with Tables -- 4 Table Formulas -- 5 Pivoting with Tables -- 6 Sorting, Filtering, and Using Slicers -- 7 Table Formatting -- 8 Working with External Data -- 9 Automating Tables with VBA -- 10 Tables in Excel Online -- 11 Tables on Mac, iPad, and Office Mobile.;"Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it implies can be intimidating to the uninitiated. In this guide, one of the developers of the official Microsoft Excel 2013 templates--all of which employ tables--helps introduce readers to the multiple benefits of tables. The book begins by explaining what tables are, how to create them, and how they can be used in reporting before moving on to slightly more advanced topics, including slicers and filtering, working with VBA macros, and using tables in the Excel web app. Novice Excel users and experts alike will find relevant, useful, and authoritative information in this one-of-a-kind resource."-- Title Page -- Copyright page -- Preface/ Forward/ Intro -- First Chapter -- Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables -- Foreword -- Introduction -- 1 What Are Tables? -- 2 Table Behavior and Anatomy -- 3 Working with Tables -- 4 Table Formulas -- 5 Pivoting with Tables -- 6 Sorting, Filtering, and Using Slicers -- 7 Table Formatting -- 8 Working with External Data -- 9 Automating Tables with VBA -- 10 Tables in Excel Online -- 11 Tables on Mac, iPad, and Office Mobile.