Basic Skills Of Working With Macros
o What A Macro Is Recording A Macro Using Absolute& Relative References
o Security Settings For Macros
o Running A Macro
o Deleting A Macro
Working With Running Macros Alternatives
o Assigning A Shortcut Key For A Macro
o Running Macros Using Photos
o Running Macros Using Command Buttons
o Creating Auto Open Macros
Working With Add-Ins Tools
o Using Conditional Sum, Lookup, And Data Analysis
Using Investment Functions
o PV & FV Functions
o RATE & NPER Functions
o PMT Function
o ISPMT Function
o IPMT Function
o PPMT Function
o IRR Function
o MIRR Function
o NPV Function
Working With Depreciation Functions
o SLN Function
o DB & DDB Functions
o VDB Function
o SYD Function