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

SEI 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 SEI 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 SEIData Models to list in a column or row for fast report creation.
  • Access SEIPrompts defined on Data Model fields within SEI to help make accurate and quick selections of dimension data.
  • Easily share files with others.
  • Have all the security of SEI 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.