Anyone with an Office 365 subscription can use the Data Visualizer add-in to create Visio diagrams, use the underlying Excel data to modify diagrams; and view, print, and share diagrams.

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.

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.

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 ...

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.