Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables

by

Zack Barresse and Kevin Jones

Holy Macro! Books

PO Box 82 Uniontown, OH 44685

Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables

© 2014 Holy Macro Books!

All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information or storage retrieval system without permission from the publisher. Every effort has been made to make this book as complete and accurate as possible, but no warranty or fitness is implied. The information is provided on an "as is" basis. The authors and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book.

Author: Zack Barresse and Kevin Jones

Editor: Kitty Wilson

Layout: Tyler Nash

Published by: Holy Macro! Books, PO Box 82 Uniontown, OH 44685, USA

Printed in USA

First printing: July 2014.

Cover Design: Emily Jones

Indexing: Nellie J. Liwam

ISBN 978-1-61547-028-0 (Print), 978-1-61547-219-2(PDF), 978-1-61547-340-3 (ePub), 978-1-61547-119-5 (Mobi)

Contents

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