Tabla de Contenidos:
  • Introductio
  • Mastering Excel ranges and formulas
  • Getting the most out of ranges
  • Using range names
  • Building basic formulas
  • Creating advanced formulas
  • Troubleshooting formulas
  • Harnessing the power of functions
  • 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
  • Building business models
  • 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 financial formulas
  • Building loan formulas
  • Building investment formulas
  • Building discount formulas
  • Index.