All articles with 'cell' Tag

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]

Published on Aug 24, 2009 in Excel Howtos, Featured, Learn Excel

It is no exaggeration that knowing excel formulas can give you a career boost. From someone starting at the long list of numbers, you can suddenly become a data god who can lookup, manipulate and analyze any spreadsheet.

So when our little excel blog hit the 5000 RSS Subscriber milestone, I celebrated the occasion by asking you to share an excel formula through twitter or comments with rest of us. And boy, what an excellent list of formula tips you have shared with us all.
Here is the complete list of entries for the twitter formula contest.

Continue »

Creating Excel Art from Images [spreadsheet fun]

Published on Dec 17, 2008 in Charts and Graphs, Learn Excel
Creating Excel Art from Images [spreadsheet fun]

Amit at Digital Inspiration features a lengthy way of creating beautiful excel cell art from an image. I guess we all can use a method that is little simpler and smarter.

Continue »

Free Excel Calendar Template for year 2009 (and all years up to 9999)

Published on Dec 4, 2008 in Featured, Learn Excel, personal
Free Excel Calendar Template for year 2009 (and all years up to 9999)

Free excel calendar template for year 2009 (well, it works for any year all the way up to 9999)

Go ahead and download it, change the year number in the first sheet to 1981 or something and see the magic.

Continue »

Custom Cell Formatting in Excel – Few Tips & Tricks

Published on Feb 25, 2008 in Charts and Graphs, Featured, hacks, Learn Excel

The other day I had to make an excel sheet for tracking all errors across one of the applications we are doing for our customer. The format was something like this, We wanted to use a consistent message id format [4 digits: 0001, 0002, … , 1000 etc.]. Now I do not want to type […]

Continue »