excel

New Course Notes Cover Excel 2013

A new edition has been published.  "Engineering Analysis &  Modeling with Excel VBA: Course Notes (Version 8.0)" is available in

paperback

and

kindle

format on amazon.com.  The course notes now cover Excel versions through 2013.  For Excel files containing worked-out copies of the exercises from the course notes, simply forward a copy of your course notes receipt (proof of purchase) to info@isothermtech.com with "Exercises" in the subject heading.

Isotherm Technologies LLC

Test Your Excel VBA Skills (Part 3 of 8)

This is the third in a series of eight posts to test your skills in Excel and its built in VBA programming environment.  Click here for an engineering application and practice exercise demonstrating the following Excel VBA design topics: Model Definition, System Decomposition,  Prototyping, Curve Fitting  (Continuous & Piecewise), Manual Digitizing, If-Then-Else, Select Case, Documenting Data & References.

Isotherm Technologies LLC

Test Your Excel VBA Skills (Part 2 of 8)

This is the second in a series of eight posts to test your skills in Excel and its built in VBA programming environment.  Click here for an engineering application and practice exercise demonstrating the following VBA introductory topics: Visual Basic Editor, Project & Properties, Modules, User Defined Functions, Sub Procedures, Debugging Tools, Programming Aids, Variables, Object Oriented Programming, Recording & Editing Macros, VBA Help, Putting Excel & VBA Together.

Isotherm Technologies LLC

Test Your Excel VBA Skills (Part 1 of 8)

This is the first in a series of eight posts to test your skills in Excel and its built in VBA programming environment.  Click here for an engineering application and practice exercise demonstrating the following basics: Autofill & Absolute References, Naming Cells & Ranges, Worksheet Structure & Linking, Cell Formatting, Equation Object, Add-Ins, Analysis ToolPak, Graphics, Functions (Built-In), and Settings.
Isotherm Technologies LLC

Thermal & Fluid Course Updated for Excel 2007

The next public offering of the short course "Thermal & Fluid Systems Modeling with Excel/VBA" will be offered June 16-18, 2009 in Beltsville, MD. The course has been completely updated for Excel 2007 while retaining all information for previous versions. An index of topics and a set of sample slides can be accessed at: Isotherm Technologies: Training. To see a full description of the course and register to attend, visit the ATI website at: Thermal & Fluid Systems Modeling course

Isotherm Technologies LLC

Excel Solver Guidelines

Excel ships with a powerful add-in for multi-parameter optimization called Solver. Although Solver is a very robust optimizer, there are some tips and pitfalls in its usage that are not documented in Excel. A report written by the authors of the Solver algorithm provides insight into the inner workings of the optimizer. From the report introduction:
"In designing the spreadsheet optimizer that is bundled with
Microsoft Excel, we and Microsoft made certain choices in designing
its user interface, model processing, and solution algorithms
for linear, nonlinear, and integer programs. We describe
some of the common pitfalls users encounter and remedies
available in the latest version of Microsoft Excel. The Solver
has many applications and great impact in industry and
education."
The full report can be accessed at: Isotherm Technologies: Resources

Isotherm Technologies LLC

Thermal & Fluid Systems Modeling Course

The next public offering of the course "Thermal & Fluid Systems Modeling with Excel/VBA" has been scheduled for June 16-18, 2009 in Beltsville, MD. This expanded 3-day course if for engineers, scientists, and others interested in developing custom thermal and fluid models using Excel and its built in programming language, Visual Basic for Applications (VBA). For more information on the course, or to register for the next offering, visit: www.aticourses.com

If you are interested in bringing the course onsite, or would like to suggest a location or date for another public offering, please send an email to info@isothermtech.com. Online votes received so far indicate Boston, Northern CA, Las Vegas, and Austin as potential public course locations.

Isotherm Technologies LLC

Excel Version Changes

The latest version of Microsoft Excel has some significant changes to the user interface. The standard menu format and toolbars have been replaced by a tabbed "ribbon". Microsoft has made some downloads and interactive resources available to aid in finding commands in the new interface at: Guides to the Office 2007 User Interface

Macros written with the built-in Visual Basic for Applications (VBA) are also affected in some cases. VBA related changes to be aware of include:
  • The "Developer" option must be chosen to create VBA code and ActiveX controls
  • Add-ins are now accessed from the "Office" icon in the upper left corner
  • Some objects are no longer accessed with the same commands in VBA
  • Documents saved in Excel's 2007 default format cannot contain macros
  • Saving files in earlier version formats (e.g. Excel 2003) preserves any macros
  • Macros are also retained in the template format
  • Security settings are more stringent requiring greater user interaction to enable macros
  • VBA will not be ported to 64-bit processors
  • 32-bit builds of the Office suite will include VBA and run on 64-bit processors.
  • The Macintosh 2008 version of Excel does not include VBA, although earlier versions do

Isotherm Technologies LLC