All articles in 'Learn Excel' Category
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 »
As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excelContinue »
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 »
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 »
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 »
Today we will learn how to make an employee satisfaction survey and consolidate the data using excel.Continue »
Use Excel Pivot tables to find and extract unique items in your data. This method is very fast and easily scalable.Continue »
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 »
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 »
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 »
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 »
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 »
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 BrowserContinue »
Excel trick to prevent users from un-hiding “hidden sheets” in an excel file.Continue »
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 themContinue »