All articles with 'lists' Tag

Reverse a List using Formulas [Using Excel INDEX() Formula]

Published on Nov 19, 2009 in Excel Howtos, Learn Excel
Reverse a List using Formulas [Using Excel INDEX() Formula]

Here is a simple yet novel use of formulas. Let us say you have a list of values in range A1:A5 and you want to reverse the list. In an empty cell write =INDEX($A$1:$A$5,6-ROWS($A$1:A1)) and copy down. Boom, you get the reversed list. Here is how the formula works: In the reversed list, first item […]

Continue »

Making a chart with dynamic range of values

Published on Oct 15, 2009 in Charts and Graphs, Excel Howtos
Making a chart with dynamic range of values

We all know that to make a chart we must specify a range of values as input.

But what if our range is dynamic and keeps on growing or shrinking. You cant edit the chart input data ranges every time you add a row. Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows?

Well, you can do it very easily using excel formulas and named ranges. It costs just $1 per each change. 😉

Ofcourse not, there are 2 ways to do this. One is to use Excel Tables and another is to use OFFSET formula.

Continue »

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 »

Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)

Published on May 26, 2009 in Excel Howtos, Learn Excel
Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)

Do you know these excel 2007 productivity secrets? (1) How to turn on the clipboard pane so that you can do rapid copy pasting (2) How to lock a feature for repeated use (3) How to copy charts as pictures (4) How to features not on ribbon to the quick access tool bar (5) How to change the default file save settings so that excel always save files in earlier version and much more. Go ahead and read the secrets and become excel guru.

Continue »

5 Areas where Mouse Kicks Keyboard’s Butt

Published on Mar 2, 2009 in Featured, Learn Excel
5 Areas where Mouse Kicks Keyboard’s Butt

We are a big advocate of keyboard shortcuts. I think learning a handful of keyboard shortcuts can improve your productivity tremendously, whether you are using excel or firefox.

But using only keyboard shortcuts is like using only right hand. So, we have compiled 5 incredible ways mouse can help you be productive while using MS Excel.

Continue »

100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers

100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers

Hurray, PHD blog crossed 2000 RSS Subscriber base. This is a very significant milestone for me.

To celebrate this occasion we have a mega post: 100 Excel & Charting Tips, Tricks and Resources for you.

Continue »

Happy New Year to all PHD Readers

Published on Dec 31, 2008 in blogging, Featured, Learn Excel
Happy New Year to all PHD Readers

Happy New Year to all my readers. I am sure 2008 has been many things to many people, but I am hoping it has been an year of productivity and happiness for you. Here is to wishing a great, no, fantastic 2009 for you and your family.

Continue »

Excel 2007 Review – 10 things that WOWed me

Published on Dec 29, 2008 in Charts and Graphs, Featured, Learn Excel
Excel 2007 Review – 10 things that WOWed me

After a really long wait finally I have used … Excel 2007 (drum roll) and contrary to what many people think, I have found Excel 2007 to be a very well designed piece of software. Of course there are various issues with it and I am sure folks at MS are working on them so that next versions of MS Office are much more pleasant and simpler to use.

I wanted to share 10 wow factors in Excel 2007 that may convince you to try it.

Continue »

Ads that are also Infographics – 10 Dazzling Examples

Ads that are also Infographics – 10 Dazzling Examples

Advertisements and info-graphics can excite us a lot by their sheer ability to tell a story convincingly. What happens when you combine both? The results are dazzling… don’t believe me? Checkout these examples: Heineken Beer – How to get a girl in the bar – Flow chart Evening College from 5 – 10 PM – […]

Continue »

15 MS Excel Tips to Make you a Productivity Guru

Published on Oct 16, 2008 in Featured, Learn Excel

We all like to customize things, to personalize them so that we feel better, faster and smarter using them. Microsoft Excel is a perfect example of highly customizable software. It is simple to learn and use, and at the same time it is relatively easy to change the way it works for you. Here is […]

Continue »

Red vs. Blue – 35 Cool Visualizations on 2008 US Presidential Election

Red vs. Blue – 35 Cool Visualizations on 2008 US Presidential Election

With 2008 US Presidential elections around the corner everyone is busy including chart makers. There are hundreds of excellent visualizations on the presidential election campaign, speeches, issues, predictions that keeping track of what is best can be a tough task. We at PHD have compiled a list of 35 totally awesome visualizations on the 2008 […]

Continue »

Power Outage & 99 Excel Tips to keep you Busy

Published on Sep 16, 2008 in ideas, Learn Excel

We have a major power outage in Ohio due to a wind storm on Sunday. AEP, Our electric provider says that power would be restored to my area by this Friday midnight, that is almost 6 days without power. I will not be able to blog regularly during this period. So here is a list […]

Continue »

Microcharting in Excel – 7 Alternatives Reviewed

Published on Sep 5, 2008 in All Time Hits, Charts and Graphs, Featured, ideas, Learn Excel
Microcharting in Excel – 7 Alternatives Reviewed

With each passing day the amount of information contained in a single spreadsheet, slide, document is growing. Thanks to demanding bosses, clients and colleagues, we are now supposed to provide all the relevant information in as much less space as possible. This is where micro charting or light weight data exploration has become a rage. […]

Continue »