Information Technologies

Microsoft Excel Financial Modeling

hours

12

language

English

Topics Covered

  • Standard functions
  • Absolute and Relative References
  • Auditing Features
  • Different ways of summing and counting: SUMIF; SUMIFs; SUMPRODUCT; COUNTBLANK; COUNTIF.
  • Logical functions: AND; OR
  • IF Function
  • ERROR trapping: ISERROR; ISNUMBER; ISTEXT
  • Controlling appearance of numbers and text: TEXT; CONCATENATE; ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT; TRUNC; MOD
  • Dates: YEAR; MONTH; DAY; DATE; DAYS360
  • Lookup and reference: Index; MATCH; HLOOKUP; VLOOKUP; Yield; Price; Effect
  • PV, PV; NPV; IRR; PMT
  •  
  • Validating cell entries
  • Creating data tables
  • Exporting and importing text files
  • Getting external data
  • Goal Seek and Solver
  • Scenarios
  • Working with PivotTables
  • Rearranging PivotTables
  • Formatting PivotTables
  • Using PivotCharts
  • minimize course outline