Mister Tech by Lee Lup Yuen
Always game to try new gadgets. Bring 'em on!

Microsoft Excel is my best helper

Mister Tech

Lee Lup Yuen

Always game to try new gadgets. Bring 'em on!

Events

IBM Technology Conference & Expo 2012
May 22, 2012

One World Hotel, First Avenue, Bandar Utama City Centre, 47800 Petaling Jaya, Selangor

Echelon 2012
June 11 and 12, 2012

University Cultural Centre, National University of Singapore

Startup Asia Jakarta 2012
June 7 and 8, 2012

12th Floor, Annex Building, Wisma Nusantara Complex, Jl. M.H. Thamrin No. 59 Jakarta 10350, Indonesia

MMA Forum Singapore
April 23-25, 2012

Grand Hyatt Singapore

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?

Talkback

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 March 1, 2012
Add your opinion

In order to post a comment, you need to be registered. (Sign In or register below)

Post your comment

ZDNet Asia Live

Mac users' indifference toward security 'worrying'. http://t.co/i7gZ8WVn

Mac users' indifference toward security 'worrying' - ZDNet Asia: Mac users' indifference toward security 'worryi... http://t.co/CD9pvW08

RT @zdnetasia: Mac users' indifference toward security 'worrying'. http://t.co/i7gZ8WVn

Mac users' indifference toward security 'worrying' - ZDNet Asia: USA TODAYMac users' indifference toward securit... http://t.co/4EUVidiO

Mac consumers indifferent about security, security vendors warn such mindset is "worrying" http://t.co/ZGIxdg67 #In

Mac users take note! RT @zdnetasia: Mac users' indifference toward security 'worrying'. http://t.co/YrLB9btb #mac #apple

RT @zdnetasia: Mac users' indifference toward security 'worrying'. http://t.co/i7gZ8WVn

Mac users' indifference toward security 'worrying': However, Mac users ZDNet Asia spoke to expressed indifferenc... http://t.co/15DulmWS

RT @jolintan: Mac users take note! RT @zdnetasia: Mac users' indifference toward security 'worrying'. http://t.co/2RQkfCKt #mac #apple

APAC tech merger and acquisition in Q1 down but value up: http://t.co/V7UkMABl

Mac users' indifference toward security 'worrying' - ZDNet Asia: Mac users' indifference toward security 'worryi... http://t.co/PINqvJxT

Mac users' indifference toward security 'worrying' - ZDNet Asia: Consumer TechMac users' indifferenc... http://t.co/wTeDnuW7 #ITSecurity

Mac users' indifference toward security 'worrying' - ZDNet Asia: Mac users' indifference toward security 'worryi... http://t.co/H6JlhYDU

Yahoo sells back 20% Alibaba stake for US$7.1B, now free to invest in China http://t.co/fsGZ6Aas #li

Mac users' indifference toward security 'worrying' - ZDNet Asia: Mac users' indifference toward security 'worryi... http://t.co/TbCMx54T

I reckon your view: "CRM is strategy, not software", if a company replicating the approach uses in ERP implementation into CRM, what they...

1 hour ago by wykoong on Gartner: Mobile CRM gives better ROI than social

This video will teach you about the Excel fill handle but also provide you with a workook to download... http://www.youtube.com/watch?v=...

18 hours ago by TradeBrother on A quick fill handle trick for Microsoft Excel

waiting...

2 days ago by eapete on What should count in a company's market value?

Boy, you've opened a can of worms now.

Wait for the rants & raves.

2 days ago by eapete on What should count in a company's market value?

I was puzzling before this whether to replicate the success formula we executed for a financial institute, and come out with a standard s...

3 days ago by wykoong on Drop the egos, copy ideas, then innovate