All articles in 'Learn Excel' Category

Excel Links of the Week – Free E-Book Edition

Published on Mar 9, 2009 in blogging, excel links

Find out how you can get a free e-book on excel and charting in this week’s excel links.

Continue »

RSS Icon using Donut Charts – Because it is Weekend

Published on Mar 6, 2009 in Charts and Graphs, Learn Excel
RSS Icon using Donut Charts – Because it is Weekend

RSS Icon using Donut Charts – Because it is Weekend

Continue »

Open Thread For First Time Commenters – What do you like in Excel?

Published on Mar 5, 2009 in Learn Excel
Open Thread For First Time Commenters – What do you like in Excel?

If you have never commented on PHD this is your chance. Go ahead and comment and I will give you $1.00 discount on my Excel Formulas Help E-book.

The topic for the open thread is: What do you like in Microsoft Excel?

Continue »

Japanese Candlestick Chart – Excel Tutorial

Published on Mar 4, 2009 in Charts and Graphs, Learn Excel
Japanese Candlestick Chart – Excel Tutorial

Japanese Candlestick Chart or Candlestick Chart as they are popularly known are one of the most commonly used stock charts.Today we will learn how to make a candlestick chart in Microsoft Excel in 4 simple steps.

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 »

Weekly Excel Links – After a Long Time Edition

Published on Mar 2, 2009 in excel links

In this weeks edition, learn how to compare multiple items in a range using match, know how you can add more than one legend to a chart, include images in comments.

Continue »

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 »