Excel and VBA Examples
index001003.gif
logo8.gif
btn_vba_off.gif
btn_forum_off.gif
btn_cdorder_off.gif
btn_guestbook_off.gif
btn_home_on.gif
aboutme_off.gif
faq_off.gif
search_off.gif
links_off.gif
backgroundspace.gif
.
consulting_off.gif
xlmodeling_110x300_cd.jpg
interactive_off.gif
smallnew.gif
Please read the terms of use before proceeding
Interactive Online Excel Examples
 
This section contains interactive online examples that help user to learn both Excel functions and their applications.
Future Value
Financial Functions
Future Value On Annuity
Future Value On Annuity (Beginning and Ending Payment)
Present Value
Present Value On Annuity (Beginning and Ending Payment)
Frequent Asked Questions
Call - Buy
Investment - Options (Profit Table And Chart)  
Call - Write
Put - Buy
Put - Write
More To Come!
Covered Call - Write Call and Buy Stock
Protective Put - Buy Put and Buy Stock
Copyright ©
Anthony Sun
All Rights Reserved.
Bull Call Spreads (Buy One Call and Write One Call)
Bull Put Spreads (Buy One Put and Write One Put)
Bear Call Spreads (Buy One Call and Write One Call)
Bear Put Spreads (Buy One Put and Write One Put)
VLookup Function
General Functions
HLookup Function
Call Butterfly Spreads (Bear Call Spreads + Bull Call Spreads)
Put Butterfly Spreads (Bear Put Spreads + Bull Put Spreads)
CountIf and CountA Function
Present Value On Annuity
simulation.jpg
regression.jpg
Choose Function
Rank Function
portopt_120_90.gif
random.jpg
option.jpg