Skip to main content

MSExcel and the progress of technology

Once upon a time at the beginning of my career, I was poring over some data. That data happened to be in MS Excel. And I tried to sort it, sum it all of it to no avail.

I was facing a classic problem that we see. Whenever any new technology replaces an older one, we look for it to be incremental or the same. So, in this case, technology had replaced paper, but we were still using technology as paper. So, the spellings in the sheet were not organized, they were entered as text and there was no uniformity in the sheet at all. Hence most of the standard functions were useless, unless the sheet was cleaned up.

After about a week, I finally was able to produce a sheet that blew the minds of the people who saw it. And it was nothing great. Just totals, subtotals and a reverse sort by value. Which was difficult to come by in a paper mode, but far far easier when we move technologies.

Why did initial digital cameras have the sound of the shutter? Same reason.
Why does the ipad have a tap to mimic mechanical keyboards? Same reason.
Why are we thinking about sounds for new electric cars? Same reason. (On that note I believe there are better ways to for electric cars to develop – there is no real reason they need to look like IC engine cars from outside, but that’s a different rant for some other time)

Why do most MSPowerpoint presentations look just like digital flipcharts? Or why is MSPowerpoint itself like Flipcharts? And that’s why something Prezi is a smarter way to use the digital presentation medium!
Labels:

Comments

Post a Comment

Be Civil. Make nice!

Popular posts from this blog

The man who saved Pumpelsdrop

This was a story we had in college if I am not mistaken. Perhaps it was in school, but a delightful story it was. The story goes somewhat like this ( reproduced from here ), but the college version we had was slightly different from this.  I t was a dull, gloomy and a depressing morning in a town named Pumpelsdrop in northern England. The Great Depression had brought all the businesses to a standstill. The bored automobile dealer was spending time alone, as usual. But, this seems to be an unusual morning as an odd entity (customer) appeared on the horizon. A man in a bright suit walks up to the dealer and says, "I need to buy a Rolls Royce Phantom II. We have a business conference coming up and I need to impress my customers". Then proceeds to pay 10% of the deal with a single check for 2000 pounds. The rest he says will pay when he takes the delivery.   The auto dealer was stunned. He was delighted to hear that someone is holding a business conference of some kind and ...
Post a Comment
Read more

The Most Powerful Idea in the World

The above titled book by William Rosen (and I am still reading it) has set me thinking. As it goes through the industrial revolution (rather, the beginning of it) - it explores as to why the industrial revolution happened when it happened. Rather, how a lot of factors came to play in making it happen. For that alone this book is worth a read. It is worth reading how a 'dotcom' kind of ecosystem existed in England with the combination of tinkerers, rich patrons, correspondence and of course, the right kind of institutions. When one studies engineering, or even science, what we hear are the rock star stories. For instance, we know that Archimedes had a 'Eureka' moment. Likewise, in this book, I realized how a 'Eureka' moment helped James Watt resolve the problematic steam engine into a workable design. While it is very romantic to believe that discoveries happen accidentally, the fact remains that somebody like a James Watt (or others) slogged through many man...
Post a Comment
Read more

Narendra Modi, Presentation Skills

This is the latest speech by Narendra Modi which was delivered yesterday at the India Today Conclave. Much analysis has been carried out on this speech, but here is a different perspective. I have written about Presentation skills - and to me this is a video that touches upon almost all aspects of presentation skills. For someone who wants to learn public speaking, presentation skills this speech is a great example. It is well worth your time, if you want to see presentation skills in action (and the bonus of a great speech). The speech is largely in Hindi, though there are parts in English as well.  Mr. Modi uses a video at the start (which is missing here) - so the speech uses other media as well - surprising the audience - since politicians arent generally given to videos. That initial video has made the audience look forward to more. The speech is extempore - which can only happen when one knows the subject thoroughly. I personally don't know how much Mr. Modi practices...
1 comment
Read more