Basic Functionality

TMS Excel Toolbar is a versatile and powerful solution designed to automate various tasks and streamline workflows within Microsoft Excel. It provides users with efficient tools to import and export data, create reports, and perform advanced calculations. Here are the key features and benefits of the TMS Excel Toolbar:

1. Automated Data Updates: With just one click, users can update information in Excel, refresh Pivot-tables, and update reports, saving time and effort.

2. Data Import and Transformation: The toolbar offers efficient tools to filter and transform data, allowing users to perform advanced calculations and manipulate imported data as needed.

3. Integration of Multiple Data Sources: Users can easily concatenate different data sources to develop more sophisticated reports and insights.

4. Access to Data Services: By consuming data services, users can import essential information such as Central Bank fixings, average rates, and holiday information to enhance their analysis and reporting.

5. File Creation and Export: The toolbar enables users to create CSV or TXT files that follow preset formats, which can be easily shared or integrated with other systems or services, such as DTCC, RegisTR, or GL systems like IFS, Oracle, SAP, or UBW.

6. Compatibility with Various File Formats: The position-based or delimited file format support ensures seamless integration with a wide range of systems and services.

7. Efficient Reporting: During the data import phase, information is formatted, and Pivot-tables are updated, enabling users to leverage Excel's reporting capabilities to build advanced and customized reports.

In conclusion, the TMS Excel Toolbar is a comprehensive solution that enhances Microsoft Excel's capabilities, helping users automate tasks, import and export data, and create sophisticated reports. Its ability to integrate multiple data sources, utilize data services, and support various file formats makes it an invaluable tool for financial professionals and others who rely on Excel for data analysis and reporting.