One of the designers of the official Microsoft Excel templates, all of which use tables, assists in introducing readers to tables’ many advantages in this book.
A Complete Guide For Creating Using and Automating Lists and Tables
by Zack Barresse and Kevin Jones, Excel MVP
Making tables in Excel makes formatting and reporting simpler, but for those unfamiliar with it, the new syntax it implies might be scary. One of the designers of the official Microsoft Excel templates, all of which use tables, assists in introducing readers to tables‘ many advantages in this article.
Before going on to slightly more complex topics like slicers and filtering, utilizing VBA macros, and using tables in the Excel web app, the book begins by describing tables, how to create them, and how they can be used in reporting. Both novice and experienced Excel users will find pertinent, helpful, and reliable information in this one-of-a-kind resource.
Table of Contents
- 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
Publisher: Holy Macro! Books
PDF ISBN: 978-1-61547-219-2
Be more productive at Excel and impress your BOSS!!