All articles in 'Learn Excel' Category

[Reader Poll] Stacked, Seperated or Mirrored ?

Published on Jan 21, 2009 in Charts and Graphs, Learn Excel
[Reader Poll] Stacked, Seperated or Mirrored ?

Stacked bar charts are a popular way to depict 2 more series of related data, like sales of 2 products.But there are several ways to stack the bars in a bar chart. Here is a list of 6 ways to stack them

Continue »

Visualizing Search Terms on Travel Sites – Excel Dashboard

Published on Jan 19, 2009 in Charts and Graphs, Learn Excel
Visualizing Search Terms on Travel Sites –  Excel Dashboard

Microsoft excel bubble chart based Visualization to understand how various travel sites compete search terms

Continue »

Why No One Likes Your Pie Charts (And What to Do About It)

Published on Jan 16, 2009 in Charts and Graphs, Featured, Learn Excel
Why No One Likes Your Pie Charts (And What to Do About It)

9 charting tricks you can use to make your pie charts likable

Continue »

What are the formulas you wish Excel had ?

Published on Jan 13, 2009 in Featured, Learn Excel

Here is a list of formulas I wish MS Excel had. Alas, we need to build some work-arounds to solve them though.

Continue »

Excel Links of the Week [Jan 12]

Published on Jan 12, 2009 in excel links

Everyweek PHD shares some of the Excel links to help you learn better and become productive at using Excel. This weeks edition will help you with printing, creating named ranges, finding excel version.

Continue »

Sales Funnel Charts in Excel – Tutorial

Published on Jan 9, 2009 in Charts and Graphs, Learn Excel
Sales Funnel Charts in Excel – Tutorial

Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that project report.

Continue »

Automatically insert timestamps in excel sheet using formulas

Published on Jan 8, 2009 in Learn Excel
Automatically insert timestamps in excel sheet using formulas

Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate timestamps.

Continue »

Weekly Excel Links – Issues with Hosting of PHD

Published on Jan 6, 2009 in excel links

Over the weekend I got thinking about the various ways in which PHD can help you and I wonder if PHD should have forums. For one, forums are a great way to discuss ideas, find answers and develop community feeling. But at the same time, there are tons of very good excel forums that having another one may not really help. Currently I am leaning towards starting a forum to see how it goes. What do you think I should do ?

Continue »

Excel Basics – What are Combination Charts and How to Make One?

Published on Jan 5, 2009 in Charts and Graphs, Learn Excel
Excel Basics – What are Combination Charts and How to Make One?

A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph combination.

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 »

Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]

Published on Dec 30, 2008 in Learn Excel
Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]

Here is a very quick spreadcheat for the new year.

If you need to select all the cells in a series (either row-wise or or in columns) you can use one of these 2 shortcuts (and avoid unnecessary scrolling)

1. Select the first cell in the series

2. Press Shift + Ctrl + Down arrow

Or

1. Select the first cell in the series

2. Hold down SHIFT and Double click on the edge of cell in the direction you want to select

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 »

Excel Links of the week – the Christmas edition

Published on Dec 23, 2008 in excel links

It is the holiday week, that means less posts and more fun. We went to a friend’s wedding yesterday and had wonderful time. We are planning to celebrate Christmas at home with friends this year. How are you celebrating the holidays this year?

Continue »

Use Alt+Enter to get multiple lines in a cell [spreadcheats]

Published on Dec 19, 2008 in Learn Excel
Use Alt+Enter to get multiple lines in a cell [spreadcheats]

A very quick spreadcheat for Friday. If you need to type content in a cell and you want to see it multiple lines then use alt + enter to break the content in several lines. See to the right for an example.

Bonus tip: If you are using formulas to create content in a cell by combining various text values and you want to introduce line breaks at certain points … For eg. you are creating an address field by combining house number, street name, city and zip code and you want to introduce line breaks after house number and street name then you can use CHAR(10).

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 »