Quick and easy 6 page laminated guide focuses on creating and using formulas efficiently and effectively in Excel 2016. Whether you are a beginner or experienced user, formulas are Excel's superpower that can be yours. 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 use of formulas for users at different levels. Look for Excel 2016, Excel 2016 “Tips and Tricks”, “Advanced” and “Pivot Tables” QuickStudy guides to have a complete power-user reference set.
Topics covered include:
- Creating Formulas
- Using Tables in Formulas
- Organizing Data Using Named Ranges
- Summary & Statistical Functions
- Counting Values in Cell Ranges
- Performing Financial Calculations
- Principal & Interest Payments
- Calculating Present & Future Value
- Calculating Time to Reach an Investment Goal
- Calculating Net Present Value
- Performing Conditional Calculations Using IF & IFERROR
- Processing Text Using Formulas
- Performing Date Calculations
- Finding & Displaying Cell Values & Formula Text
- Division, Decimals & Rounding
- Auditing Formulas
Suggested uses:
- Workplace – flat for easy storage and access at a moments notice to find a formula 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
