X
Business

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.
Written by Lee Lup Yuen, Contributor

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?

Editorial standards