excel support, excel programmer, excel programming, excel macro

Excel Spreadsheet Modelling & Visual Basic Development, Excel Support

Excel Developer, Excel Programmer, Excel Programming, Excel macros : For a quote click here
Our Excel consultants offer excellence in Excel development for systems. We also provide support for existing spreadsheets via our screen-share facility. Our Excel development provision includes both spreadsheet modeling and Visual Basic programming, including the creation of bespoke custom =functions! Our skilled Excel developers combine mathematical modelling skills with Excel Programming using Visual Basic to create well-modelled spreadsheets with friendly interfaces.

Combining excellence in Excel modeling with Visual Basic programming:

User-friendly interfaces: ComboBox , ListBox , File-Browse facility, Pop-Up menus, tooltips
Formal analysis of required sheet structures; consideration given to single sheet versus multiple sheet 3D structure.
Consideration as to which aspects may be modeled using only spreadsheet formulas without the intervention of visual basic
Use of a wide spectrum of functions as required; multiple nesting of functions within a cell including: =sum, =min, =max, =count, =counta, =average, =dsum, =dmin, =dmax, =dcount, =dcounta, =daverage, =if, =vlookup, =hlookup, =match, =indirect, =rank, =left, =right, =mid, =isna, =iserr, =and, =or, =npv, =today, =date, =datevalue, =day, =month, =year
Development of Bespoke custom =functions where Excel's in-built functions are not sufficient!
Automated Menu-Driven Pivot Tables for analysis of data; "What If ...." Data Tables for sensitivity analysis of financial models
Use of event-driven visual basic, such as file opening, data changes, cursor movement, sheet access, mouse movement / operation
Use of visual basic generated forms and associated controls, such as buttons, text boxes, list boxes, spinners, combo boxes
Import / export of data in appropriate formats, such CSV, DBF, MDB under visual basic control ; Integration with Access

Integral Designs : Excel Developer, Excel Programmer, Excel Programming, Excel macros, Visual Basic Programming