Reference Guides

From beginner to expert.  Crash courses, framing the well-known to explain the lesser-known.  Concisely and consistently explained.

 

Office/Excel Usage  Lesser-known characteristics of Excel that help avoid wasted time and facilitate functionality that might seem impractical or impossible.  Plus a listing of three simple code structures that make Macro recording more powerful.

    + Synopsis


Office/VB Development  Hard-to-find details about developing with VBA in general.  These include most-efficient control of event streams, and clear and safe code management.

    + Synopsis


Excel Development  Hard-to-find details about developing with Excel.  These include extensive characteristics of ranges and addresses, and behaviors and requirements of undo/redo.

    + Synopsis