In the last newsletter, we introduced VBA and how it can transform Excel from a simple spreadsheet tool into a powerful automation tool. Today, let’s break down some basic programming concepts and ...

Yadullah Abidi is a Computer Science graduate from the University of Delhi and holds a postgraduate degree in Journalism from the Asian College of Journalism, Chennai. With over a decade of experience ...

You can use the Microsoft Excel 2013 XLL Software Development Kit and the C API to create high-performance worksheet functions for Excel 2013. The upgrades to the ...

As a data analyst, you have a lot of opportunities to process Excel files. At times you need to do the processing using a program. There are several scripting languages to choose. Here we compare them ...

Excel might be the world’s most widely used programming language; Microsoft is on a journey to turn it into a better and more powerful programming language, without losing what makes it Excel.