Microsoft fixes a bug it surreptitiously introduced last month that affected Excel 2010, 2013, and 2016, including Office 365 versions I figure we have enough patching fodder this month for two thick ...

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

Take advantage of an operational data store to consolidate data from across your organization and transform it for use in real time. Data is the lifeblood of the modern organization. It is constantly ...

What are Excel add-ins? Excel add-ins (also known as Excel add-ons) are applications that extend the usability of the Microsoft Excel spreadsheet software. These tools will help you find Excel ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...