Microsoft Excel Financial Modeling Course- Formatech

Information Technologies

hours

language

English

01 Range Names
+

02 Using Functions
+

Standard functions

Absolute and Relative References

Auditing Features

03 Financial Modeling Functions
+

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

04 Advanced data management
+

Validating cell entries

Creating data tables

05 Exporting and importing
+

Exporting and importing text files

Getting external data

06 Analytical tools
+

Goal Seek and Solver

Scenarios

07 PivotTables and PivotCharts
+

Working with PivotTables

Rearranging PivotTables

Formatting PivotTables

Using PivotCharts

minimize course outline