Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables
- 2h 30m
- Kevin Jones, Zack Barresse
- Tickling Keys
- 2014
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.
About the Author
Zack Barresse is a self-taught Excel expert who contributes his knowledge to various online forums and blogs and who works with customers all over the world to develop business solutions using Excel and other Microsoft Office applications.
Kevin Jones is a developer of Excel and SQL Server applications for businesses. He has previously worked with American Management Systems, Apple Computer, Power Up Software, and Air Communications managing, designing, and building applications that incorporate innovative and practical user interface designs. He is a coauthor of Don’t Fear the Spreadsheet: A Beginner’s Guide to Overcoming Excel’s Frustrations.
In this Book
-
What are Tables?
-
Table Behavior and Anatomy
-
Working with Tables
-
Table Formulas
-
Pivoting with Tables
-
Sorting, Filtering, and Using Slicers
-
Table Formatting
-
Working with External Data
-
Automating Tables with VBA
-
Tables in Excel Online
-
Tables on Mac, iPad, and Office Mobile
