Learn Excel 2016 Essential Skills with the Smart Method : Courseware Tutorial for Self-Instruction to Beginner and Intermediate Level

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: Create stunning, professional, presentation-quality charts. Use Flash Fill to split, concatenate and format text and date values. Use Cloud Computing features to share data. Use the Versions feature to recover lost data. Understand absolute, relative and mixed cell references. Use Forecast Sheets to forecast future values from cyclical data. Use the Themes feature to create visually excellent worksheets. Use Sparklines to visually represent large data sets. Bring your data alive with Visualizations. Create custom conditional formatting rules with the Rules Manager. Create your own formulas with the Formula AutoComplete feature and master Excel 2016¿s Fluent User Interface and Ribbon.