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.