Excel Programming

An Excel Programmability blog by Gabhan Berry

Browse by Tags

Tagged Content List
  • Blog Post: Writing Custom Excel Worksheet Functions in C#

    Writing our own, custom worksheet functions is a great way to extend Excel. Before Excel 2002 we developed custom functions by either writing them using VBA inside an XLA or by using C/C++ inside an XLL. Excel 2002 introduced a new type of addin called an automation addin . An automation addin enables...
  • Blog Post: Using Statistics in Business Intelligence

    One other area I work in is Business Intelligence. These days BI is an important technology to an increasing number of companies. There are many great BI tools out there, one of which is (of course) Excel. One of the things that makes Excel such a useful BI tool is its richness of functionality. It...
Page 1 of 1 (2 items)