Wordt geladen...

Excel 2016 formulas and functions /

Bibliografische gegevens
Hoofdauteur: McFedries, Paul
Formaat: Printed Book
Gepubliceerd in: Noida: Pearson, 2017.
Reeks:MrExcel library
Onderwerpen:
Inhoudsopgave:
  • 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.