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?