background preloader

Index of Help for Excel functions, graphs and testing

Index of Help for Excel functions, graphs and testing

Related:  Financial modelling

Introduction to Excel Financial Modeling - What is a Financial Model and how to build one? Posted on July 21st, 2010 in Featured , Financial Modeling , Learn Excel - 43 comments This is a guest post written by Paramdeep from Pristine. is partnering with Pristine to bring an excel financial modeling online training program for you. Using VBA Code to Find in String The first argument, [Start], is optional, as depicted by the brackets. It represents at what position or character we want to start the search in the string. The default is to start at the first character. The next argument is the string to search, in our case, "TheString". Followed by a comma, the third argument is what to search for, in our case, "Jane".

Excel Formulas Formulas NOTE: This page is no longer updated. Most of the topics here are now covered on other pages, or have pages of their own. However, I will leave this page intact and available. vba_corner: Working with Internet Explorer Using VBA - Nightly Ok, Excel probably isn't the first thing that comes to mind when needing to deal with web pages. But sometimes it's necessary to access them from your Excel Application (or Word or any other MS Office Application). And it's easier than you probably think. To make the following code work, you'll need to include the "Microsoft Internet Controls" library in your VBA references first.Go to your Visual Basic Editor, Menu Tools -> References... and select the entry "Microsoft Internet Controls". If you can't find it in the list of available references, search for a file named shdocvw.dll, usually to be found in your Windows directory, subfolder System32.

Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide Posted on May 6th, 2010 in All Time Hits , Analytics , Charts and Graphs , Excel Howtos , Featured , Huis , Learn Excel , Posts by Hui , simulation - 162 comments This is a Guest Post by Hui, an Excel Ninja and One of the Moderators of our Forums. Please note that this post is unusually large by standards. If anybody asks me what is the best function in excel I am drawn between Sumproduct and Data Tables, Both make handling large amounts of data a breeze, the only thing missing is the Spandex Pants and Red Cape! How often have you thought of or been asked “I’d like to know what our profit would be for a number of values of an input variable” or “Can I have a graph of Profit vs Cost vs …” This post is going to detail the use of the Data Table function within Excel, which can help you answer those questions and then so so much more.

Welcome to the community of GARP Affiliate Membership. Welcome to the community of GARP Affiliate Membership. Your choice to become an Affiliate member of this risk-aware community reflects an interest in understanding the issues surrounding managing risk, and a desire to connect with relevant information and with other risk professionals. As an Affiliate Member, you are entitled to certain benefits not available to those outside the GARP community, and will begin receiving valuable emails like Chapter meeting invitations, the Daily News and the Week in Risk immediately.

Nick Hodge's Excel Website Welcome to my Excel pages. These have been put together as a summary of my experiences with Microsoft Excel since version 5 in 1994. All data on here has been assembled using Excel 2003, FrontPage 2003, Windows XP SP2, Internet Explorer 6, but most should work in any browser/operating system and Excel versions from 97. Some of the code may also work in Excel versions before this, but the example files will not open in versions before 97. features available in Excel 2007 and hope to add some special stuff for this new version and a guide to where to find the old familiar features from your previous versions, shortly! Watch this space...

Excellaneous Introduction The latest (3rd) edition of Advanced Excel A textbook for a course in scientific data analysis A demo of what you can now do in Excel with Matrix and XN Incorporating Matrix and/or XN functions and macros in VBA Other features on this websiteProblems using the MacroBundle in Excel2007/2010 An improved macro for the first derivative Quasi-contour diagrams Additional aspects of surface graphs The color index Excel & VBA pitfalls Increasing computational precision The contents of the MacroBundle The contents of the other downloads The GNU General Public License The latest updates The downloads Introduction This website is meant for scientists and engineers who want to use the ubiquity, convenience and power of Excel, including its flexibility to go beyond the functionality already provided by Microsoft.

Using the FSO (File System Object) in VB6 The File System Object (FSO) object model provides an object-based tool for working with folders and files. Using "object.method" syntax, it exposes a comprehensive set of properties and methods to perform file system operations such as creating, moving, deleting, and providing information about folders and files. The FSO also provides methods for reading and writing sequential text files, however it does NOT have methods for processing binary or random files. The FSO is (or should be) used primarily with VBScript.

Certificate Program FREE site registration entitles you to: Exclusive Risk Management News and Market Data Research and White Papers Daily News Alert [share_ebook] Mastering Financial Modelling in MS Excel (pdf) Section), Please Wait For 5-8 Second. Then You Can Click On Skip Ads! Button. With every major choice we face we "run through the numbers" to guide our decision-making and legitimise the outcomes. Financial modelling helps managers to make more informed decisions and, crucially, win corporate commitment for those decisions.

MS Excel VBA Programming An extremely common question or subject brought up by many answerers on countless forum thread always comes back to compiling your VBA code. Why Compile VBA? The easiest answer is simply that it reviews your code to ensure it ‘sanitary/clean’ code.

Related:  Computer Skills