The Spreadsheet Page - By John Walkenbach Financial-Modelling.net - Tutorials, Courses, Trainings, Jobs and more 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. Array Formulas Many of the formulas described here are Array Formulas, which are a special type of formula in Excel. Array To Column Sometimes it is useful to convert an MxN array into a single column of data, for example for charting (a data series must be a single row or column). Averaging Values In A Range You can use Excel's built in =AVERAGE function to average a range of values. For the formulas given below, assume that our data is in the range A1:A60. Averaging Values Between Two Numbers Use the array formula =AVERAGE(IF((A1:A60>=Low)*(A1:A60<=High),A1:A60)) Where Low and High are the values between which you want to average. Averaging The Highest N Numbers In A Range To average the N largest numbers in a range, use the array formula Change "1:10" to "1:N" where N is the number of values to average. Holidays
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. Alternatively, you can skip the referencing and use late binding, defining the pointer to the Internet Explorer instance as Object instead of SHDocVw.InternetExplorer in your VBA code. Before you can do anything with the Internet Explorer, of course you'll need one, and you'll need something to address it.
E90E50 - Roberto Mensa's tricks FrankenSites E90E50fx - only formulas Articles and tutorials about formula challenges and our special formula solutions E90E50charts - our chart gallery 120+ unique Excel charts with sample files Excel collection Link collection:Useful, interesting and funny Excel stuff Graph Generator Write it as ... Adatkertészet Some Inga-knowledge shared in Hungarian 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". Next we'll use the Mid function. It will extract out characters in the middle of a string. Again, we want the Current Statement to be our new line. Drag it up one line and press F8. Move the mouse over "TheString," it now starts with Jane... Jane" in it. Now we have to check if there is a space after Jane, which is the sign that her last name is to follow. Add the following line after the last one line... TestString = Mid(TheString, 5, 1) Move the Current Statement, the yellow highlight, up to the new line and press F8. Move the mouse over TestString. They are a direct copy of the previous 3 lines except this one... Add the line...
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. Chandoo.org is partnering with Pristine to bring an excel financial modeling online training program for you. This is Part 1 of 6 on Financial Modeling using Excel In this and next 5 posts, we are going to learn how to build a financial model to do project evaluation using Excel. What is financial modeling? Financial modeling is creating a complete program/ structure, which helps you in coming to a decision regarding investment in a project/ company. Who does Financial Modeling? Anybody dealing with any decision related to money (wish there was somebody who did not require that!). What are the steps in building a financial model? Data collection – This is where the real front end banker works. One Advice for Aspiring Financial Modelers Speed is the Key: Finally when you are dealing with tons of information, you can easily get bored. What Next?
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 | Visual Basic 6 (VB6) - Nightly 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. There are some trade-offs in using the FSO with Visual Basic. To use the FSO with your VB project, you must add a reference to "Microsoft Scripting Runtime" (which is the system file "SCRRUN.DLL"). From the References dialog box, check Microsoft Scripting Runtime, as shown below, and click OK. Once you have done the above, you can use the FSO in your VB project. Dim objFSO As New Scripting.FileSystemObject Dim objFSO As Scripting.FileSystemObject Dim objFSO As Object FSO Objects
Free Microsoft Excel Spreadsheet Tips and Tutorials 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... I have been fortunate to be awarded MVP status, by Microsoft for 9 years and make my living entirely out of the IT industry, working as Managing Director of the UK arm of US Company Northern Tool + Equipment Co, MN. I hope you enjoy your visit and find what you're looking for. Thank you Nick Hodge Copyright Nick Hodge 2009.
Financial Modelling Domain - Fimodo