Product Information
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 namesProduct Identifiers
PublisherT.H.E. Smart Method LTD
ISBN-101909253073
ISBN-139781909253070
eBay Product ID (ePID)209527328
Product Key Features
Number of Pages416 Pages
LanguageEnglish
Publication NameLearn Excel 2013 Expert Skills with the Smart Method : Courseware Tutorial Teaching Advanced Techniques
Publication Year2014
SubjectComputers & Technology, Mathematical & Statistical Software, Desktop Applications / Spreadsheets, Enterprise Applications / General
TypeTextbook
AuthorMike Smart
Subject AreaComputers, Education
Dimensions
Item Height0.7 in
Item Weight34.2 oz.
Item Length11.7 in
Item Width8.3 in