Microsoft Excel is my best helper

Microsoft Excel is my best helper

Summary: 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.

SHARE:
TOPICS: Software
2

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?

Topic: Software

Lee Lup Yuen

About Lee Lup Yuen

Lee Lup Yuen is passionate about mobile phones and PDAs, as he is constantly buying new gadgets and programming them in J2ME, .NET, Symbian and AppForge.
He has developed commercial applications with mobile technologies like SMS, MMS, WAP, 3G video streaming and location-based services.

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

2 comments
Log in or register to join the discussion
  • I suggest the option of shring excel sheet is a big concern I have. n for that i'll have to create a new Google sheet. While browsing came across few tools which says easier than Excel. Rather simplar than excel I am expecting it to be. It's CollateBox http://www.collatebox.com/ waiting for this one.
    KrisN10
  • Microsoft, Google, CollateBox- Race for the best tool..

    Hey Lee Yup Yuen, If you could please help me out in evaluating this one(collatebox), Checked their recent video http://bit.ly/PSApTq , If you could revert with your opinion on the same it would be great.
    Thanks KrisN for sharing..
    Atharton_CB