All articles in 'Learn Excel' Category

Welcome Robert & ClearlyAndSimply.com to Blogging

Published on Feb 19, 2009 in Charts and Graphs, excel links

Remember Robert, he is the author of the popular KPI Dashboard Series of posts on this blog. Now there is good news, he started a blog and writes about information dashboards, data visualization.

Continue »

Market Segmentation Charts using Conditional Formatting

Published on Feb 18, 2009 in Charts and Graphs, Learn Excel
Market Segmentation Charts using Conditional Formatting

Trust Peltier to come up with solutions for even the most impossible looking charts. Today he shares a marimekko chart tutorial. I couldn’t sit still after seeing his post. So here comes market segmentation charts or marimekko charts using, conditional formatting.

Continue »

Quickly Change Formulas Using Find / Replace

Published on Feb 17, 2009 in Learn Excel
Quickly Change Formulas Using Find / Replace

So you have built that excel report your boss wanted. And you were all eager to use the spreadsheet in your presentation. But in the last minute, your boss asked you to change average sales to total sales figures. You also want to grab an espresso before rushing to the meeting. Now what?

Continue »

“Too Many Worksheets” Driving You Nuts? Read This!

Published on Feb 16, 2009 in Excel Howtos, Featured, Learn Excel
“Too Many Worksheets” Driving You Nuts? Read This!

Learn how to create Table of Contents in Excel and other tricks to manage when you have too many worksheets.

Continue »

Excel Colors Somehow Getting Changed ?

Published on Feb 13, 2009 in Excel Howtos, Learn Excel
Excel Colors Somehow Getting Changed ?

Reader Raja asks about “how he can reset the colors in his workbook”. Read more to find out how you can fix this problem.

Continue »

Make a Dynamic Chart using Data Filters

Published on Feb 12, 2009 in Charts and Graphs, Learn Excel
Make a Dynamic Chart using Data Filters

As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excel

Continue »

Weekly Links – Even More Downloads Edition

Published on Feb 10, 2009 in excel links
Weekly Links – Even More Downloads Edition

This week, check out the updated excel downloads page and 5 interesting excel articles from around the web. Read more to learn about a mouse trick to paste values, how you can tweet from excel using user forms, an intuitive charting principle and more.

Continue »

Review of PTS Clustered Stack Chart

Published on Feb 9, 2009 in Charts and Graphs, Learn Excel
Review of PTS Clustered Stack Chart

My Friend and long time Microsoft Excel MVP, Jon Peltier has released a wonderful little excel charting utility called Cluster Stack Chart Utility. Out of curiosity I have mailed Jon and asked him if he could send me a copy of it so that I can review the product and recommend it to PHD reader community. He is kind enough to mail the add-in to me and here goes my review of the tool.

Continue »

Write Your Own Twitter Client using Microsoft Excel

Published on Feb 5, 2009 in excel apps, Featured, Learn Excel
Write Your Own Twitter Client using Microsoft Excel

Learn how you can write your own twitter client using Excel. All it takes is excel, internet connection and 5 minutes of spare time.

Continue »

Employee Satisfaction Surveys using MS Excel

Published on Feb 4, 2009 in Excel Howtos, Learn Excel
Employee Satisfaction Surveys using MS Excel

Today we will learn how to make an employee satisfaction survey and consolidate the data using excel.

Continue »

One more method to find unique values in excel and you can call me a dork

Published on Feb 3, 2009 in Excel Howtos, Learn Excel
One more method to find unique values in excel and you can call me a dork

Use Excel Pivot tables to find and extract unique items in your data. This method is very fast and easily scalable.

Continue »

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 »