MrExcel.com - Your One Stop for Excel Tips & Solutions

Excel Tables

September 2014

Excel Tables

Take advantage of the Table functionality in Excel

Who knew that pressing Ctrl+T unleashed such power?

Bill Jelen, MrExcel
Add to Cart: $9.99 »
by Zack Barresse, Kevin Jones
category: Spreadsheets
covers: Microsoft 365, Excel 2010 - 2016
Product Details
  • 160 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-028-0
  • PDF ISBN: 978-1-61547-219-2

Inspired by the millions of Excellers who often underestimate the power of Tables, this book aims to increase the knowledge and skill levels of everyday Excel heroes, junkies, and anyone else who uses Excel to make their work and personal life more productive. It will help you become more proficient with Excel Tables in their current form. It will also help you learn the strengths and weaknesses of Excel Tables and how you can leverage their functionality to empower a more rich and productive overall experience. This book is written for all skill levels; anyone can benefit from it, from a novice who doesn't know what a Table is to an expert who has experience with formulas and automation using VBA.

  1. Foreword
  2. Introduction
  3. What Are Tables?
  4. Table Behavior and Anatomy
  5. Working with Tables
  6. Table Formulas
  7. Pivoting with Tables
  8. Sorting, Filtering, and Using Slicers
  9. Table Formatting
  10. Working with External Data
  11. Automating Tables with VBA
  12. Tables in Excel Online
  13. Tables on Mac, iPad, and Office Mobile

Where to Buy

MrExcel Bookstore

eBook from MrExcel.

Add to Cart: $9.99 »
Amazon

Print book from Amazon.

Buy Now »

Related Products

Slaying Excel Dragons

Slaying Excel Dragons

February 2011

This enthusiastic introduction provides support for Excel beginners and focuses on using the program immediately for maximum efficiency. With explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations that come with using the program for the first time.

Pivot Table Data Crunching: Microsoft Excel 2016

Pivot Table Data Crunching: Microsoft Excel 2016

November 2015

Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.