Snap XL
How can I catalog my Excel exhibits so that I can easily find and use them later?
Coolera has developed an Excel add-in called, “SnapXL” that allows users to catalog and version control exhibits, retrieve them later, and get back to the original underlying spreadsheet.
Excel to Database
How can I easily save my Excel data to a relational database?
Coolera has developed utility software that allows clients to save Excel data to a relational database structure. This is helpful for maintaining versions of numbers and for preparing data for downstream applications (e.g., Power BI) that prefer relational data over Excel.
Excel-based tools and methodologies
Excel is used by an estimated 750 million people worldwide. Satya Nadella has proclaimed it as Microsoft's most important consumer product.
- Leading Practice for Excel Development
Coolera developed a methodology that eliminates code changes that are required when the column order changes in a workbook. This saves time and enables an adaptive coding approach. - Database Connection Tools
Coolera has database connection tools that address the integration challenges faced by developers when connecting Excel to external sources. - Navigation
Coolera has developed a simple means of navigating multiple sheets that is visual for the user and easy for the developer to manage.