Nectari and Excel working together

Microsoft Excel is an integral part of most business users to analyze financial data, log inventory, and much more. Accessing, analyzing and reporting on real-time enterprise data is often tedious, and time consuming with many limitations.

Nectari Add-in for Excel is an innovative solution that provides Excel users with a dynamic and powerful means of accessing real-time information within Excel, directly from their enterprise software database.

The Nectari Excel Add-in enables Excel users to:

• Access enterprise data securely in real-time or take advantage of our sophisticated shared caching system to further increase performance when accessing data that is updated on a fixed schedule.
• Create flexible ad-hoc reports by combining data from different disciplines of the enterprise into a single worksheet.
• Eliminate the need to manually update worksheets with the latest enterprise data.
• Summarize data using the Sum, Count, Average, Minimum, Maximum, or List operations.
• Set Parameters on Dimensions to help filter the data used within formula calculations.
• Automatically extract dimensional data from NectariData Models to list in a column or row for fast report creation.
• Access NectariPrompts defined on Data Model fields within Nectari to help make accurate and quick selections of dimension data.
• Easily share files with others.
• Have all the security of Nectari built into your Excel worksheets.
• Edit data and push it back to the database, for example, managing a budget within Excel.

The Excel Add-in can be installed and configured quickly. It integrates into Microsoft Excel’s user interface and can be used with new and existing Excel worksheets.