Download or read book Learn Excel 2016 Expert Skills for Mac OS X with the Smart Method written by Mike Smart and published by Smart Method Limited. This book was released on 2016-03-08 with total page 368 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. You'll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way. Amongst other things you'll learn how to: Visually filter data using Slicers, master dynamic tables and structured table references, enforce complex business rules using function-driven custom validations, perform What-If analysis to model and compare business scenarios, use advanced functions to solve real-world business problems, create intuitive user interfaces using form controls , eliminate errors using Excel¿s advanced formula auditing tools, understand and use all of Excel¿s security features, design advanced Pivot Tables, create and use dynamic and table-based range names, record macros and then execute them from button controls, use Excel¿s three different sharing methods for efficient teamwork.