Products — for Mac and Windows


 

Free  Reference Guides

  

For Excel users:  A quick reference on lesser-known characteristics of Excel, to help you avoid frustration and wasted time, and to facilitate functionality that you might think is impractical or impossible.  Plus a listing of three simple code structures that make Macro recording more powerful.

  

For Excel developers:  Two quick references with hundreds of hard-to-find details about developing with Excel and with VBA in general.  These include quirks and workarounds of the Office development environment, most efficiently controlling event streams, and behaviors and requirements for undo/redo.

  

All of Magnafy’s Excel-based software is built on this knowledge.

   

 

 
    Yours to        keep.

    Yours to

       keep.

 
    Yours to        keep.

    Yours to

       keep.

 

   Highest quality utilities/tools:

You don’t have to worry about what Excel needs.  Keep focus on your real work.

Your tasks won’t have to take several steps.        Reduce effort, time, and errors.

   ➙  Cut costs in several ways.

 

 
 

The FLEXREF sheet function (could also be called EZLOOKUP):  provides an easy and flexible reference to a cell, allowing the column to be specified directly, and then the row to be specified based on a lookup in any other column.  Further provides up to 3 lookups in combination, and serial return of multiple matches.  Also, no match returns a null string (""), not an error.

 

    Yours to       keep.

    Yours to

      keep.

 
    Mac and Windows          Version 5.7

    Mac and Windows

         Version 5.7

    Mac and Windows          Version 4.2

    Mac and Windows

         Version 4.2

Providing smarter operations and a more-responsive environment.

Providing smarter operations and a more-responsive environment.

Saving countless hours of misdirection, research, and trial.

Saving countless hours of misdirection, research, and trial.

 

Services  (in New York City or remote)


    From enterprise software to web sites, commanding a wide array of technologies.

Project Management   Thorough, efficient project planning and execution.

Product Management   Creative, organized product designing and versioning.

Training   Expertise in Microsoft® Office usage and application development.

- Contact -