Excel Tables: A Complete Guide for Creating, Using, and Automating Lists and Tables is a comprehensive, detailed, and easy to follow book that guides Excellers on their quest to becoming data analysis gurus. We guarantee you will learn something new because we guarantee you are nowhere near as nerdy as we are. How else could we have written a 150 page book just on Excel tables!
These chapters of hidden gems show you how to take that simple list of data and instantly turn it into an Excel Table -- giving you access to simple yet powerful data management and analysis tools without having to be a database administrator or proficient with pivot tables.
And your list of data will instantly look like it was formatted by a graphic artist - and stay that way even after you try to mangle it by inserting and deleting rows and columns!
- Automatic formatting of header, data, and total rows including banding. Banding that looks good even when rows are hidden with filtering.
- Automatic total row generation with predefined aggregation formulas.
- Automatic maintenance of cell formatting and formulas as rows are inserted and deleted.
- Easily accessible controls to sort and filter rows by column - filtering that presents an extensive assortment of options for effortlessly filtering numbers, dates, and text.
- Integration with external data sources.
Excel tables are an awesome alternative to VBA, Pivot Tables, and Power Pivot. Think of Excel Table as an easy way to work with the most common form of data in Excel: a simple list with headers defining each column, but without having to resort to those more advanced and difficult to use power user tools. This book shows you how with easy and simple instructions and examples.
Table of Contents
- 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 and Excel Online
- 11. Tables on Mac, iPad, and Office Mobile
Per maggiori informazioni: il volume "Excel Tables - A Complete Guide For Creating Using and Automating Lists and Tables" di Zack Barresse e Kevin Jones, edito da Holy Macro! Books, è in vendita anche su IBS.it al prezzo di Euro 21,78.
Nessun commento:
Posta un commento