Turning spreadsheets into business intelligence tools

Still can't quite get your spreadsheet to do what you want it to do? Here are some add-ons that can help.

Corel Visual Intelligence (Corel Quattro Pro, Microsoft Excel): Offered by Corel largely for its Quattro spreadsheet ' though it also works for Excel -- Visual Intelligence uses a variety of options for creating graphics, data visualizations, fast what-if analyses of spreadsheet data. It basically lets users play with the data, without the need of vast spreadsheet expertise, said Greg Wood, a communications manager for Corel.

Microsoft PerformancePoint (Microsoft Excel): PerformancePoint brings business intelligence capabilities to Microsoft Office. It can restructure the appearance of data into ways that make it more readily understood, said Mbwana Alliy, Microsoft product manager for Excel, Access and business intelligence. Users can establish and then monitor key performance indicators, as well as visualize information.

EditGrid Excel Plus (Excel): EditGrid is an online spreadsheet, with emphasis on drawing live data from the Web. EditGrid has introduced a beta of a plug-in that can stream the live data from EditGrid into users' versions of Excel.


LJZsoft XLReportGen 3.5.0 (Excel): XLReportGen is actually a collection of Excel templates for creating business intelligence reports. The templates provide the stylistic formatting as well as the Structured Query Language commands for drawing data from a relational database.


About the Author

Joab Jackson is the senior technology editor for Government Computer News.


  • business meeting (Monkey Business Images/Shutterstock.com)

    Civic tech volunteers help states with legacy systems

    As COVID-19 exposed vulnerabilities in state and local government IT systems, the newly formed U.S. Digital Response stepped in to help. Its successes offer insight into existing barriers and the future of the civic tech movement.

  • data analytics (Shutterstock.com)

    More visible data helps drive DOD decision-making

    CDOs in the Defense Department are opening up their data to take advantage of artificial intelligence and machine learning tools that help surface insights and improve decision-making.

Stay Connected