All articles in 'Learn Excel' Category

Best of PHD – Jan 2009

Published on Feb 3, 2009 in blogging, Learn Excel

Here is a list of 5 best posts from Jan 2009. Automatically Insert Time Stamps in Excel [12 comments], Excel Formula Wish list [25 comments], 6 ways to stack your column charts [17 comments], Hide worksheet tabs in excel [14 comments], 100 Excel Tips & Resources [10 comments]

Continue »

PHD Excel Formula Helper – Now an E-Book

Published on Feb 2, 2009 in blogging, Learn Excel
PHD Excel Formula Helper – Now an E-Book

Remember the PHD Excel Formula Helper Tool? Good, now it is available as an e-book, so that you can take a print out of all the formulas or save it on your disk and learn formulas at leisure.

For 5 $ you can buy this e-book and read it at your leisure.

Continue »

[Weekend Poll] How do you Sex up your Charts?

Published on Jan 30, 2009 in Charts and Graphs, Learn Excel
[Weekend Poll] How do you Sex up your Charts?

This weekend, let us talk … umm… charts. I want to know if you absolutely make sure your charts look good every time you sent them out to someone. I do this most of the time.

How do you sex up your charts?

Continue »

Colors in Chart Labels [Quick Tip]

Published on Jan 29, 2009 in Charts and Graphs, Learn Excel
Colors in Chart Labels [Quick Tip]

A simple label formatting hack can improve the effectiveness of YoY change charts by adding color to differentiate positive vs. negative growth (or mediocre vs. sky rocketing growth rates). See this example:

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 »

Excel Links of the Week – Minor Changes to PHD edition

Published on Jan 26, 2009 in blogging, excel links
Excel Links of the Week – Minor Changes to PHD edition

There are some minor changes to PHD sidebar layout and feed address. Also, in this week’s featured links learn how to Understand Stock Charts in Excel, Choose the Right Chart Using this Flow Chart, Quickly Create Named Ranges using F4 Key, Print Multiple Areas by Creating a Consolidation Sheet and Get a List of Filenames in a Directory to Excel using Browser

Continue »

How to Hide Worksheet Tabs in Excel Workbook

Published on Jan 22, 2009 in Excel Howtos, Learn Excel
How to Hide Worksheet Tabs in Excel Workbook

Excel trick to prevent users from un-hiding “hidden sheets” in an excel file.

Continue »

[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 »