Site Archives Excel

Excel 2013 Spreadsheet Inquire & Compare

As noted in recent blog posts, Office 2013 includes an add-in called Inquire. Inquire appears to be at least part of the Prodiance Spreadsheet IQ acquired by Microsoft at the end of 2010. Although presented as a 2013 add-in it appears the add-in is separate from Excel and even works in Excel 2007 and 2010 […]

Microsoft Office 2013 Preview

Today Microsoft announced Office 2013 and provided general access to a preview version. I’m delighted to come out from under wraps to report that ComplyXL supports Office 2013. The announcement was a webcast shown at noon PDT and led by Steve Ballmer. However the interesting stuff was presented by Kirk Koenigsbauer who demonstrated Office 2013 […]

OfficeOpenXml: Agile Encryption

Recently danyelljc contacted me to point out that the code associated with an earlier article did not include an example of using the “Agile Encryption” (see section – in MS-OFFCRYPTO) which is used as the default encryption in Office 2010. This post corrects my omission.

Free Excel add-in: Workbook Statistics

We’ve recently released a couple of free add-in which should be of use/interest professionals who use Excel. Sometimes it is helpful to be able to report statistics about the set of workbooks contained in folder. This add-in provides such a report and includes: A count of the number, text, logical and error constant (manually entered) […]

Free Excel add-in: Find Combinations

We’ve recently released a couple of free add-ins which should be of use/interest professionals who use Excel. Find Combinations allows you to find the set of cell values in a range you select which sum to a total you also specify. Find Combinations was originally created years ago as part of a utility which reconciled […]