'

Microsoft Excel is my best helper

Over the years no other software tool has helped my daily work as much as Microsoft Excel. I don't use Excel for financial work, but rather I use it for all kinds of computing tasks:It's very handy for doing network bandwidth computation.

Over the years no other software tool has helped my daily work as much as Microsoft Excel. I don't use Excel for financial work, but rather I use it for all kinds of computing tasks:

  • It's very handy for doing network bandwidth computation. When you have the right fomulae set up, just type in the numbers and get the results instantly.

  • Often, I write repetitious command-line scripts for Windows and Linux. With Excel I can easily type in a template and a substitution formula, copy it into multiple rows and generate a list of commands that I can execute in Windows or Linux. I use the "SUBSTITUTE" function in Excel to substitute different values into the template.

  • I use Excel to capture the requirements of programs with complex user interface flows. For some applications, documenting the requirements in the rows and columns of a spreadsheet feels much more natural than a list format. Through an Excel VB macro, I convert the requirements into .NET program code.

  • For some of my most complex applications, I use a third-party component like Aspose Cells to parse the spreadsheet and generate the output that I need.

  • In some projects, I integrate my Excel spreadsheets with Adobe Photoshop macros to create sophisticated visualisations.

  • I have also written applications in Excel for doing real-time polling and feedback via SMS.

Excel is probably one of the most versatile applications available today. Have you thought about using Excel to automate more of your daily tasks?