WELCOME!

SpreadsheetWorld  provides leadership in the application of Excel, Visual Basic for Applications (VBA) and Excel/VBA-based tools to the professional fields of engineering, science, management and finance. SpreadsheetWorld and its strategic partners offer a broad array of products and services designed to fulfill that mission. Through the application of our processes, training and tools, SpreadsheetWorld clients realize a dramatic and immediate change in the scope and use of Excel and VBA to accomplish real-world problems. The scope is broadened and the use is dramatically increased. These changes provide our clients with impressive improvements in both immediate and long term productivity. Download tools as add-ins for use with your spreadsheets, receive tips and shortcuts, news, upcoming events, discuss topics with fellow members and much more. Sign up for our free e-newsletter and we will keep you updated on our toolboxes and courses! We recommend that you register on our site. Registered users are eligible for the following “members only” benefits and unlimited access to:    Free trial software    User forums If you have any questions or comments concerning the SpreadsheetWorld Web site, please forward them to webmaster@spreadsheetworld.com

Toll Free: 866 285 9068   Phone: 818 804 5130   Fax: 818 907 9437
Ó Copyright 2000-2008 - SpreadsheetWorld Inc. - All Rights Reserved | Contact Us | Privacy Policy

XLManager is our free Excel-based utility that administers the various toolboxes that are offered through SpreadsheetWorld, Inc.

Click to learn more!

 

XLThermal Fluids is an Excel/VBA/Fortran function for calculation of the 7 thermodynamic properties of common engineering fluids.

Click to learn more and download this Free toolbox!
 

New from UTS!

Click to learn more including free trial!

Spreadsheet-Aided Engineering - 576
This hands-on workshop has been presented over 100 times. It provides an in-depth foundation in the Spreadsheet Aided Engineering Series. The Excel/VBA working environment is used to establish Excel as a powerful platform for performing engineering system design, analysis, and optimization. Emphasis is placed on developing practices which lead to good worksheet field structures, development of reusable function libraries, and making maximum use of existing engineering toolboxes. General engineering system applicability is emphasized through the use of the Numerical Analysis Toolbox. This approach leads to methodologies, which are applicable to any engineering system. Participants are led through a structured approach to systems design, with the basic principle of object-oriented programming introduced along the way. The elements of Visual Basic are introduced while learning to extend the capability of working on the worksheet. Participants learn how to use UserForms and ActiveX controls to develop graphical user Interfaces which can be used to modularize and control inputs and system configuration choices. VBA is used to automate repetitive process such as goal seeking, charting, configuration change, data filtering, optimization, etc. (3-5-days - Mincer, Smith, Squier)

Visual Basic for Applications - 704
This hands-on workshop is designed for all Excel Power Users who want to learn VBA. It uses the Excel Object Model for learning the basics of VBA. Since Excel is the most popular VBA Application it is a logical choice to use for learning VBA fundamentals. Most objects in the Excel object model library are already recognized by users, which make it easier to relate to the object oriented concepts. This lays the foundation for moving on to object models of other applications and for integration and communication between object model libraries. The VBA language is covered in detail including data types, functions and sub-procedures, scope, arrays, control structures, variable naming convention, debugging, error trapping, file I/O, etc. It also covers the basics of application object models, as well as object properties, methods and events. Participants learn how to develop their own Userforms with supporting ActiveX controls to provide forms driven choices and project control. (3-Days)

Testimonials