All articles with 'design' Tag

Designing a Project Portfolio Dashboard [Part 1 of 2]

Published on Oct 25, 2012 in Project Management
Designing a Project Portfolio Dashboard [Part 1 of 2]

In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 will focus on user needs & design. Part 2 on Excel implementation.

Background
As you may know, we sell a set of Excel Project Management templates. These templates help plan, track, manage & report a project right from Excel.

While these templates good, they have one limitation. They work for one project at a time. Many customers have asked me if I come up with a project portfolio dashboard that can tell what is going on in a set of projects in one view.

And that is where we begin.

Continue »

How to become really awesome in Excel? [Reader Questions]

Published on May 10, 2010 in Learn Excel
How to become really awesome in Excel? [Reader Questions]

Yusuf, one of the blog readers emailed me and asked “how I can bebome an expert in Excel”. I gave him some advice based on what I know. But I think My advice can be improved too. So I turn to you.
What do you think a person should do to become really awesome in Excel?

Share your thoughts, ideas and suggestions using comments. Suggest blogs, websites or books or anything that can help Yusuf (and countless others) really good in using Excel to become awesome in their work.

Continue »

Member of month, Excel links and Cooked HDD

Published on Aug 11, 2009 in blogging, excel links
Member of month, Excel links and Cooked HDD

Starting this month I will announce one member of our little community as member of month. It is to honor the contribution they made.

Jeff Weir is our member of month for July, 2009. He not only commented more than 40 times in the last month, but he even wrote a marvelous guest post on the chart busters series. I have learned several valuable excel and charting tips from him in the past few weeks. I am sure some of have too. Thank you Jeff.

Also in the post we have some excel links worth checking.

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 »

5 Visualizations for Your Inspiration [Nov 14]

Published on Nov 15, 2008 in Cool Infographics & Data Visualizations
5 Visualizations for Your Inspiration [Nov 14]

Every Friday, PHD celebrates the art of chart making by posting 5 beautiful visualizations. These are truly outstanding visualizations providing good information and insights. Browse the last 4 weeks featured items by clicking these links: Visualizations for your inspiration [Nov 04] Must see info-graphics [Oct 31] 5 Beautiful Visualizations [Oct 24] Visualizations of the week […]

Continue »

How to NOT spend $ 150,000 and still dress up your charts

Published on Oct 28, 2008 in Charts and Graphs, Featured, Learn Excel
How to NOT spend $ 150,000 and still dress up your charts

By now everyone and their grandmother must have known about how Republican National Committee has spent $ 150,000 on Sarah Palin’s clothing and make up. I am a big fan of clothes. So much that I wear them everyday. But not all of us have a committee or fund raisers to dress up ourselves, none […]

Continue »

Introducing new design of Pointy Haired Dilbert

Published on Sep 2, 2008 in blogging
Introducing new design of Pointy Haired Dilbert

It has been a while since the blog’s look and feel has changed. The number of visitors to blog has been doubling for the last 2 months. I felt the need for a simpler but more elegant blog look and feel. So during the labor day weekend I have spent a few hours and changed […]

Continue »

Aligning charts, objects on spreadsheet [excel layout tip]

Published on Aug 28, 2008 in Learn Excel

Often when you are adding several charts to your report or project plan, it may be important to have them all aligned to a proper baseline – a fundamental design principle. Take a look at this: But if you try to select each chart individually and adjust the alignment, it may not provide correct results […]

Continue »

It is show time baby! – better designer clocks to display time in your spreadsheets

Published on Aug 19, 2008 in Charts and Graphs, ideas, Learn Excel

My polar clock using donut charts in excel started a conversation and readers have been awesome enough to download the excel and create their own clocks to show time. Even though the idea of this blog is share the little that I know with you, it is amazing how much I have learned from you […]

Continue »

Polar clock using donut chart [Excel Visualization fun]

Published on Aug 18, 2008 in Charts and Graphs, Featured, ideas, Learn Excel
Polar clock using donut chart [Excel Visualization fun]

Smashing Magazine is one of daily hangouts for new design ideas, inspiration and ogle fun. When they featured Pixel Breaker’s Polar clock last Friday on Top 10 creative ways to display time, I knew this could be an interesting visualization to do in excel. So I have created a donut chart in excel that can […]

Continue »

5 Infographics that can WOW you [Aug 7]

Published on Aug 7, 2008 in Cool Infographics & Data Visualizations

Time for another week of ogling at cool visualizations. What a week it has been for the chart makers 😉 Super cool visualization of 2008 Box office collection This is an area chart modified to indicate how a movie has performed everyweek, thus the movie markers go down (except for dark knight) after 1-2 weeks […]

Continue »