Microsoft recently made some significant enhancements to its Visio add-in for Excel, enabling users to create Visio diagrams from within Excel. Here's how it works.

Those who use Microsoft Excel only for organizing data into spreadsheets may not be taking advantage of the program's other features, such as the capability to create Venn diagrams and other graphics.

A script to generate PlantUML class diagrams from Excel exports of the Nyt SIS project’s information model, used in the implementation of a new Student Information System at Danish universities.

Use INDEX and MATCH for simple database queries in Excel. The bigger your spreadsheet, the more you need these, which you can combine with SUM, AVERAGE, and MAX to refine your searches.

Dynamic links with Microsoft Excel, provide constant access to data that reside in worksheets or other applications that can use Excel as a bridge to iThink and STELLA. Causal Loop Diagrams are ...