fbpx
Search
Close this search box.

All articles with 'technology' Tag

Windows Mojave Experiment Kicks Ass

Published on Jul 30, 2008 in advertising, business, ideas, technology

Wow, this is totally cool. A great lesson in creating buzz. The folks at windows vista wanted to convince people that Vista is indeed a good operating system and upgradable from XP. But there are lot of bad opinions floating around and end users are more or less confused about it. Personally I have rarely […]

Continue »

Mute conversations in Gmail to not follow a specific thread of mails

Published on Jul 24, 2008 in hacks, technology

Do you know that you can mute conversations in gmail if you are do not want to see that lengthy thread on single subjected that people wont give up. Just select the mail / conversation you want to mute Click on “More actions” and select “mute” Enjoy the bliss If you want search for muted […]

Continue »

Watch out if you are buying insurance online at GEICO – your password is not encrypted

Published on Jul 23, 2008 in america, business, technology, wonder why

I have noticed something totally strange while trying to get an auto insurance quote online at GEICO. See it for yourself. They are showing your password in the URL… OMG 😮 Make sure you don’t use the site for getting new quotes as it could be a potential privacy breach as anyone watching the URLs […]

Continue »

Changing Sort Orientation in Excel – Sorting across columns instead of rows

Published on Jul 22, 2008 in hacks, Learn Excel, technology

change-sort-orientation-excel-columns You can sort data across columns instead of rows by changing sort options. If you ever had to sort across columns now you know a simple way to do this 🙂 Follow these steps for changing sort orientation: Select the table you want to sort (just the data, not the headers as when you […]

Continue »

Google Maps adds directions by Public Transport – Wow

Published on Jul 22, 2008 in ideas, technology

Wow, this is awesome. Google maps has added directions by public transport. Sometime back when they integrated public transport timings along with bus-stop / train station icons, it was pretty cool, but adding directions based on bus / train routes is totally awesome. Try it for yourself, click here to see a sample direction.

Continue »

Excel Bullet Graphs

Excel Bullet Graphs

Bullet graphs provide an effective way to dashboard target vs. actual performance data, the bread and butter of corporate analytics. Howmuchever effective they are, the sad truth is there is no one easy way to do them in excel. I have prepared a short tutorial that can make you a dashboard ninja without writing extensive […]

Continue »

Awesome folks at flickr introduce instant zoom for photos

Published on Jul 18, 2008 in pics, technology

Wow, this is one of the coolest features on flickr, you can use instant zoom to see finer details of pics (the ones which have all sizes allowed for anyone).

Continue »

Improve your in-cell charts with colors and negative values

Published on Jul 17, 2008 in Charts and Graphs, hacks, ideas, Learn Excel, technology
Improve your in-cell charts with colors and negative values

In response to Making Incell charts better article, reader Tony mailed me an excel sheet in which he has modified the charts to display colors and negative values. This is pretty cool. Take a look at the chart below: The trick lies in displaying the charts in 2 rows, one for positive values and another […]

Continue »

Bingo / Housie Ticket Generator in Excel

Published on Jul 16, 2008 in Analytics, Learn Excel
Bingo / Housie Ticket Generator in Excel

I am fascinated by board games. They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money. That is why whenever I get sometime I experiment with simulating games to know them better. So, out of curiosity I have created an excel sheet that can generate bingo / housie (housey) tickets – 24 of them at a time. To get new set of tickets you would hit F9 (recalculate).

Continue »

Use Google docs to track your bucks – [spreadsheet forms idea]

Published on Jul 14, 2008 in hacks, ideas, Learn Excel, personal finance, technology

Each of us have our mechanisms to track how we spend money. We use Excel, various online sites and software like Quicken or Microsoft Money to track how we spend our bucks. The bottom line is to track where each penny / paisa / cent is going. So, how great would be it be, if […]

Continue »

myRoom.makeSuperCool()

Published on Jul 11, 2008 in Featured, hacks, Humor, ideas, technology

How geeky are you? Show off your geekness to others with this kickass room decor ideas, Just click the images to follow up. live geek, love geek 😀 1. Lets start with the door. You can experiment with the door locks to create your own puzzle: 2. Now that you are in how geeky would […]

Continue »

Partition Charts in Excel – alternative to pie charts [visualization hack]

Published on Jul 9, 2008 in Analytics, Charts and Graphs, hacks, ideas, Learn Excel, technology
Partition Charts in Excel – alternative to pie charts [visualization hack]

Next time you had to create a pie chart, consider building a partition chart as these charts can reveal trend information along with how much each pie is contributing. What more? They are as easy to create as eating a chocolate chip cookie dough ice cream 🙂 I made a sample partition chart based on […]

Continue »

Skip weekends while autofilling dates in excel

Published on Jun 30, 2008 in hacks, Learn Excel, technology

Often you may want to fill a column only with weekday dates instead of all dates. Here is a simple trick you can use instead of writing nifty if formulas or manually entering the weekday dates. When you auto fill dates by dragging mouse (or using menu > edit > fill > series > selecting […]

Continue »

Hot Thermometer Charts in Excel – here is a cool way to do them

Published on Jun 26, 2008 in Charts and Graphs, Featured, hacks, ideas, Learn Excel, technology
Hot Thermometer Charts in Excel – here is a cool way to do them

Let us learn a simple charting hack to create a thermo-meter chart in excel. This type of charts can be effective in communicating one data point, they can make excellent presentation slide or dashboard widget. What more, they are as simple to do as adding whipped cream to your latte. So lets begin: 1. First […]

Continue »

Get Stock Quotes in Excel

Published on Jun 24, 2008 in america, hacks, Learn Excel, technology

While trying to spell check one my sheets I have learned this cool trick to fetch real time stock quotes without any webqueries or vba or anything. First enter the stock code in a cell (this works for US stocks only), for eg. AAPL for Apple, MSFT for Microsoft etc. Then ALT+CLICK on that cell, […]

Continue »