Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables
Product Description
Excel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables
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.
Technical Specifications
You might also like
Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
MrExcel XL: The 40 Greatest Excel Tips of All Time
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
Excel 2016 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
Excel 2016 Pivot Table Data Crunching (includes Content Update Program) (MrExcel Library)
Mastering Excel: User Forms
Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI
Excel 2016 Formulas (Mr. Spreadsheet's Bookshelf)
Ctrl+Shift+Enter Mastering Excel Array Formulas: Do the Impossible with Excel Formulas Thanks to Array Formula Magic
Excel Conditional Formatting: Tips You Can Use Immediately To Make Your Data Stand Out (Data Analysis With Excel Book 3)