Loading...
Excel 2016 formulas and functions /
| Main Author: | |
|---|---|
| Format: | Printed Book |
| Published: |
Noida:
Pearson,
2017.
|
| Series: | MrExcel library
|
| Subjects: |
Table of Contents:
- Getting the most out of ranges
- Using range names
- Building basic formulas
- Creating advanced formulas
- Troubleshooting formulas
- Understanding functions
- Working with text functions
- Working with logical and information functions
- Working with lookup functions
- Working with date and time functions
- Working with math functions
- Working with statistical functions
- Analyzing data with tables
- Analyzing data with PivotTables
- Using Excel's business modeling tools
- Using regression to track trends and make forecasts
- Solving complex problems with Solver
- Building loan formulas
- Building investment formulas
- Building discount formulas.