Quick and easy 6 page laminated guide loaded with essential functions
and how to perform them in Excel 365 (and Excel 2019). Beginners and
experienced users, can find hundreds of the most popular and useful
functions fast with clear succinct steps to get the task done. 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 365, Excel 365 "Tips and Tricks", "Formulas" and
"Pivot Tables" QuickStudy guides to have a complete power-user reference
set.
6 page laminated reference guide includes:
- 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
- Data Validation
- Sparklines
Suggested uses:
- Workspace - 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
