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.


  • Pierce County

    CARES dashboard ensures county spending delivers results

    The CARES Act Funding Outcomes Dashboard helps Pierce County, Wash., monitor funding and key performance indicators for public health emergency response, economic stabilization and recovery, community response and resilience, and essential government services.

  • smart city challenge

    AI-based traffic management improves mobility, saves fuel, cuts pollution

    Researchers are developing a dynamic feedback traffic signal control system that reduces corridor-level fuel consumption by 20% while maintaining a safe and efficient transportation environment.

Stay Connected

Sign up for our newsletter.

I agree to this site's Privacy Policy.