Learn excel 2013 expert skills with the smart method/ Mike Smart.
Material type: TextPublication details: Douglas : The Smart Method Ltd, 2014.Description: 411 p. : ill. ; 30 cmISBN:- 1909253073
- 9781909253070
- 005.54 SMA
Item type | Current library | Call number | Copy number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|---|
Standard Loan | Moylish Library Main Collection | 005.54 SMA (Browse shelf(Opens below)) | 1 | Available | 39002100656421 |
Enhanced descriptions from Syndetics:
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: ¿ Use Excel 2013¿s new data model feature to create table relationships ¿ Master dynamic tables and structured table references ¿ Completely understand Excel 2013¿s new ability to create OLAP cubes ¿ Use Excel 2013¿s new OLAP Pivot Tables to present OLAP cube data ¿ Perform What-If analysis to model and compare business scenarios ¿ Record macros and then execute them from button controls ¿ Create intuitive user interfaces using form controls ¿ Enforce complex business rules using function-driven custom validations ¿ Use advanced functions to solve real-world business problems ¿ Understand and use all of Excel¿s security features ¿ Use Excel 2013¿s new timeline slicers to quickly filter date ranges ¿ Create and use dynamic and table-based range names
Includes index.