EXCEL 2016 ADVANCED LAMINATED STUDY GUIDE
AuthorBARCHARTSPublisherBARCHARTSYear16BindingPBQuick and easy 6 page laminated guide with locations of functions and how to perform them in Excel 2016. Whether you are a beginner or experienced user, the advanced version is more coverage of the most popular and useful functions that users may even discover and use for the first time. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. Look for Excel 2016, Excel 2016 “Tips and Tricks”, “Formulas” and “Pivot Tables” QuickStudy guides to have a complete power-user reference set.
Topics covered include:
Conditional Formats
Highlighting Rules
Data Bar, Color Scale & Icon Set Formats
Managing Conditional Formats
Filer Data Using Slicers
What-If Analysis
Analyzing Data Using Scenarios
Calculating Alternatives Using Data Tables
Calculating Target Values Using Goal Seek
Finding Optimal Values Using Solver
Pivot Tables & Pivot Charts
Timelines
Excel Data Model
Suggested uses:
Workplace – flat for easy storage and access at a moments notice to find a function you need to use, or to jog your memory for a function you do not use often
Company Training – reduce help-desk calls and keep productivity flowing for a team or for your entire company
Students/Professors – make lives easier for students in many majors needing Excel for data management and calculation